BetterPHP

$tpl = "";
$query2 = $dekaron->SQLquery("SELECT * FROM character.dbo.user_character_achievements WHERE character_no = 'C12090560000000127' ");
$data = $dekaron->SQLfetchArray($query2);

$query3 = $dekaron->SQLquery("SELECT * FROM account.dbo.user_achievements ");
while ($achie = $dekaron->SQLfetchArray($query3))
{
	$id = "achid_".$achie['id'];
	$done = $data[$id];
	$tpl .= "<tr><td><img src='achimg.php?done=".$done."&triggers=".$achie['triggers']."&finished_triggers=".$done."&name=".urlencode($achie['name'])."&desc=".urlencode($achie['desc'])."&id=".$achie['id']."'></td></tr>";
}

Ok code may seem crappy but i CANNOT change it


here is what the prob is

I need to have a value from the database $data['achie_xx']
the XX refers to $achie['id'], so my question is how to i get $data['achie_1'], $data['achie_3'],$data['achie_9'] ?


thx

<?php
$data = $ur_sql_stuff['here']
$data2 = $ur_sql_stuff['there']

$array = array('name' => $data, 'name2' => $data2);

echo $array[0];
echo $array[1];
?>

?

You can combine variables...

$data["achie_{$achie['id']}"]

The string in the array key is just like any other string.

Thx for that