[PHP-DB] search syntax

hi everyone, I'm writing the code to make my mysql database searchable. I can search two columns, but I seem to have problems when I try to search three. In the SELECT statement, this WHERE statement works: WHERE column1 OR column2 LIKE '%$search%' AND... This WHERE statement doesn't work:

Re: [PHP-DB] search syntax

Great--it works now. Thanks very much, Tony. I appreciate your help. best, Matt - Original Message - From: Tony [EMAIL PROTECTED] To: Matthew K. Gold [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 22, 2002 1:01 AM Subject: Re: [PHP-DB] search syntax Try break up the query

[PHP-DB] or statement in url

can I use an OR operator in a variable that is passed through a url? ex. how can I combine the following two lines so that I end up with records that have an id of either 1 or 2? http://www.xyz.com/foo.php?FooID=1 http://www.xyz.com/foo.php?FooID=2 (I tried the following, but it didn't work:

[PHP-DB] passing variables from one page to another

Hi Everybody, Please forgive the basic nature of this question--I have looked at the manual, but I found that much of it went over my head. I'm trying to create a second level of a website that displays course listings. The first level lists a bunch of courses. I'd like users to be able to

Re: [PHP-DB] passing variables from one page to another

and course.InstitID = instit.InstitID and course.ProfID = prof.ProfID; Martin Matthew K. Gold [EMAIL PROTECTED] 07/08/02 03:40PM Hi Everybody, Please forgive the basic nature of this question--I have looked at the manual, but I found that much of it went over my head. I'm trying to create a second level

Re: [PHP-DB] passing variables from one page to another

= instit.InstitID and course.ProfID = prof.ProfID; Martin Matthew K. Gold [EMAIL PROTECTED] 07/08/02 03:40PM Hi Everybody, Please forgive the basic nature of this question--I have looked at the manual, but I found that much of it went over my head. I'm trying to create a second level

Re: [PHP-DB] passing variables from one page to another

, I'm very new at this, so the answer could be very basic. thanks, Matt - Original Message - From: Hutchins, Richard [EMAIL PROTECTED] To: 'Matthew K. Gold' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 4:35 PM Subject: RE: [PHP-DB] passing variables from one page

Re: [PHP-DB] passing variables from one page to another

into the browser: courseinfo.php?CourseID=12 Could that be the source of the problem? thanks, Matt - Original Message - From: Rich Hutchins [EMAIL PROTECTED] To: Matthew K. Gold [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 5:39 PM Subject: RE: [PHP-DB] passing variables