MySQL DB query returns nothing

Question

Hi everyone I'm currently writing a MySQL query that doesn't return anything to the user. What am I doing wrong?

<?php
require_once('MDB2.php');
include "mysql-connect.php"; 

// connect to database

$dsn = "mysql://$username:$password@$host/$dbName"; 
$db =& MDB2::connect($dsn); 
if (PEAR::isError($db)) { 
    die($db->getMessage());
}
$table_name="room";
$db->setFetchMode(MDB2_FETCHMODE_ASSOC);

// list the rooms details

$sql = "SELECT * FROM $table_name";
$res =& $db->query($sql);
if (PEAR::isError($res)) {
    die($res->getMessage());
}

// display results but if no result has been found then we have to let the user know

if($res->numRows() > 0)
{
    echo "<table border=1>
    <tr align='left'>
    <th scope='col'>Name</th>
    <th scope='col'>Weekend Price</th>
    <th scope='col'>Weekday Price</th>
    </tr>";
    while($row = $res->fetchRow());
    {
        echo '<tr align="left">';
        echo "<td>" . $row['name'] . "</td>";
        echo "<td>&pound" . $row['weekend_price'] . "</td>";
        echo "<td>&pound" . $row['weekday_price'] . "</td>";
        echo "</tr>";
    }
echo "</table>";
}
else
{
    echo "Nothing found.";
}
?>

No error reports... but nothing is being returned from the SQL query i.e. the table is empty. I have used the correct field names as well. — methuselah
– methuselah, Commented Mar 14, 2012 at 1:22
Besides the fact it is VERY old, not maintained and who knows what extension version you use, which might be full of bugs...nothing wrong. — Itay Moav -Malimovka
– Itay Moav -Malimovka, Commented Mar 14, 2012 at 1:27

TheOx · Accepted Answer · 2012-03-14 03:04:32Z

3

Remove the semi-colon from the end of this line:

while($row = $res->fetchRow());

It's not entering the contents of the while loop due to that semi-colon.

answered Mar 14, 2012 at 3:04

TheOx

2,22825 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL DB query returns nothing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related