Thanks! select * from offtime where type='%' didn't work but when I change = to 'like' it works great! Thanks, Eddie -----Original Message----- From: Marco Tabini [mailto:marcot@tabini.ca] Sent: Wednesday, January 08, 2003 4:57 PM To: Edward Peloke Cc: php-db@lists.php.net Subject: Re: mysql wildcard You probably want something like: select * from offtime where type like '{$type}%' As a side note, are you making sure that $type does not contain any malicious code? Cheers, Marco -- ---------------- php|architect - The Monthly Magazine for PHP Professionals Come check us out on the web at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
