Search:

Your query...


SELECT
dudes.dude_id,
dudes.dude_name,
dudes_cars.car_name
FROM dudes
LEFT JOIN dudes_cars
ON (dudes_cars.owner_dude_id = dudes.dude_id AND...

try converting balance to a float or double first.... perhaps you're coercing 1.0003 to become an integer somehow (in which case it will probably just be 1 and do nothing).

There are some tools OTS (off the shelf proprietary) that slaughter the database schema (it's a disgusting design), but it works like a freaking charm when it comes down to not even touching SQL... I...

I think you should jump onboard and see how deep the rabbit hole goes :D
but that may just be my courageous youth talking


also, if you're using some type of version control.... he should have...

If you're wanting to do dynamically named columns (which is OK, and I typically do this when someone wants a "report" they could use in excel or whatever), you'll need to use at least two queries if...

From dev.mysql.com:


example:


mysql> CREATE TABLE t1 (
-> a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> message CHAR(20)) ENGINE=MyISAM;
mysql> CREATE TABLE t2 (

prepend your script with:



<?php
ini_set("display_errors", 1);
error_reporting(E_ALL);

none that I can see.

http://php.net/manual/en/language.references.return.php

it's returning a reference to a static value. Keep in mind PHP uses a reference counting system for garbage collection. I don't see any...

That is very odd. It is typically called the referencing operator, (a reference to a value in memory as opposed to a value itself).

I'm not sure what it means in this situation... What PHP...

Access denied for user 'myrealusername'@'localhost' (using password: YES)

try chaning localhost to 127.0.0.1

They may appear to be the same in any other situation, but for MySQL they are very...

You shouldn't use an API when you already have existing data on your machine to do this.
/usr/share/GeoIP/GeoIP.dat

you can use apache2's mod_geoip (apt-get install apache2-mod-geoip or yum...

you could serialize the data and write it to a seperate file instead of trying to write it in a configuration file format. It seems like the sensible tool to use in this situation.

wat...

ok you get putty, log in with your "SFTP" credential (SFTP meaning... ftp over ssh). So ssh will spawn a shell (probably bash or sh), and you can use "cp" the copy command,
cp <src> <dst>...

You can use the "cp" command from ssh+[ba]sh. That would make the most sense and would be exceptionally faster than using FTP to copy files.

In most SQL flavors, you can not expect an aliased column to behave like a real column. This would drastically change the execution plan of MySQL in an undesirable way. The work-around is to replace...

SELECT
ver_data_media.id,
ver_data_media.value,
ver_data_media.ref,
ver_data_media.type,
ver_data_rating.a

FROM ver_data_media LEFT JOIN ver_data_rating
ON...

Try this script I made for you, it looks a bit more robust to me.

If you want to skip the first record, just use fgetcsv() on the csv and don't store the row of values anywhere (just toss it out)....

A) it looks like you're trying to find more developing to do. I don't see any problem with this unless you're constantly editing these outgoing emails every day, even so... I don't see why an editor...

Try some alternatives to DreamWeaver... firefox+firebug, eclipse, vim, emacs... DreamWeaver is just marketed really really hard, because Adobe makes a lot of money off of it. I think there are many...

I'm a huge fan of SQL-SERVER, it's the only M$ software I really think they did amazingly well. When I was working with SQL-SERVER 05 and 08: I used AquaData Studio. It's not the best, but their...

This is an awful problem to solve using PHP. Why don't you just put your NIC in promiscuous mode and log all of the incoming traffix on X port / forwarded traffic?

Too complicated? Use...

You would want to make a table of possible things that can be checked off.

This is very basic sql, you need to read more about sql and relational databases. It is very important. Hint:...

gross, what is all that obscure undocumented functionality you're using.

There are some fancier mathematical ways to do it (naming each field after a unique prime number and checking that the...

I personally use eclipse and the JavaDoc strings above all of the signatures/variables/classes. Then click generate documentation, if you didn't already tell eclipse where to put it, it will ask and...