What is a PHP function to return multiple rows from a mysql query?

Question

I'm relatively new to php, and to this point I've been fine using the mysql_fetch_array function to echo values selected from the database. But now I want to be able to echo the results selected from multiple rows with the same username.

I was just wondering what the most efficient way of doing this was. I could manage to do it using a for loop and counting through each individual query, but I know there must be a more efficient way just using sql, or using a better oho function.

Thank you for the help.

Alex

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — ThiefMaster
– ThiefMaster, Commented Dec 25, 2012 at 18:28

Moseleyi · Accepted Answer · 2012-12-25 18:12:46Z

1

while($row = mysql_fetch_array($result)) { 
    // process each row
}

I guess that's all you neeed - have a play and you should get your desired effect! It's best to do it in PHP..

Also you shouldn't use mysql_fetch_array anymore as it's deprecated. Use PDO or mysqli insted. More information you can find here

answered Dec 25, 2012 at 18:12

Moseleyi

2,9754 gold badges34 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Talha Akbar · Accepted Answer · 2012-12-25 18:17:01Z

0

while($row = mysql_fetch_assoc($result)) { 
} or
while($row = mysql_fetch_array($result)) { 
}

and mysql_ functions are depreciated now onwards in mysql

answered Dec 25, 2012 at 18:17

Talha Akbar

10.1k7 gold badges41 silver badges62 bronze badges

Comments

Mr. Radical · Accepted Answer · 2012-12-25 18:21:49Z

0

SQL is used to query the database your using. PHP is used to format the output from the query. See the manual from PHP.net for more info php.net/manual/en/function.mysql-fetch-array.php . There is no way as far as I know to format the output in rows using SQL.

B.T.W. if this is new code I would advice you to use mysqli instead of mysql.

edited Dec 25, 2012 at 18:21

answered Dec 25, 2012 at 18:15

Mr. Radical

1,8381 gold badge20 silver badges30 bronze badges

Collectives™ on Stack Overflow

What is a PHP function to return multiple rows from a mysql query?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related