sc_lookup with more than 1 line of data? should i use foreach?

Scriptcase 8 Discussion
#1

hi, how we can get more than one line in mysql query using sc_lookup?

example

 
sc_lookup(dataset, "SELECT count(id), user FROM table WHERE...etc");

Now i have 5 lines as results like
{field}={dataset[0][0]}.’ user '.{dataset[0][1]}; through {dataset[5][1]}…

I want to have this:
{field}={dataset[0][0]}.’ user ‘.{dataset[0][1]} .’<br>’.
{dataset[1][0]}.’ user ‘.{dataset[1][1]}; .’<br>’.
{dataset[2][0]}.’ user ‘.{dataset[2][1]}; .’<br>’.
{dataset[3][0]}.’ user ‘.{dataset[3][1]}; .’<br>’.
{dataset[4][0]}.’ user ‘.{dataset[4][1]}; .’<br>’.;

without having to write all that, should i use foreach? and how?

#2 

{field} = '';
foreach($dataset as $row)
{
    {field} .= $row[0].' user '.$row[1].'<br>';
}

jsb

#3

[QUOTE=jsbinca;37893]


{field} = '';
foreach($dataset as $row)
{
    {field} .= $row[0].' user '.$row[1].'<br>';
}

jsb[/QUOTE]

Merci Monsieur
thats exactly what was needed :smiley:
cheers