Page 1 of 1

Getting Data from MySQLl Dynamicly

Posted: Fri Jul 25, 2008 10:06 pm
by dark_purple
Helo everybody :D
I was wondering..
i wrote this piece of code...

Code: Select all

include "connect.php"; 
    $sql="select * from users"; 
    $result=mysql_query($sql);     
          $field_count = mysql_num_fields($result); 
          $row_count = mysql_num_rows($result); 
     
    for($i=0;$i<$field_count;$i++) 
    { 
        $field_name = mysql_field_name($result, $i);  
        echo $nama_field; 
                    echo '</br>'; 
        for($j=0;$j<$row_count;$j++) 
        {         
            $record = mysql_fetch_array($result); 
            echo $record[$field_name]; 
            echo '</br>'; 
        } 
    }
I thought the output supose to be like this :
User_ID
1
2
3
Name
John
Mary
Peter
E-mail
john@yahoo.com
mary@gmail.com
peter@rocketmail.com
instead it turn out to be like this :
User_ID
1
2
3
Name



E-mail


I relly can't figured it out, honestly..what went wrong :banghead:
I will be very greatfull if anyone can tell me where did I do wrong.
Thank :D

Re: Getting Data from MySQLl Dynamicly

Posted: Sat Jul 26, 2008 3:22 am
by coder500
Deleted up on request