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:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 4:57 PM To: Edward Peloke Cc: [EMAIL PROTECTED] 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! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
