Array from database Entries

Im relatively new to this, so I thank you in advance for your patience.

All I need is to create an array with the results from a database column...

Lanny

immortal,

let us say ,you are issueing the following mysql query .

$result = mysql_query ("SELECT * FROM tablename WHERE name='$name'");

the row value from the above result can get it using mysql_fetch_array() function.

$row = mysql_fetch_array($result)


Now all the column values are in this $row variable.

these column values you can split using following lines of code.

do {
print $row["name"];
} while($row = mysql_fetch_array($result));




------------------

SR -
shiju.dreamcenter.net

Web developer from GOD's own country!!!!

I got that far, but the problem is, that I want to randomly pick one of the values. If i recall, i think the mysql_fetch_array gives a scalar array ?!?

thanks,

Lanny

The random selection should be done in the SQL query, not after the array has been created.

Here's an example:

$query = "SELECT id,company,state,telephone,web_address,id*0+RAND() as rand_row FROM lenders WHERE states LIKE "%$contact_state%" ORDER BY rand_row LIMIT 3"; // Select 3 random lenders who serve contact's state.

id*0+RAND uses the id of the record as the seed to generate random values, and LIMIT lets you choose as many or as few random rows as you want, then you can fetch the array as shown above.

Got it to work!

<?php

$db = mysql_connect("localhost","user","password");
mysql_select_db("dbase",$db);
$buzzword = "";

for ($i=0; $i<4; $i++) {

$word = mysql_query("SELECT word,word_number*0+RAND() as rand_row FROM buzzwords WHERE word_number=$i ORDER BY rand_row LIMIT 1", $db);

($myrow = mysql_fetch_array($word));

$buzzword .= $myrow[word];
$buzzword .= "n";

}

echo "$buzzword";

?>

Thanks to all who contributed