newbie: help pls :P

Anon

I've just been looking at this snippet, and wondering why it's not working..
Either i'm doing something wrong, or i'm just totally ignorant.. (More
likely the latter). But if anyone can help me out, please let me know..

$db = mysql_connect("localhost", "root");
if (!$db) {
echo "Cannot connect to MySQL";
exit;
}
$selectdb = mysql_select_db("test");
if (!$selectdb) {
echo "Cannot select database";
exit;
}
$query = "SELECT * from counter";
$result = mysql_query($query);
$numone = mysql_numrows($result);
$i = 0;
while ($i <= $numone) {
$seekrow = mysql_data_seek($result, $i);
$fetchrow = mysql_fetch_row($result);
$time = $fetchrow["time"];
echo "$i = $time<br>";
$i++;
}

It seems to only return one or two of the fields at a time, when there is about 20.

All help is appriciated.

mega_hurtz

Just a tip: be sure to test everything to make sure none of you commands fail.

i.e. connection, db selection, query, row count, seek, fetch.

After inserting your boolean tests for the remainder of your mysql commands and you find that they all work, your next step is to look at return values. Print your 'mysql_num_rows' result to see exactly how many rows are being returned. If you get your 20 rows that you are looking for, then you'll know your problem is in your loop.

You're using mysql_fetch_row instead of mysql_fetch_array. The array fetch will return values in an associative array, while the row fetch returns values in numbered indices. Try it out and let me know if this helps.