[Resolved] Mysql query into array

[5rent]

It is one of those nights.... I can not get the below mysql query to read in a row of data from mysql. I am sure ID=1510 exists. When testing, it returns a blank screen or whatever I echo EXCEPT my array vars. Please help.
Thanks in advance.

<?php
$DBhost = "123.123.12345";
$DBuser = "user";
$DBpass = "pass";
$DBName = "name";
$digit = 1510;
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "SELECT * FROM webpage WHERE id = 'digit'";
$result=mysql_query($sqlquery);
$row=mysql_fetch_row($result);
mysql_close();
echo "Read: $row[35], $row[45], $row[90]";
?>

[bradgrafelman]

Debug your query:

$result=mysql_query($sqlquery); 
$row=mysql_fetch_row($result); 
mysql_close(); 
echo "Read: $row[35], $row[45], $row[90]"; 

changes to:

$result=mysql_query($sqlquery) or die('Error, MySQL said: ' . mysql_error() . '<br><br>Query was:<hr>' . $sqlquery . '<hr>'); 
if(mysql_num_rows($result) == 0) die('Error: 0 rows in result set.');
$row=mysql_fetch_row($result); 
mysql_close(); 
echo "Read: $row[35], $row[45], $row[90]"; 

EDIT: Debugging 101

[5rent]

I am most certainly a novice PHP programmer.... I pasted your code (Thanks) and got the following output:

Error: 0 rows in result set.

Its telling me my array is empty?

[bradgrafelman]

Ahhh. First of all, yes, it's telling you your query returned no results.

Upon further scrutiny, I found the error (put it in bold for you):

$sqlquery = "SELECT * FROM webpage WHERE id = 'digit'";

Missing a $ aren't we? 😉

[5rent]

THanks. I knew it was in front of my face, I just could not see it. Works like a champ. THis forum rocks.