Getting Data from MySQLl Dynamicly

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dark_purple
Forum Newbie
Posts: 1
Joined: Fri Jul 25, 2008 9:45 pm

Getting Data from MySQLl Dynamicly

Post 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
coder500
Forum Newbie
Posts: 20
Joined: Fri Jul 25, 2008 10:24 am
Location: Singapore

Re: Getting Data from MySQLl Dynamicly

Post by coder500 »

Deleted up on request
Post Reply