get column name and values in array at same time from mysql in php

Question

I am looking out for some kind of short code where i should not be repeating the column names in database and it should directly be inserted with respective column name index to array value . Below i have uploaded the image for understanding.

enter image description here

Michael · Accepted Answer · 2012-04-04 09:38:09Z

2

Use mysql_fetch_assoc() rather than mysql_fetch_row() and the array will be associative (using the column names as the key) rather than numeric.

$query = mysql_query("SELECT * FROM users_table WHERE User_ID = 1");

while ($r1 = mysql_fetch_assoc($query))
{
  echo $r1['User_ID'] . ': ' . $r1['First_Name'] . ' ' . $r1['Last_Name'] . '<br />';
}

answered Apr 4, 2012 at 9:38

Michael

12.9k6 gold badges57 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hjpotter92 · Accepted Answer · 2012-04-04 09:30:15Z

1

Check this:

$query = mysql_query( "SELECT * FROM users_table WHERE user_id=1;" );
$row = mysql_fetch_array( $query );
print_r( $row );

more about mysql_fetch_array on php.net

answered Apr 4, 2012 at 9:30

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Collectives™ on Stack Overflow

get column name and values in array at same time from mysql in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related