Fetch multiple row output from MySQL

Question

I want to fetch multiple rows output I know it can be done easily with while loop but my problem is that if I will use while loop the title of corresponding row will come. I just don't want to change the title but want to change the content. Here is simple data what I want

    tableA

    id                title                            msg

    1                 eeee                              frrffrfrrfrr
    2                 vvfdfd                           ffvfvdfvddd
    3                 vffdcadvg                         fdfvddfgvre
    4                 dfdf                              fvvvf

So if I will use while loop then title of that row will also come so I just want to keep changing the row['message'] value. My simple MySQL query is

   $res = mysql_query("select * from tableA");
   $row = mysql_fetch_array($res);
    $msg=$row['msg']

As you can see it will easily display title and message for corresponding row but I want title of one row and message output of 4 rows how it can be done?

So you want msg and title for the first row and only msg for subsequent rows? Not sure if I fully understand. — Ja͢ck, Feb 25 '13 at 20:06

score 2 · Answer 1 · edited May 25 '19 at 14:28

2

Use a loop:

$res = mysql_query("select * from tableA");
while ($row = mysql_fetch_array($res)) {
    echo $row['msg'];
}

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.

edited May 25 '19 at 14:28

Zoe

27,060
21
118
148

answered Feb 24 '13 at 18:29

John Conde

217,595
99
455
496

Why you're using `mysql_fetch_array` instead of `mysql_fetch_assoc`? – Winston Feb 24 '13 at 18:34

Fetch multiple row output from MySQL

1 Answers1

Linked