killmaster — Fri, 26 Apr 2002 02:36:46 +0000

so basically it is probably a statement in there in which I have forgotton to add a table tag eg: , or

but if it is not did you find anything wrong in the code?

thanks

mairving — Fri, 26 Apr 2002 02:30:18 +0000

Usually what I do if it doesn't seem to be posting any results is to first echo the query to the screen:

<?php
$query = \"SELECT * FROM news ORDER BY id DESC LIMIT 10\";
echo $query;
$result = mysql_query($query);
?>

This will first tell you if any values at all are there to be passed to the DB. If the echo statement shows the proper values that should be inserted into the db, try it without the 'if' conditional. If it inserts the values without the 'if', then you need to review your logic. If both of these fail to produce any results, you may do a view source of your web page. I have found that sometimes I forget to stick a or around the while statement, causing the results not to show on the screen,