[SOLVED] PHP connects to MySQL, but query won't work...

[Neureo]

Hey.

 

I'm using this code:

<?php 

$db = mysql_connect($dbhost, $dbuser, $dbpassword); 
mysql_select_db($dbdatabase, $db); 

$sql = "SELECT entries.*, categories.cat FROM entries, catories 
WHERE entries.cat_id = categories.id 
ORDER BY dateposted DESC 
LIMIT 1"; 

$result = mysql_query($sql); 
$row = mysql_fetch_assoc($result); 

?>

 

...but when I run the code, I get this error:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/blog/index.php on line 10

 

Everything is running smoothly, I tested the connection, etc...

Anyone know why this is happening?

[cooldude832]

maybe cause your query is failling.

 

If you are debugging a query always write them like

 

<?php
$q = "Select * from `table";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
?>

[Neureo]

Hey, thanks. Turns out it was a simple misspelling... XP I'll always remember to put "die" after my queries. You're awesome.