Code: Select all
$result = mysql_query("SELECT * FROM mini_info WHERE sex='$_GET[term]'") or die(mysql_error());
$row = mysql_fetch_array( $result );Then I need to get the global_id associated with the matching row
Code: Select all
$row['global_id'];so far I have:
Code: Select all
<?php
$section = $_GET['section'];
if($section == "sex")
{
$result = mysql_query("SELECT * FROM mini_info WHERE sex='$_GET[term]'") or die(mysql_error());
?>
<tr>
<td valign="top">
<?php
$row_count = mysql_num_rows( $result );
$i == 0;
while($i < $row_count)
{
$row = mysql_fetch_array( $result );
//SOME CODE NEEDS TO GO HERE!
$i++;
} ?>
</td>
</tr>
</table>
<?php
}
?>And it needs to loop through all matching rows, not just one of them, that is key
Thanks in advance