query problem

[watts]

Hi,
I'm getting an error when I try to run this code. It says "mysql_fetch_array(): supplied argument is not a valid MySQL result resource"

I can't figure it out because the syntax is the same (I think) as a different query that is working.

$queryCa = "SELECT * categories WHERE catID=$catID";
$resultCa = mysql_query($queryCa);
$rowCa = mysql_fetch_array($resultCa,MYSQL_ASSOC);
extract ($rowCa);

Any ideas?

Watts

[devinemke]

you are missing the word "FROM"

[watts]

lol, wow I can't believe I didn't catch that.

Thanks