SQL Query

[bjblackmore]

Hi,
I have the following code, which is meant to select the column description, and print out each row. However for somereason it only prints the 1st entry. Can anyone see why? Also its very slow to load, the description column is a max length of 255 charactors, and at the moment the logest is about 100, is there anyway I can speed it up?.

$sql = "SELECT description FROM menu WHERE menu='dinner'";
$result=db_query($sql);
if (!$result) {
echo 'Sorry No Records';
} else {
while($row=mysql_fetch_array($result)) {
echo '<font face="Verdana, Arial, Helvetica, sans-serif" size="2">'.$row[0].'</font>';
echo '<font face="Verdana, Arial, Helvetica, sans-serif" size="2">'.$row[1].'</font>';
echo '<font face="Verdana, Arial, Helvetica, sans-serif" size="2">'.$row[2].'</font>';
}
}

[Anon]

I would do it like this:

$sql = "SELECT description FROM menu WHERE menu='dinner'";
$result=mysql_query($sql);

if (!$result) {
echo 'Sorry No Records';
}
else {
while($row=mysql_fetch_object($result)) {
echo $row->description;

}
}

hope this helps, Nic

[Anon]

yo man,
try this one..will surely work

$sql = "SELECT description FROM menu WHERE menu='dinner'";
$result=mysql_query($sql);
if (!$result) {
echo 'Sorry No Records';
} else {
while($row=mysql_fetch_array($result)) {
echo ''.$row[0].'';
echo ''.$row[1].'';
echo ''.$row[2].'';
}
}

if not

straight away put your select statement in $result i.e
$result=mysql_query("SELECT description FROM menu WHERE menu='dinner'");

and try
<? ashay ?>

[gio2k]

SELECT description FROM menu WHERE menu='dinner'

Are you sure that query is supposed to return more than one record? Check for the number of rows retrieved with the following statement after the else{:
if(mysql_num_rows($result) <= 0) echo "No rows returned";

Also,

echo ''.$row[0].'';
echo ''.$row[1].'';
echo ''.$row[2].'';

Here you are trwing to retrieve 3 columns from a query that only returns 1 (description).

Use $row["description"] instead.

-Gio-