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
> --- 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
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
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
Hello
I too wanted to have next/previous links...
So I found this and it's the best out there...
http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html?page=1
to output the query...
echo $data->Print_Name //Or whatever you want to
display
.
Within that co
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
> 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
OK, Matt, so you've got the basics =8).
Your beginning is good, using the $Offset. Now you only have to
add navigation-buttons (First, Previos, Next, Last) with html
and a hidden field namded Offset.
LIMIT is defined as a constant. You could also use your $Limit.
here is a snippet of my navigati
