How To Set Sql Result Into Variables?

[mostafatalebi]

Hello

 

I have a mySQL table with six rows, How can I query all of them and put them one by one in a variable or an array?

 

thanks

[Pikachu2000]

Where are you stuck, exactly?

[mostafatalebi]

I mean I have a table, with six rows. Each row has a text in it. I want to query the table and get all six rows, putting each row's text into a variable, so at the end I have six variables or an array with six element. Something like looping through. But I don't know how

[trq]

Assuming $results holds the result of your call to mysql_query().

 

$allResults = [];
while ($row = mysql_fetch_assoc($results)) {
   $allResults[] = $row;
}

 

$allResults will now be an array containing all your rows.

[mostafatalebi]

Ha! Thanks alot