elk dolk wrote:
Chris <[EMAIL PROTECTED]> wrote:
Huh? You want before, after and including? So everything?
Maybe give us an example of what you want to get out of the query rather
than us guessing.
I keep the path to my photos in this DB so it is a photo Gallery , when I click
on a thumbnai
Chris <[EMAIL PROTECTED]> wrote:
Huh? You want before, after and including? So everything?
Maybe give us an example of what you want to get out of the query rather
than us guessing.
I keep the path to my photos in this DB so it is a photo Gallery , when I click
on a thumbnail I want to see t
elk dolk wrote:
If I understand that correctly, you only need to add the extra condition
to the WHERE clause of the main query. So:
SELECT id, name, cat FROM table
WHERE cat = (SELECT cat FROM table WHERE id = $ID) AND id <= $ID;
This should display all rows, before and including the ro
If I understand that correctly, you only need to add the extra condition
to the WHERE clause of the main query. So:
SELECT id, name, cat FROM table
WHERE cat = (SELECT cat FROM table WHERE id = $ID) AND id <= $ID;
This should display all rows, before and including the row with the same
'c
Hi
> mysql> select id,cat from table where cat=(select cat from table where id=51);
> +-+--+
> | id | cat |
> +-+--+
> | 40 | FLK |
> | 41 | FLK |
> | 42 | FLK |
> | 44 | FLK |
> | 45 | FLK |
> | 46 | FLK |
> | 47 | FLK |
> |
Jul 2007 22:17:15 +0100
From: Niel Archer <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: record pointer
Hi
> O.K. the id column is primary key and it is auto_incerment .I think my
> explanation was not clear enough :
>
> this is my query : SE
Hi
> O.K. the id column is primary key and it is auto_incerment .I think my
> explanation was not clear enough :
>
> this is my query : SELECT * FROM table WHERE ID=$ID
> this will find the record with the specified ID and I will be able to see
> it, now I want to be able to scroll up and
I am selecting by id
Dan Shirah <[EMAIL PROTECTED]> wrote: Date: Thu, 5 Jul 2007 15:51:56 -0400
From: "Dan Shirah" <[EMAIL PROTECTED]>
To: "elk dolk" <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: record pointer
Okay, in your fir
Okay, in your first post you said you were selecting by category, now you're
saying you are selecting by ID and want all corresponding records that have
the same category as the selected ID.
Which way are you trying to do this??
On 7/5/07, elk dolk <[EMAIL PROTECTED]> wrote:
O.K. the id colum
O.K. the id column is primary key and it is auto_incerment .I think my
explanation was not clear enough :
this is my query : SELECT * FROM table WHERE ID=$ID
this will find the record with the specified ID and I will be able to see it,
now I want to be able to scroll up and down to all the
10 matches
Mail list logo
