Re: [PHP-DB] Another newbie question

2004-09-07 Thread Wolfgang Ebneter
charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Am Montag, 6. September 2004 23:50 schrieb Pete Holsberg: [...] > $sql =3D "SELECT * FROM $table "; > $sql .=3D "WHERE `LastName` LIKE $search_string "; > $sql .=3D "OR `FirstName` LIKE $search_s

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
> --- Pete Holsberg <[EMAIL PROTECTED]> wrote: > > > On Mon, 6 Sep 2004 > > [EMAIL PROTECTED] wrote: > > > > > you should copy/paste that into a command-line > > msyql > > > session and see if that works. > > > > > > I cut the query back to > > > > SELECT * FROM Directory WHERE `LastName` LIKE

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Stuart Felenstein
I think you need to put '' around joe 'joe' Stuart --- Pete Holsberg <[EMAIL PROTECTED]> wrote: > On Mon, 6 Sep 2004 > [EMAIL PROTECTED] wrote: > > > you should copy/paste that into a command-line > msyql > > session and see if that works. > > > I cut the query back to > > SELECT * FROM Direc

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
On Mon, 6 Sep 2004 [EMAIL PROTECTED] wrote: > you should copy/paste that into a command-line msyql > session and see if that works. I cut the query back to SELECT * FROM Directory WHERE `LastName` LIKE Joe ORDER BY Street, HouseNum, LastName and ran it manually. I got --- SQL-query : SELE

[PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
The following code results in the error message "Couldn't execute query." --- Search Results http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Brunner, Daniel
> -- > From: Matt Coyne > Sent: Monday, March 26, 2001 5:39 AM > To: PHP DB > Subject: [PHP-DB] Another newbie question > > Hi guys/gals > > Having had my head sorted out by this list already today, I am in need > of > some more

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Michael Rudel
ge- > From: Matt Coyne [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 26, 2001 3:22 PM > To: PHP DB > Subject: Re: [PHP-DB] Another newbie question > > > Hi Michael > > Thanks for the prompt reply, much appreciated > > I can see where the code snippet is going. Cre

Re: [PHP-DB] Another newbie question

2001-03-26 Thread Matt Coyne
> Date: Mon, 26 Mar 2001 14:48:20 +0200 > To: "'Matt Coyne'" <[EMAIL PROTECTED]>, "'PHP DB'" <[EMAIL PROTECTED]> > Subject: RE: [PHP-DB] Another newbie question > > OK, Matt, so you've got the basics =8). > > Your beginn

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Michael Rudel
ROTECTED]] > Sent: Monday, March 26, 2001 1:39 PM > To: PHP DB > Subject: [PHP-DB] Another newbie question > > > Hi guys/gals > > Having had my head sorted out by this list already today, I > am in need of > some more help...!! > > I have an input form that, through p

[PHP-DB] Another newbie question

2001-03-26 Thread Matt Coyne
Hi guys/gals Having had my head sorted out by this list already today, I am in need of some more help...!! I have an input form that, through php queries a MySQL db and passes results back and the browser displays them (at this stage just as a list). I have been looking into the LIMIT command t