variable problem

[Anon]

I have a page I am having trouble with. I am trying to reference a variable with a variable with a while loop. The code looks like this:

$loop = 1;
while ($id$loop) {

$sql = "SELECT * FROM classicdye WHERE id = $id$loop";

$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);

$id1 = $myrow["id"];

$name1 = $myrow["name"];

$color1 = $myrow["color"];

$ci1 = $myrow["ci"];

$quantity1 = $myrow["quantity"];

$price1 = $myrow["price"];

$srchcolor1 = $myrow["srchcolor"];

$type1 = $myrow["type"];

print("<tr><td>$name1</td><td>$srchcolor1</td><td>$type1</td></tr>");
$loop ++;
}

What I need is for it to reference as $id1, $id2, etc. Any help with this would be very appreciated.

moonie 😉

[webmaster02]

when you call the when statement, what are you asking it to do?

In a while statement, you must call a function like isset() or empty() or a comparison/contrast deliniator, ie: < > = !=...

If you fix this, I will be able to understand better and help you more.

Brad Taylor
Senior Web Producer
BradCom Industries LTD
brad_at_getcoded.net (Please replace at with @)

[rrijnders]

Your problem is one of "de-referencing" a variable. Help on this can also be found at:

http://www.phpbuilder.com/manual/language.variables.variable.php

What you want to do is create a varable to hold a value that corresponds to another variable name; ie:

$varholder = 'myVariable';

when you have a variable named "$myVariable" whose contents are, say, "Hello World".

Then you want to say
print $varholder;
but you really want it to print "Hello World" and not "myVariable".

To do this, you have to "de-reference" the variable correctly by using:
print ${$varHolder};

To make you code work:

=============================
<?php

$varbase = 'id';
$varext = 1;
$varvar = $varbase . $varext;

while (is_set(${$varvar})) {

$sql = "SELECT * FROM classicdye WHERE id = ${$varvar}";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

$id1 = $myrow["id"];
$name1 = $myrow["name"];
$color1 = $myrow["color"];
$ci1 = $myrow["ci"];
$quantity1 = $myrow["quantity"];
$price1 = $myrow["price"];
$srchcolor1 = $myrow["srchcolor"];
$type1 = $myrow["type"];
print("<tr><td>$name1</td><td>$srchcolor1</td><td>$type1</td></tr>");

$varext++;
$varvar = $varbase . $varext;

} // while loop

?>

HTH

-- Rich Rijnders
-- Irvine, CA US