php mysql fetch array 4th plate of toast

Anon

alrighty. please please i know the wise ones can help me out.
its early in the morn / late at night and i'm on my fourth plate of toast. yes i really like toast.

my situation.

I have information that i need to get from the last 5 entries of a certain column in my mysql table. Its ordered by number.

i got that bit.

$query = "SELECT firstcolum FROM tablenamewonderful ORDER BY firstcolumn DESC LIMIT 0, 5";

now what i need to do with these 5 bits of info from the column is seperate them. Each bit of information looks essentially like this
23A. So in my head i imagine the array to look something like this : 23A, 19B, 18C, 15A, 10D . (Please excuse and laugh as you must - i am very new to this mysql - php, only experience with arrays is in actionscripting)

so i thought i can do it with a snazzy mysql_fetch_array.

$result = @($query);

while ($row = mysql_fetch_array($result)) {

the thing i'm lost in, and i've tried my best to read the tutorials and articles and forums , is how to i get my bits of information to end up essentially like this (making variables that end up like this)

Part1 = 23A
Part2 = 19B
Part3 = 18C
Part4 = 15A
Part5 = 10D

I'd like to do this setting up in the php/mysql side moreso because its jsut easier to hand the information to Flash all ready and set to go. But i would even be happy if someone could show me show to get it to this stage

Part = 23A
Part = 19B
Part = 18C
Part = 15A
Part = 10D

anyhelp or clue or bit of code would be greatly appreciated.

you're tremendous.

Anon

I am not totally sure I understand your question, but I will give it a shot.

What you want to do is run the query like you are doing and then go into the while loop. For you while loop you probably want to use the mysql_fetch_row() function. This will return the rows one by one. Once in the while loop you will have an array called $row. That row has each column you select stored in it. So to get the first peice of info you address $row[0]. You can then use the information however you see fit. Since you know how many items you have you might want to use a for loop and assign all of these variables into a single array, but if you don't care to do that you can just use the while.

while ($row = mysql_fetch_row($result)) {
$part1 = $row[0];
print("$part1");
}

or try this...

for($i = 0; $i < 5; $i++) {
$row = mysql_fetch_row($result);
$part[$i] = $row[0];
}

Hope this helps.
Daniel Ice
http://www.coderguy.com