Re: [PHP] going blind for looking...need eyes

2009-02-06 Thread Daniel Brown
On Fri, Feb 6, 2009 at 13:03, Jochem Maas wrote: > > there are a zillion variations on this theme (e.g. using HEREDOC syntax > and/or putting each field & value That's right, when reading the OP's email, there was meant to be a #4 as well. 4.) Use HEREDOC syntax: -- daniel.br...@pa

Re: [PHP] going blind for looking...need eyes

2009-02-06 Thread Jochem Maas
Daniel Brown schreef: > On Fri, Feb 6, 2009 at 12:44, Terion Miller wrote: >> - >> $sql = "INSERT INTO admin (UserName, Password, Name, Email, Property, >> Department, AddWorkOrder, "; >>$sql .= "ViewAllWorkOrders, ViewNewOrders, ViewNewArt, >> ViewPendingWorkOrders, Vi

Re: [PHP] going blind for looking...need eyes

2009-02-06 Thread Daniel Brown
On Fri, Feb 6, 2009 at 12:44, Terion Miller wrote: > > - > $sql = "INSERT INTO admin (UserName, Password, Name, Email, Property, > Department, AddWorkOrder, "; >$sql .= "ViewAllWorkOrders, ViewNewOrders, ViewNewArt, > ViewPendingWorkOrders, ViewPendingArtwork, ViewCompl

[PHP] going blind for looking...need eyes

2009-02-06 Thread Terion Miller
Need eyes on this query, it is not inserting, I am going to highlight what/where I thought the problem is (there is no " )but when I add the " it then changes the syntax coloring on the rest of the code in my editor which makes me wonder if I'm wrong... argh. and either way it's not inserting ...