arrays

[Anon]

Hello everyone,
Thanks for your time.

Can anyone put me in the right direction here? I'm trying to take values from a database table and put them into an array.

The field i am taking the values from is called "levelName". levelName is unique in this table.

I think I would need a select statement to select all the records right? But my problem is putting them into levelNameArray.

Any help would be greatly appreciated!
Thanks again!

[cordex]

MySQL?
$select_st = "SELECT * FROM tablename WHERE field=fieldvalue"; // insert your select statement here - this is just an example
$select_rs = mysql_query($select_st);
$levelNameArray = mysql_fetch_array($select_rs);

there you go

[Anon]

For a MySQL db you would want to use the mysql_fetch_array():
$Query = "SELECT levelName FROM dbname":
$dbresult = mysql_query($Query, $dblink);
$levelNameArray = mysql_fetch_array($dbresult);

You could now access the array elements with $levelNameArray[int];

Hope this helps!

[Anon]

Sorry, that select statement should read:
SELECT levelName FROM tablename.