[RESOLVED] select query returns just one record?

[Zpixel]

i have a simple table and i want to make a simple query. below is the table
(all records are TEXT):

  id userid age sex 

  1 [email][e-mail][/email] 25 male 
  2 [email][e-mail][/email] 37 male 
  3 [email][e-mail][/email] 36 female 
  4 [email][e-mail][/email] 2 male 

and this is my query :

            $result=mysql_query("SELECT * FROM test");
$row = mysql_fetch_assoc ($result);

to show the result, i use :

    foreach ($row as $value)
    echo $value . '<br />'; 

and this is the answer :

1
[e-mail]
25
male

as you can see, there is only the the first record returnd.
i use easyphp 1.8(or 2.1) on my winXP.
any help, many thanks.

[laserlight]

It would be something along the lines of:

$result = mysql_query("SELECT * FROM test");
while ($row = mysql_fetch_assoc ($result)) {
    foreach ($row as $value) {
        echo $value . '<br />';
    }
}

[Zpixel]

thanks a lot laserlight .
you solved my headache problem.

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.

[Zpixel]

and, can we delete multiple rows in a table using:

mysql_query("DELETE * FROM test WHERE userid IS NULL");

or update multiple rows:

mysql_query("UPDATE test SET id='$id' WHERE userid IS NOT NULL");

[laserlight]

Yes, but why have a NULL userid or id in the first place? If you use id as the primary key, it should be an integer column declared not null (and declared with auto increment).

[Zpixel]

just as an example.

thank you.