Re: [PHP-DB] search syntax

2002-07-21 Thread Matthew K. Gold
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 synta

[PHP-DB] search syntax

2002-07-21 Thread Matthew K. Gold
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: W

[PHP-DB] or statement in url

2002-07-18 Thread Matthew K. Gold
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:

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

2002-07-08 Thread Matthew K. Gold
: 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 from one page to another > Just wanted to eliminate one possible problem area. If the query works, then >

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

2002-07-08 Thread Matthew K. Gold
27;ve mentioned, 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 Subje

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

2002-07-08 Thread Matthew K. Gold
> > Subject: Re: [PHP-DB] passing variables from one page to another > > > > > > If that is your exact code, then you need to have an ending quote after > > the > > query is written. Like this: > > > > $query = "Select * from course, disc, instit,

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

2002-07-08 Thread Matthew K. Gold
d course.DiscID = disc.DiscID 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

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

2002-07-08 Thread Matthew K. Gold
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 cli