MySQL :: MySQL 5.0 Reference Manual :: 13.2.9 Subquery Syntax

If you can't use subquery, you can use this; $sec1 = mysql_query("SELECT foto FROM profoto WHERE proje=$id"); if ($kyt1 = mysql_fetch_array($sec1)) {$dizi = $kyt1["foto"];} else {$dizi="0";} while ($kyt1 = mysql_fetch_array($sec1)) {$dizi = $dizi . "," .

dev.mysql.com