Help With An Idea.

wxdqz

New Member
I am having some problems with this because I am new to php. I think the direction is clear enough that you guys may be able to help. Lets assume I have 3 fields in test.usersThose fields are: id, name, pass.Here is the code:<--- Begin Code---->$connection = mysql_connect( $dbhost, $dbuser, $dbpass);$db = mysql_select_db(test);$fields = mysql_list_fields("test", "users", $connection)$columns = mysql_num_fields($fields);$sql = "SELECT * FROM users where id = 1";$Result = mysql_query( $sql ) or die( mysql_error() );while ($row = mysql_fetch_array ($Result)) { for ($i = 0; $i < $columns; $i++) { $field_name = @mysql_field_name ($fields, $i); $field_value = $row["$field_name1"];$field_name = $field_value; }}echo $user;<-----End Code----->What I want is to grab the field name and set it as a variable and then set the field value of the current row to the field name variable (Did that make sense?). EX: Grab the field name user. Set it to a var of $user. Grab the value of user out of the db and set $user = value. So if I want to echo $user later on the page it prints the username of the id I grabbed. If I need to clarify I will do my best. The code I have does not work and I wanted to know what I can do to make it work.Thanks,--ick
 
Back
Top