[RESOLVED] How can i get data out of this array?

Sayian

Hello , im using mysql_fetch_assoc , which ive never used before , im used to using mysql_fetch_array

Im trying to get data out of the following

$result = mysql_query("SELECT `note_id`, `to`, `from`, `time` FROM `shocc_notes` WHERE `to` = '" . $_SESSION['username'] . "'") or die(mysql_error());
 if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {$notes[] = $row;}

Id like to be able to assign the note_id 's to a variable

i have tried $notes['note_id'];
also $notes[0] returns no data

When i do a print_r , i see the data in the array , any clue how to pull it outta their and assign it to variables ..

toplay

The manual has an example:
http://us3.php.net/manual/en/function.mysql-fetch-assoc.php#AEN97915

Basically use the column name of what you're selecting from your query as the index value for the $row variable:

$notes[] = $row['note_id'];

or if you don't want to store it in an array:

$notes = $row['note_id'];

FYI: You can use the same method with mysql_fetch_array() because that function creates both a numeric index and an associative index value for each column fetched.

hth.

Sayian

Ok , i have tried to write some code with this

$result = mysql_query("SELECT `note_id`, `to`, `from`, `time`, `read` FROM `shocc_notes` WHERE `to` = '$sess_user' AND `inbox` = 'inbox' ORDER BY `time` DESC") or die(mysql_error());
 if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {$notes[] = $row;}
    $note_id2 = $row['note_id']; 
    echo $note_id2;

Note id still will not echo the the screen , it does exist , what am i doing wrong?

Sayian

Figured it out

the brackets , were not surrounding the variable i was trying to populate within the while loop.

Still learning , but getting better =)

Thanks for your help