php mysql data only shows one row with foreach loop

Question

ok i have this and it doesn't show all the rows when fetched from mysql database its like this:

  mysql_select_db($database_config, $config);
    $query_cat = "SELECT * FROM cat";
    $cat = mysql_query($query_cat, $config) or die(mysql_error());
    $row_cat = mysql_fetch_array($cat);

    $arr = array("TIT" => $row_cat['title'],
            "DES" => $row_cat['description']);


    foreach($arr as $ar){
    echo $ar;
    }

now it only displays the first row and then stops why is it not displaying all the fields and i don't wanna use while loop for it can anyone explain me the problem??

EDIT: Well basically i want to work it like this

$p = "{TIT}{DES}";
foreach($arr as $k => $p){
$p = str_replace("{".$k."}", $v, $p);
echo $p;
}

Now the problem is not with str_replace its with the loop or database because the database rows are not incrementing and displays only one data.

mysql_fetch_array only fetches one row (php.net/mysql_fetch_array) — mellamokb
– mellamokb, Commented May 2, 2011 at 16:30

Shakti Singh · Accepted Answer · 2011-05-02 16:29:41Z

4

This will always return the first row. you are fetching only once that will return only first row.

Instead you must fetch all the rows using fetch statement in loop

 while($row_cat = mysql_fetch_array($cat)){
       echo $row_cat['title'];
       echo $row_cat['description'];
    }

answered May 2, 2011 at 16:29

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

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

Comments

elitalon · Accepted Answer · 2011-05-02 16:34:35Z

0

From PHP mysq_fetch_array documentation:

"Returns an array that corresponds to the fetched row and moves the internal data pointer ahead"

As far as I know, you cannot retrieve every row without using a loop. You should do something similar to this:

while($row_cat = mysql_fetch_array($cat)){
  echo $row_cat['title'];
  echo $row_cat['description'];
}

answered May 2, 2011 at 16:34

elitalon

9,46710 gold badges53 silver badges86 bronze badges

Collectives™ on Stack Overflow

php mysql data only shows one row with foreach loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related