loop results into variable

[Anon]

hi,

i've got a standard database query that simply loops through to display all the results as follows:

$abfrage ="select link, url from d3 order by link";$erg = mysql_db_query("database",$abfrage,$verbindung);while (list($link,$url) = mysql_fetch_row($erg))

this in turn then can be echoed back using

{echo "<DT><A href=\"$url\" ADD_DATE=\"962438669\" LAST_MODIFIED=\"962438670\" LAST_VISIT=\"971186400\">$link</A>\n";}

and that works fine, how now do i have to change the code, that instead of echoing back the results, it reads the results into a variable?

when i try using:

$res1 = "<DT><A href=\"$url\" ADD_DATE=\"962438669\" LAST_MODIFIED=\"962438670\" LAST_VISIT=\"971186400\">$link</A>\n";

it creates $res1 but only the very first line of the results, not the whole dataset.

thanx for any help
.::jan

[Anon]

$res1 .= "<DT><A href "

$res1 .= "hello"
is the same thing as
$res1 = $res1 . "hello"

NB.
$res1 doesn't have to exist!
No need to init $res1 = "";

[Anon]

i got it working, thank you very much!