Variables withing variable names?

[maganv0x]

Ok well I'm looking to write a script that will grab certain data from a database within a while statement. The only hitch is that I need to automate variable naming.

For example:

Let's assume the following records are in the calc table:
Name merged

---

Harry 0
Jeff 7000
Chris 323
Jeffrey 7000

while (mysql_fetch_array("SELECT * FROM calc WHERE merged != 0")) {

In this while statment I need the variables to be named according to their merged value.

Eg. $merged_record_7000 = somedata
$merged_record_323 = somedata

Is there a way to write a script that will automaticaly name the variable based on an idea like this? I'm sure it's a simple solution, but one I can't think of off the top of my head.

[drew010]

try...

$query = "SELECT * FROM calc WHERE merged != 0";
$result = mysql_query($query);

while($data = mysql_fetch_array($result)) {
     $merged_record_$data[merged] = somedata;
}

not sure off the top of my head but i think it might work

[maganv0x]

I thought of the same thing while I was smoking a cigarette waiting for a response. I'm using an array within an array. I don't know if it'll work yet, I'm writing up the script as we speak. My variables are like so:

$query = "SELECT * FROM calc WHERE merged != 0"; 
while ($row = mysql_fetch_array($query)){
$merged_user_[$row[0]] = somedata

Hope it works. Never used an array within an array or whatever 😃

[Weedpacket]

It won't work: but the only thing you're missing is to use [man]mysql_query[/man] to actually run your query and get some results.

[maganv0x]

typo on my part, but yeah the array within the variable name worked like a charm