RE: [PHP] Searching My Database

2004-09-29 Thread Jeff McKeon
note, with mysql you can use a $_POST[] type variable directly in a query if you surround it with {} So... $query = "Select * from table where field1 = '{$_POST['blah']}'"; Jeffrey S. McKeon Manager of Information Technology Telaurus Communications LLC [EMAIL PROT

RE: [PHP] Searching My Database

2004-09-29 Thread David Arkell
Maybe what you want is if (isset($_POST['WorkPermit'])) { $WorkPermit = $_POST['WorkPermit']; // do the select statement } else echo "no search"; } -Original Message- From: Harlequin [mailto:[EMAIL PROTECTED] Sent: 29 September 2004 08:15 To: [EMAIL PROTECTED] Su

RE: [PHP] Searching My Database

2004-09-29 Thread Jay Blanchard
[snip] I've read around the subject of searching and although using the FULLTEXT capability of MySQL might be the proper way of doing this I feel it's somewhat limited and have decided to use a simple select procedure. [/snip] Once again, might this not be better on the MySQL list? They may exp

Re: [PHP] Searching My Database

2004-09-29 Thread Silvio Porcellana
I don't think this is the best list to ask questions about SQL, try http://lists.mysql.com Cheers! Silvio Porcellana Harlequin wrote: Morning everyone. I've read around the subject of searching and although using the FULLTEXT capability of MySQL might be the proper way of doing this I feel it's