while loop to choose either one or another

[rdkd1970]

I am not sure what function to use for my while loop. I am trying to get the while loop to pick either male or female depending on the choose the user made at login. The user is gender and looking_for is suppose to display either male or female. Right now it is showing all users in the db. It actually shows all the male then followed by all the females so I think it is almost there. I used the order by as the where was not working at all.

$sql2 = mysql_query("SELECT * FROM Members ORDER BY looking_for LIMIT $pn, $itemsPerPage"); 

$outputList = '';
while($row = mysql_fetch_array($sql2)) { 

$valid = array( 'Male', 'Female');
	$id = $row["id"];
	$looking_for=$row["looking_for"];
	$firstname = $row["firstname"];
	if (!$firstname) {
		$firstname = $looking_for;
		foreach($valid as $key => $value);
}

[bradgrafelman]

Why aren't you using a WHERE condition to only SELECT the rows you want?

[rdkd1970]

It was outputting blank the WHERE function. I used it as WHERE gender='looking_for' then I had WHERE id='gender' WHERE id='looking_for' WHERE username='username' WHERE username='gender' WHERE username='looking_for'.

I think I tried it all but they all left the sql blank results in the page. It was only when I switched to the ORDER BY that it actually worked with the while loop. But of course that would not be easy so now it is outputting the looking_for but all the info in the db with the males first. I tried it with the males if choosen to echo into the outputList or if female to echo into the outputList. I know it is some way it works.