variable for pulling db

[nagasea]

$xx = "$show[keyword]";

$Qgenre     	= "SELECT * FROM `$create_table`";
$result    		= mysql_query($Qgenre);
while ($show 	= mysql_fetch_array($result)){
              print "$xx <br>";
}

how come this one is not works ?

but this one works:

$Qgenre     	= "SELECT * FROM `$create_table`";
$result    		= mysql_query($Qgenre);
while ($show 	= mysql_fetch_array($result)){
              print "$show[keyword] <br>";
}

but i need to use the $xx (the first one for my coding purpose)

[Norman_Graham]

Hi Nagasea

You have created the variable $xx using a value which is empty at the time of creation. The value $show[keyword] is created by the MySQL query. If you define $xx prior to the query, then $xx will always be empty.

HTH

Norm