[nycphp-talk] MySQL Syntax questions
Kristina Anderson
ka at kacomputerconsulting.com
Wed May 28 22:40:08 EDT 2008
these two don't take into consideration my conditional statements on
the two fields but I get the idea ...thanks
Kristina
> Steve Manes wrote:
> > Kristina Anderson wrote:
> >> Tim, with regard to the second query, I wanted the entire row not
> >> just the ID...do I need to do two queries to get that?
> >
> > Or a subquery:
> >
> > SELECT
> > *
> > FROM
> > table_foo
> > WHERE
> > id = (SELECT MAX(id) FROM table_foo);
> >
> >
>
> select * from table_foo order by id desc limit 1
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>
\
More information about the talk
mailing list