Log in

View Full Version : Fetching data from mysql



vividona
12-18-2010, 09:13 AM
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 />';
}
}

vividona
12-18-2010, 09:50 AM
solved