Re: A little SELECT syntax
From: David N Murray (dmurray_at_jsbsystems.com)
Date: 10/26/03
- Previous message: Dan: "A little SELECT syntax"
- In reply to: Dan: "A little SELECT syntax"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 26 Oct 2003 10:55:40 -0500 (EST) To: dan <dan@danneh.demon.co.uk>
1) What's the error?
2) Does your sql statement work in mysql (interactive mode)?
3) What does "WHERE 1 AND ..." mean? IOW, what's the '1 AND' supposed to
be doing?
4) Start smaller when you are developing SQL statements that you feel are
complex:
- select * from memodata where readdate = sent;
- select * from memodata where to=1 and readdate = sent;
- select * from memodata where to=1 and readdate = sent order by
id asc;
Whent the last one works properly, paste it into your script.
Dave
On Oct 26, dan scribed:
> Hi,
>
> I've got a database that stores small messages for a service, what I want to
> be able to do is get all rows from the database where the columns "sent" and
> "readdate" match, I have this, but it's erroring. Any pointers please?
>
> SELECT * FROM memodata WHERE 1 AND to=1 AND readdate=sent ORDER BY id ASC
>
> Many thanks,
>
> Dan
>
> P.S: Using MySQL, DBD::mysql, not sure if you need to know that, but saying
> anyway ;)
>
>
- Previous message: Dan: "A little SELECT syntax"
- In reply to: Dan: "A little SELECT syntax"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
