awesome, thanks both of you! --- Kristina
> > For #1, if you had parentheses around what you want together, MySQL will understand what to return. For example (no logic here, just example): > SELECT * FROM table WHERE ( this=this ) AND ( ( that=that OR > thing=thing ) OR ( ( blah=blah OR foo=foo ) AND ( bar=bar OR etc=etc ) ) ) > > > ----- Original Message ---- > From: Kristina Anderson <[EMAIL PROTECTED]> > To: talk@lists.nyphp.org > Sent: Wednesday, May 28, 2008 3:42:44 PM > Subject: [nyphp-talk] MySQL Syntax questions > > 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? > > 2. How can I select the last row inserted from a table WHERE > field1=somethingineed and field2 is NULL? > > Thanks in advance...full of questions today I am! > > > > --- Kristina > _______________________________________________ > 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 > > _______________________________________________ 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
