How to convert variables from MYSQL result into PHP variables with same name?

Question

I am running this mysql query:

$result = mysql_query("SELECT * FROM  userdetails WHERE  userid= '$userid'");
$row = mysql_fetch_array($result);

The result is a row of 100 variables with different names such as $row['name'], and $row['email'], etc...

How can I convert all of these to just $name and $email, etc... in php?

It would save so much time to write this program....

I don't understand why you would want to pass around 100 variables instead of one array. — Daren Schwenke
– Daren Schwenke, Commented Oct 27, 2009 at 4:47

Matt · Accepted Answer · 2009-10-27 04:48:46Z

4

Short anwser: extract

long anwser : don't. It may seem like a good anwser now but if you use it much it will become a problem keeping track of stuff.

answered Oct 27, 2009 at 4:48

Matt

4501 gold badge4 silver badges11 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-14 22:25:35Z

3

CommunityBot

11 silver badge

answered Oct 27, 2009 at 4:47

fiskah

5,8906 gold badges39 silver badges58 bronze badges

Community · Accepted Answer · 2023-11-17 20:42:18Z

3

You probably don't ultimately want to do that, but the extract() function does this.

CommunityBot

11 silver badge

answered Oct 27, 2009 at 4:47

Justin

5,0691 gold badge23 silver badges22 bronze badges