MYSQL查询将结果数组保存为变量

Question

im after the simplest (and easiest to understand from a novice programmers perspective) to do the following;

I have a query on a database:

$newsquery = mysql_query('SELECT * FROM news ORDER BY id DESC LIMIT 3');

I want to to select the top three rows in my table and get the column 'news'

Then I need to save each result as a separate variable, this could be $news1, $news2 and $news3

So i could then use these variables to echo as needed on my page.

I hope this makes sense, many thanks .

Answer 1

stop using mysql as PHP is removing it at the end of the year,use PDO or mysqli

$rows = array();
while($row = mysql_fetch_assoc($newsquery)) {
$rows[] = $row['news'];
}
$news1 = $rows[0];
$news2 = $rows[1];
$news3 = $rows[2;

with PDO

$rows = $results->fetchAll(PDO::FETCH_ASSOC);

$news1 = $rows[0]['news'];
$news2 = $rows[1]['news'];
$news3 = $rows[2]['news'];