[RESOLVED] whats wrong here?

[homer09001]

ive tried the query in Phpmyadmin and it works fine yet the php file can't process it?

<?php
include "../config.php3";
include "../dbconnect.php3";

function gettoname($pmto){
$toname = "SELECT username FROM $table3 WHERE id='$pmto'";
$to1 = mysql_query($toname) or die(mysql_error());
$pm_to = mysql_result($to1, 0); 

return $pm_to;
}

function getfromname($pmfm){

$fromname = "SELECT username FROM $table3 WHERE id='$pmfm'";
$from1 = mysql_query($from) or die(mysql_error());
$pmfrom = mysql_result($from1, 0); 

return $pmfrom;
}

?>

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 'WHERE id='000'' at line 1

[homer09001]

solved the problem:

<?php
include "../config.php3";
include "../dbconnect.php3";
include "bbcode.php";
include "test.php";
include "namefunction.php";
echo "<table border=1><tr><td>PM Id</td><td>Sent To</td><td>Sent By</td><td>PM Subject</td><td>PM Message</td><td>Has It Been Read?</td><td>PM Sent On</td></tr>";

$a = "SELECT * FROM $table4";
$rows = mysql_query($a) or die (mysql_error());

while ($b = mysql_fetch_array($rows)or die(mysql_error())){
$pmid = $b['id'];
$pmto = $b['pmto'];
$pmfm = $b['from'];
$pmsj = $b['subject'];
$str = $b['content'];
$pmrd = $b['red'];
$pmsa = $b['sentat'];
$pmmg = nl2br(bbcode_format($str));

$to = gettoname($pmto);
$from = getfromname($pmfm);

echo "<tr><td>$pmid</td><td>$to</td><td>$from</td><td>$pmsj</td><td>$pmmg</td><td>$pmrd</td><td>$pmsa</td></tr>";
}
echo "</table>";
?>