12-01'and '2002-12-31'.
> Otherwise try
> where date > '2002-12-01 00:00:00'and date < '2002-12-31 23:59:59'
> Regards
>
> Peter Goggin
> - Original Message -
> From: "Matthew Moldvan" <[EMAIL PROTECTED]>
> To: &q
Hi all,
I would like to do a query like this from mysql:
select * from table where date = '2002-12';
However unless I have the complete date '2002-12-26' the query doesn't work
correctly. What else do I need?
Thanks in advance,
Max
--
PHP Database Mailing List (http://www.php.net/)
To uns
mysql mailing list that basically
say
> that this functionality (unions, subselects) does not exit within mysql
yet
> (I am just learning php/databases).
>
> Is there a way I can run this query in mysql? If not can I fake it out
with
> php? What would the best way to do that be?
&
ay to do that be?
Thanks in advance,
Max
"Max Clark" <[EMAIL PROTECTED]> wrote in message news:...
> So I am trying to accomplish something like this:
>
> select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size)
> from transport as a, acl as
Hi-
I am trying to insert information into mysql based with the sql queries
below. When I run this insert from the mysql console everything works
correct, however, when I run this through php the second sql query doesn't
execute (I'm assuming there is a problem with the last_insert_id()).
I have
