mysql error

[joey3002]

$originalposter = 'onlyme';
echo "This Report is on [$originalposter]<BR><BR>";
$sqlResource = mysql_query('SELECT `n_id`, `time`, `admin`,`changes`,`to`,`from` FROM `admin_logging` WHERE orig_poster = $originalposter ORDER BY `time` DESC LIMIT 0, 500');

while($sqlRow = mysql_fetch_row($sqlResource)){

The error I get:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/admin/editlog2.php on line 18

Any help will be very much appreciated.
Thanks

[thekidscareya]

try this

$originalposter = 'onlyme'; 
echo "This Report is on $originalposter. <BR><BR>"; 
$sql = "SELECT `n_id`, `time`, `admin`,`changes`,`to`,`from` FROM `admin_logging` WHERE orig_poster = '".$originalposter."' ORDER BY `time` DESC LIMIT 0, 500";

$sqlResource = mysql_query($sql); 

# Here---did you want an array? or what?
# Im assuming you wanted an array

while($sqlRow = mysql_fetch_array($sqlResource)){
# Do some stuff here
}

[joey3002]

thank you tremendously.. that fixed it for me.

[thekidscareya]

no prob...make sure u mark this thread resolved