Jump to content

Fetch all data from mysql


vividona

Recommended Posts

Hi,

 

I am trying to fetch all data from database.

but any data show  twice.

 

like this:

 

Ali

Ali

30

30

Osman

Osman

20

20

Omer

Omer

40

40

Salim

Salim

10

10

Suzan

Suzan

25

25

 

$mem_qry = "SELECT * FROM tbl_name";
$res = mysql_query($mem_qry);

function mysql_fetch_all($res) {
   $return = array();
   while($row=mysql_fetch_array($res)) {
       $return[] = $row;
   }
   return $return;
}

$all = mysql_fetch_all($res);
foreach($all as $k=>$v) {
foreach($v as $k2=>$v2){
	echo $v2.'<br />';
}
}

Link to comment
https://forums.phpfreaks.com/topic/222054-fetch-all-data-from-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.