Simple array question.

[kpdvx]

$query = "SELECT definition as answer FROM verbum limit 4";
$result = mysql_query($query);

How do I echo the 4 listings?

Thanks!

 

[sleipnir214]

You get them out one row at at time using mysql_fetch_array() (

http://www.php.net/manual/en/function.mysql-fetch-array.php),

mysql_fetch_assoc() (

http://www.php.net/manual/en/function.mysql-fetch-assoc.php),

mysql_fetch_row()(

http://www.php.net/manual/en/function.mysql-fetch-row.php),

or mysql_fetch_object() (

http://www.php.net/manual/en/function.mysql-fetch-object.php).

The pages for mysql_fetch_assoc(), mysql_fetch_object(), and mysql_fetch_array() all have sample scripts for you to look at. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[DaRNCaT]

use a foreach function
like
foreach ($result as $var)
{
print &quot;$var<br>&quot;;
}

Sometimes, when my code just won't behave, I take it outside and make it listen to britney spears music, and when it comes back it's really well behaved. I wonder if it's suffering from post tramatic stress syndrome now..