Smarty

[daoho]

Hi everybody...

I'm actually working in a research center with smarty and i've got a problem :

here is the php code for doing an array with the result of my SQL request

[AZTEK]

There your just overwritting the same variable over and over which isn't much use. I suggest you use an array of fields something like[php:1:0bd13602f4]$sql_affich="SELECT * FROM ".$table ;
$affich = mysql_query($sql_affich) or die(mysql_error());

$tableau = array();
while ($rangee=mysql_fetch_assoc($affich)) {
$tableau[] = $rangee;
}
$smarty->assign('tableau', $tableau);[/php:1:0bd13602f4]then in your smarty template you can use a foreach loop

[daoho]

it could be nice but there is a problem with your code :

Parse error: parse error, unexpected T_STRING, expecting ']' in c:\site\smarty_dir\templates_c\%%-58\%%-583032944\tab.tpl.php on line 11


first time i've got an error like that....
I paste your code without changing anything...

[messju]

i think in the foreach it should read "item=foo" and not "item=$foo". a very common mistake

[AZTEK]

Heh well I often just post code without testing
_________________
"Imagine a school with children that can read and write, but with teachers who cannot, and you have a metaphor of the Information Age in which we live." -Peter Cochrane

[messju]

me too

[EDIT: and BTW i consider it a bug in smarty that it produces invalid php in this case instead of raising a syntax error, but it's far too hot over here in germany right now to tamper in the guts of smarty_compiler.class.php for such minor issues ]