Too simple but i cant find it

[jonsof]

$result=mysql_query("SELECT visitid, time_visit FROM visits LIMIT 1");$show=mysql_fetch_assoc($result);

where is the problem above?

[cschotch]

what error is it giving you?

[jonsof]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\phpdev\www\announcements_system\~out.php on line 23

[geetakhurana]

Check your field names and table name

[rIkLuNd]

Try this:

<?php

$result=mysql_query("SELECT visitid, time_visit FROM visits LIMIT 0,1");
$show=mysql_fetch_assoc($result); 

?>