Adding a WHERE to this query

[ukscotth]

Hi,

 

This is probably very easy for someone who knows how but I cant seem to get it working.

 

Can someone please tell me how I can alter this query to select a 'WHERE gender = female' so instead of picking a random user it picks a random female user ?

 

$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `users` ");
$offset_row = mysql_fetch_object( $offset_result ); 
$offset = $offset_row->offset;
$user1b = mysql_query( " SELECT * FROM `users` LIMIT $offset, 1 " );
$user1= mysql_fetch_array($user1b);

 

Also, would it be easy to modify it so it picks a second random user that isnt the same as the first user ? so I end up with 2 random females ( $user1 and $user2 )

 

Many thanks,

 

Scott

[ukscotth]

also need to add ' WHERE uid != $user' somehow.

 

Any ideas ?

[cyberRobot]

  Quote

Can someone please tell me how I can alter this query to select a 'WHERE gender = female' so instead of picking a random user it picks a random female user ?

 

 

The WHERE clause would go after the FROM:

 

<?php
$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `users` WHERE gender='female'");
//...
?>

[cyberRobot]

  Quote

also need to add ' WHERE uid != $user' somehow.

 

Any ideas ?

 

 

Which query is that supposed to be added to? Note that the following description of the WHERE clause might be helpful:

http://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html

[ukscotth]

Thanks for your reply. Its working now, I swear thats what I tried before but I must of been doing something wrong. Thanks again.

[cyberRobot]

No problem, glad to hear it's working. 

 

 

Based on the original post:

 

  Quote

...query to select a 'WHERE gender = female' so instead...

 

Maybe the first attempt didn't include the quotes around female... For example, this won't work:

 

<?php
$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `users` WHERE gender=female");
//...
?>