NYCPHP Meetup

NYPHP.org

[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