hmmm

NoRp

ok heres my problem its only small and im prolly just missing something tiny
but here goes
ill try to give an example

$query = "SELECT * FROM planets";
$result = mysql_query($query) or die("Invalid query:" .mysql_error() );
$num_rows = MYSQL_NUM_ROWS($result);

$i=0;
while ($i < $num_rows) {

$id=mysql_result($result,$i,"id");
$owner=mysql_result($result,$i,"owner");
$res=mysql_result($result,$i,"res");
$pic=mysql_result($result,$i,"pic");

$fontsize="2";

$a1="cow";
$a2="pig";

//set this so when $a1 is retrived from the date base it will echo cow and $a2 will be pig

echo "<img src=\"http??????????????????????/$pic\">"; 
echo "<font face=$font size=$fontsize> Planet $id <br> Planet owner $owner <br> RES $res <br> </font> <br>";




++$i;
}

now every thing works except it does not change the $a1 to cow or $a2 to pig
and i dont just want cow & pig in my database, this is just an example of what im trying to do

is it posible ifso how?

mtmosier

Looks like you need the eval function. But be careful with it. eval'ing anything originating from the user is dangerous.

leatherback

Hi NoRP,

Please post the actual code. This does not make sense: You talk about getting $a1, $a2 from the database, but you do not get them from there, you just state that htey should have a certain value. If this doesn't happen, then $i is never < $num_rows, and you will not get any output at all. But from your post you have no problem there?

NoRp

actually the row

$res=mysql_result($result,$i,"res");

gets the $a1 and $a2 from the "res" part in the database table

and it does work coz when i use even this code i get

(the picture)Planet 1
Planet owner NoRp
RES $a1 $a2

so my code below is correct and $a1 $a2 is retrived from the database but its not chagning ill go give the eval a shot never herd of it before so i still may not get a solution

so if anyone has an other way please share it with me

NoRp

tried eval still no look

$ress = 'This planet has $res in it.';
echo $ress. "\n";
eval("\$ress = \"$ress\";");
echo $ress. "\n";

//The above example should show: 
//This planet has $res in it.
//This planet has cow $a2 in it.

but im still getting
This planet has $res in it. This planet has $a1 $a2 in it
am i doing somthing wrong in the eval?

mtmosier

I think you want something more like

eval("\$res = \"$res\";");

In other words, the string containing the variables you want expanded should be in the quotes, not a string containing a variable containing other variables to be expanded. It only expands vars once.