[RESOLVED] SQL Query Error

[rsmith]

This is simple but I cannot figure out the cause of the error:

<?
   $query = mysql_query("SELECT metaDescription, metaKeywords from General" or die("Could not retrieve data\nError: ".mysql_error()));
   $meta = mysql_fetch_assoc($query);
?>

Gives me an invalid SQL resource when I run the mysql_fetch_assoc(). I'm probably missing the obvious.

TIA!

[suntra]

$query = mysql_query("SELECT metaDescription, metaKeywords from General") or die("Could not retrieve data\nError: ".mysql_error()); 

[redrage]

Do you have a MySQL Connection established already? chances are you do but figured i would ask.

[Piranha]

Suntra's solution works, but this one adds a few more things.

<?php     // Never use short tags.
   $sql = "SELECT metaDescription, metaKeywords from General";  // First create the query string, easier to debug that way.
//   echo $sql;       // Debugging if needed
   $query = mysql_query($sql) or die("Could not retrieve data\nError: ".mysql_error());
   $meta = mysql_fetch_assoc($query);
?> 

[rsmith]

Yes I already have the connection, it's in an include file I didn't not post (unnecessary). Thanks all! Figures I'd put the closing ) in the wrong place.