select/fetch will not return values

[Anon]

Hi,

the following function successfully displays the table heading and field names, but no records are displayed, i.e. the fetch does not appear to work. Any ideas as to where I am going wrong?

<?php
function sql_query($query)
{
if (!isset($query) || empty($query))
{
$query = "select * from users";
}
//remove potentially problematic backslashes
$query=stripslashes($query);
$result = db_query($query) or die( mysql_error() );
$number_cols = mysql_num_fields($result);
echo "<b>query: $query</b>";
//layout table header
echo "<table border = 1>\n";
echo "<tr align=center>\n";
for ($i=0; $i<$number_cols; $i++)
{
echo "<th>" . mysql_field_name($result, $i). "</th>\n";
}
echo "</tr>\n";//end table header
//layout table body
while ($row = mysql_fetch_array($result))
{
echo "<tr align=left>\n";
for ($i=0; $i<number_cols; $i++)
{
echo "<td>";
if (!isset($row[$i])) //test for null value
{
echo "NULL";
}
else
{
echo $row[$i];
}
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>";
}
?>

[Anon]

This sounds alot more like a database problem..Your code looks good to me. Have you tried running the $query it output by hand? does it return a result? If it doesn't, you will want to add a statement like

if($arrayObject = mysql_fetch_array($result))

to alert your program for handling code for empty sets.

If it does, I don't know. the ONLY part of your code that's different from the way I do it is

echo $row[$i];

I usually use a foreach loop and do:
foreach($row as $key => $value)
echo $row[$key];

but that shouldn't chantge anything