[syntax=php]
$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>";
}
[/syntax]
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
Dynamic Var in array
Re: Dynamic Var in array [Fast response plz]
[syntax=php]<?php
$data = $ur_sql_stuff['here']
$data2 = $ur_sql_stuff['there']
$array = array('name' => $data, 'name2' => $data2);
echo $array[0];
echo $array[1];
?>[/syntax]
?
$data = $ur_sql_stuff['here']
$data2 = $ur_sql_stuff['there']
$array = array('name' => $data, 'name2' => $data2);
echo $array[0];
echo $array[1];
?>[/syntax]
?
Re: Dynamic Var in array
You can combine variables...
[syntax=php]$data["achie_{$achie['id']}"][/syntax]
The string in the array key is just like any other string.
[syntax=php]$data["achie_{$achie['id']}"][/syntax]
The string in the array key is just like any other string.