If you want all records, remove the where clause.

select * from mytable


Jim
 
-------Original Message-------
 
From: Edward Peloke
Date: Wednesday, January 08, 2003 02:03:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql wildcard
 
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

. 


Reply via email to