NYCPHP Meetup

[Kristina Anderson]

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?

--Kristina

> On May 28, 2008, at 4:42 PM, Kristina Anderson wrote:
> 
> > I have two questions regarding syntax for MySQL queries.
> >
> > 1.  I have complex queries where there are lots of conditional
> > statements, i.e. SELECT * FROM table WHERE this=this AND that=that 
OR
> > thing=thing OR blah=blah OR foo=foo AND bar=bar OR etc=etc OR
> > thing2=thing2...
> >
> >
> > They are not erroring out but they aren't narrowing the resultset
> > sufficiently...do I need parentheses or is there something else I  
> > need?
> >
> 
> In short: you have to be careful of how expressions are evaluated.   
> More parenthesis are likely the solution.
> 
> 
> > 2.  How can I select the last row inserted from a table WHERE
> > field1=somethingineed and field2 is NULL?
> 
> If you've got an auto_increment field (named "id", perhaps):
> 
> SELECT max(id) as lastId FROM table where feld1='foo' and field2 is 
null
> 
> -Tim
> 
> _______________________________________________
> 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
> 
>