PHP MySQL no output

BigBadDad

I am using the code below to display each row of a query result in a new table. I don't get any output at all. Is there a mistake in my code or am I well out??? This is all new to me so any help will be great. Thanks

BigBadDad

Here is the code that does not work....
<?php
defined('JEXEC') OR defined('VALID_MOS') OR die( "Direct Access Is Not Allowed" );
?>
This is the eateries of Callander..
<?php
$db =& JFactory::getDBO();
$query = "SELECT * FROM jos_a_eateries WHERE (Town = 'Callander') ;";
$db->setQuery($query);
$num= mysql_num_rows($db);
while ($i < $num)
{
echo "
<table>
<tr><td>$Name[$i]</td></tr>
</table> ";
$i++;
}
?>

johanmichel

Hi BigBadDad,

First of all setting $i = 0 above the while might be a good thing.

First of all make sure you are connected to the mysql server and check if you are accessing the right name.

Next echo the query and make sure the WHERE statement is set right.

Next check $num to see if it is outputting the right number.

Also I find the $Name a bit weird, are you sure this var has been set?

Please check and give me some feedback about the above.

BigBadDad

Below is new code I have found from around sites that still does not work.
The code is being used in a Joomla 1.6 site but the code should still work and be the same.

<?php
defined('JEXEC') OR defined('VALID_MOS') OR die( "Direct Access Is Not Allowed" );
?>
This is the eateries of Callander..
<?php
$db =& JFactory::getDBO();
$query = "SELECT * FROM jos_a_eateries WHERE (Town = 'Callander') ;";
$db->setQuery($query);
$num=mysql_num_rows($row);
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Name</th>
<th>Address</th>
<th>Postcode</th>
<th>Email</th>
<th>Website</th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"Name");
$f2=mysql_result($result,$i,"Address");
$f3=mysql_result($result,$i,"PostCode");
$f4=mysql_result($result,$i,"Email");
$f5=mysql_result($result,$i,"Website");
?>

<?php
$i++;
}
?>

Cheers in advance for any info that will help.