Hi guys After doing some changes, I believe it is partially working, what I did is the following: while($row=mysql_fetch_array($fotos)) { $fotos_mostrar[] = $row; } $primer_foto = reset($fotos_mostrar[0]); // This is to set the pointer to the first record echo $primer_foto; // This displays the first column when doing a SELECT
However, my SELECT statement retrieves 2 columns from one table, how do I display the second column ? Thanks Eduardo "Jim Lucas" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > Eduardo Vizcarra wrote: >> I have a WHILE sentence to retrieve all records from a SELECT query in a >> database and am using mysql_fetch_array to store them in a matrix, the >> sentence is like this: >> while($row=mysql_fetch_array($fotos)) >> { >> $fotos_mostrar[] = $row; >> } >> >> $fotos contains all records found in a db table, the SELECT statement is >> retrieving 2 columns from a table, how do I store all records in a 2 >> dimention table so I can use it later ? >> >> this WHILE sentence seems to only store the last record only >> >> Regards > how are you checking to see the contents of the $fotos_mostrar array() ? > > just after the while loop ends, do a var_dump() or print_r() on the array > and view the contents. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php