RE: [PHP-DB] mysql wildcard

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: [PHP-DB] 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!