Well, if that is your only condition, why not use: 'select * from offtime' as your query? I believe the % as a wildcard is standard SQL, so I would *think* it should work in mysql, have you tried it? -Brad Edward Peloke wrote: > I have an query: > > select * from offtime where type='$type' > > then I just pass the type variable to the page. Is there a wildcard in > mysql like there is in sqlserver that I can use to grab all the records? > such as select * from offtime where type='%' would grab all. > > Thanks, > Eddie > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
