plz help me..mysql_fetch_array() problem

[prashish_raj]

i have been getting this problem n this is getting into my nerves..
it works fine on the web.. but i need to present it on the intranet tomorrow "sunday"
it gives this damn error. of mysql_fetch_array..
can u plz help me

CODE:

<div id="right_nav">


<div id="cga_events">
<div id="navtop" align="center">
<div id="navtop_left">
</div><div id="navtop_right">
</div>
<div id="navtop_text">CGA Events</div>
</div>
<div id="pageNav">
<div id="sectionLinks">';


include("connect1.php");
$table = events;
$query  = "SELECT  id, topic, event, date
FROM events ORDER BY 'id' DESC  LIMIT 5";


$result=mysql_query($query);
//LINE 140 while (list($id, $topic, $event, $date) =mysql_fetch_array($result))
{
echo"  <font color=\"#006600\">&nbsp;On ".substr($date,0,10)."</font>
<a href=\"$self?page=showevents&id=$id &topic=$topic \" class=\"elibtopic\">$topic</a>
";
}


echo'</div>
</div>';






warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\phpdev5\www\intranet cga\sept 25th 2007\myclub\index.php on line 140

[nav33n]

$query = "SELECT id, topic, event, date
FROM events ORDER BY 'id' DESC LIMIT 5";

Should be

$query = "SELECT id, topic, event, date
FROM events ORDER BY id DESC LIMIT 5";

Cheers,
Naveen

[prashish_raj]

it still shows the ame error..
?????

[prashish_raj]

im really getting annoyed by this bug...
can anyone help

[prashish_raj]

when i placed the mysql_error() then it showed

Parse error: parse error, unexpected T_WHILE, expecting ',' or ';' in c:\phpdev5\www\intranet cga\sept 25th 2007\myclub\index.php on line 140

[Sulley's Boo]

include("connect1.php");
$table = events;
$query = "SELECT id, topic, event, dateFROM events ORDER BY id DESC LIMIT 5";

$result=mysql_query($query);
//LINE 140 while (list($id, $topic, $event, $date) =mysql_fetch_array($result))
{
echo" <font color=\"#006600\">&nbsp;On ".substr($date,0,10)."</font>
<a href=\"$self?page=showevents&id=$id &topic=$topic \" class=\"elibtopic\">$topic</a>
";
}

Why do you need the stuff in red?

[nav33n]

when i placed the mysql_error() then it showed

No. mysql_error() shows mysql related error. Can you post your full code ? May be you have a misplaced } .
And instead of

while (list($id, $topic, $event, $date) =mysql_fetch_array($result))

try this

while($row=mysql_fetch_array($result)){ $id=$row['id']; 
$topic=$row['topic'];
$event=$row['event'];
$date=$row['date'];
...

I am not sure if this ll work. If it doesn't, then please post your code.

[nav33n]

Why do you need the stuff in red?

In php, if we want to echo something, its done like this. echo "Welcome...";