mysql_fetch_row is not fetching

kathyraby

I'm using a simple script that simply gets rows and increments to the next. I have the index starting at 0. I get the folling warning: Warning: 0 is not a MySQL result index... Does any one have any suggestions. This is the code I am using:

<?
$dbh = mysql_connect('localhost:3306','username','password');
$res = mysql_db_query('database_name',"select * from test");
$err = mysql_error();
if($err){ echo "Error connecting to database"; }
$i=0;
while ($line = mysql_fetch_row($i)){
echo "$line<BR>\n";
$i++;
}
?>

I'm connecting ok. I can't get past '$=0;'

The suggestions are very much appreciated.
Kathy

Anon

Take a careful look at the mysql_fetch_row($i) call!! Use $res instead of $i.

Anon

Kathy try this code instead
<?
$dbh = mysql_connect('localhost:3306','username','password');
$res = mysql_db_query('database_name',"select * from test");
$err = mysql_error();
if($err){ echo "Error connecting to database"; }
$i=0;
while ($line = mysql_fetch_row($res)){
$len = count($line);
for($i = 0; $i < $len; ++$i) {
echo "$line[$i]<BR>\n";
}
}

if you are selcting all the fields then the result resource i.e $line would be an array

Anon

If you have more than one fields in your table test then you can use
while(list($element1,$element2...)=mysql_fetch_row($res))
{
$i++;
...
..
}

or
while($rows=mysql_fetch_array($res))
{
$i++;
$field1=$rows["field1"];
// here field1 is your first field of your test table
}

So replace your fetch statement inside the loop and try with any of the above.

Hope this will solve your problem.

srini