Problem about mysql_query

[Dakkar]

I have a mysql query like this

$query = mysql_query("select contentid,groupid,title,subgroupid from site.ezc_contents where groupid='$arsiv'");

and i want to show every data which fits that query so i wrote a script like this but it didnt work

	foreach ($query as $sorgu) {
	$sonuc = mysql_fetch_row($query);
	echo "<a href=\"http://www.sy.com/showcontents.php?topgroupid=8&subgroupid=$sonuc[3]&groupid=8\">$sonuc[2]</a>";
	}

What should i do? Are there any mysql_ function for this?

[nunomira]

hi,

what about something like this:

<?php
$query = "select contentid,groupid,title,subgroupid from site.ezc_contents where groupid='$arsiv'";
$result = mysql_query($query) or die ("can't execute query: ") . mysql_error ();

while ($row = mysql_fetch_array ($result))
{
	echo "<a href=\"http://www.sy.com/showcontents.php?topgroupid=8&subgroupid=$row[3]&groupid=8\">$row[2]</a>"
}
?>

You execute the query only once, and loop through the results.
The loop is provided by the while()

I also used more usual variable names (which I think is always good being familiar with).