Mysql Results in an array

[egmweb]

Hello Guys.

I'm trying to make an script to makes the results of an mysql query into an array, for example:

$mysql = mysql_query("SELECT gallery.name FROM gallery");
while ($row = mysql_fetch_row($mysql)){
$g = $row[0];
echo $g.' ';
}
The results will be: gal1 gal2
We need this values be stored in differents variables, like this:
$1 = gal1;
$2 = gal2; etc.

Would you please help me with this script?

Thanks you.

 

[sleipnir214]

Change:

$mysql = mysql_query("SELECT gallery.name FROM gallery");
while ($row = mysql_fetch_row($mysql)){
    $g = $row[0];
        echo $g.' '; 
}

to

$g = array();
$mysql = mysql_query("SELECT gallery.name FROM gallery");
while ($row = mysql_fetch_row($mysql)){
    $g[] = $row[0];
}
print_r ($g);

At the end of the loop, the elements of the array $g will contain the values from the database.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[egmweb]

Thanks you Very much sleipnir214, it works

Regards.

 

[dagger2002]

How can you sort those values by 2 different things. Say in g I had date and title i wanted to sort by how can i do that

 

[sleipnir214]

That is a new question, which should be asked in a new thread.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[dagger2002]

sorry thought it was along the same lines