hey all, got another slight problem, i get the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xingeh/public_html/viewmessages.php on line 10

when i click on any of my messages on my inbox.
the code i have for the page is:

<?
// Get the ID for the message!
$messid = $_GET["messid"];

// Connect to the database, pull the required information out!
lalal
lalla

$result=mysql_query("SELECT * FROM messenger WHERE messid=".$messid."");
while($row=mysql_fetch_array($result)) {

$messid= $row['messid'];
$userid = $row['userid'];
$authorid = $row['authorid'];
$message = $row['message'];
$authorname = $row['authorname'];
$messtitle = $row['messtitle'];

// Show the message

echo("Message $messid");
echo("<br><br>");
echo("Message from: $authorname");
echo("<br>");
echo("Message title: $messtitle");
echo("<br>");
echo("The message:");
echo("<br><br>");
echo("$message");

} 
mysql_close();
?>

Hi,

1) Put your query in a string
2) Display it
3) Display mysql_error()

You will probably find out the cause.

try changeing the row to this:

PHP Code:

$result=mysql_query("SELECT * FROM messenger WHERE messid='".$messid."'"); 


might help ... not sure though.

also ... before trying to fetch data try and check is there's anything to fetch.

We solved this one on im - the get variable was named wrong, the URLs had msg=x and not messid=x

lol, yeah me an oberon (he rocks!) sorted out the problem! thanks for the help tho guys!