[RESOLVED] This is probably simple but....

[MitchEvans]

I cant get this piece of code working, it will not echo anything, i've tried with speech marks etc. can anyone see anything?!?!?!?! PLEEEEEASE

$connection = mysql_connect($dbhost, $dbusername, $dbpass) or die (mysql_error());
$SelectedDB = mysql_select_db($dbname,$connection);

            $productsql = "SELECT * FROM require WHERE id = 1";
$productResults = mysql_query ($productsql);
$productRow = mysql_fetch_array ($productResults);
$ProductName = $productRow["id"];

echo $ProductName;

[Kudose]

Try using [man]die[/man] and [man]mysql_error[/man]

[bpat1434]

If it echos nothing, typically that means that nothing was returned, or your query failed.

Change the mysql_query() line to this:

$productResults = mysql_query($productsql) or die(mysql_error());

[MitchEvans]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'require WHERE id = 1' at line 1

[bpat1434]

Oh, try encasing the table name require in back-ticks: ` (it's the tilde key, next to the number 1). I think require is a reserved word. It is a reserved word.

If you want to know what the reserved words are, search for them over at www.mysql.com 🙂