Jason > SELECT * FROM TABLE > WHERE sex = 1 OR country = 'CA'; > > Will select all users who are female as well as all users from Canada. You > may get duplicate records (for people who are female and from Canada) so you > may want to use DISTINCT as well.
ok... you are right... but this error (duplicated rows) just can be possible if you are selecting several tables, the data rows are not unique, or you are making some kind of join 8-) jaime -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
