Yet another PHP/MySQL problem...

[piersk]

Tch! I dunno, you think you can write a simple query, but it doesn't really work!!

I have this:

$faultQuery = "select * from fault order by fault_id desc";
$faultResult = mysql_query($faultQuery,$configDbConnect) or die("Error here");

and of course, I keep getting "Error here" (yes I WILL be changing that, its just something to put in there for the time being).

Anyone got any ideas??

[philipolson]

Yeah, change it to die(mysql_error());

[[deleted]]

Chech that proper database was called, and table fault, field fault_id are in that database.

$configDbConnect = mysql_connect("localhost", "user", "password");

mysql_select_db("test",$configDbConnect) or die("Database not found");

$faultQuery = "SELECT * FROM fault ORDER BY fault_id DESC";

$faultResult = mysql_query($faultQuery,$configDbConnect) or die("No data found");

[piersk]

Cheers guys. Boy do I feel stupid now.