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" <lists@xxxxxxxxx> escribió en el mensaje
news:472D0EDA.4030709@xxxxxxxxxxxx
> 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
