Jump to content

Dynamic variables & retrieving row data


lxndr

Recommended Posts

Is it possible to retrieve row data using php dynamic variables?

For example,

[code]$sql = "SELECT * FROM table WHERE row = '$rows'  ";
$result = mysql_query($sql, $db);
$row=mysql_fetch_array($result);
$col1 = $row["col1"];
$col2 = $row["col2"];[/code]

works fine but can I use a dynamic variable to retrieve the column data (the columns are named col1, col2. col3 etc)

I tried this:

[code]${'col'.$cols} = $row["{'col'.$cols}"];[/code]

but that doesn't work, can anyone help?


Now fixed.  Please disregard.


Link to comment
https://forums.phpfreaks.com/topic/30150-dynamic-variables-retrieving-row-data/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.