Results 1 to 2 of 2

Thread: Fetching data from mysql

  1. #1
    Join Date
    Oct 2008
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Fetching data from mysql

    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

    PHP Code:
    $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 />';
        }


  2. #2
    Join Date
    Oct 2008
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    solved

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •