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
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
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 |
> |
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
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