Code: Select all
for($aaa=0; $aaa<=$max; $aaa++){
$sql = "SELECT first{$aaa}last FROM mytable WHERE id=$aaa";
$result = mysql_query($sql);
$myvalue = mysql_result($result,0,0);
}- first0last
first1last
first2last
first3last
first4last
Moderator: General Moderators
Code: Select all
for($aaa=0; $aaa<=$max; $aaa++){
$sql = "SELECT first{$aaa}last FROM mytable WHERE id=$aaa";
$result = mysql_query($sql);
$myvalue = mysql_result($result,0,0);
}Code: Select all
$sql = "select first".$aaa."last from mytable where id = ".$aaa;