Wow do I feel blind..it was that I missed the ISSET part at the top....didn't have it for those two fields....DOH!! Thanks all
Terion Happy Freecycling Free the List !! www.freecycle.org Over Moderation of Freecycle List Prevents Post Timeliness. ------------------------------------------------ Twitter? http://twitter.com/terionmiller ------------------------------------------------ Facebook: <a href="http://www.facebook.com/people/Terion-Miller/1542024891"; title="Terion Miller's Facebook profile" target=_TOP><img src=" http://badge.facebook.com/badge/1542024891.237.919247960.png"; border=0 alt="Terion Miller's Facebook profile"></a> P. J. O'Rourke - "Everybody knows how to raise children, except the people who have them." On Fri, Feb 20, 2009 at 8:51 AM, Sean DeNigris <s...@clipperadams.com>wrote: > *From: *Terion Miller <webdev.ter...@gmail.com> > *Date: *February 19, 2009 5:34:50 PM EST > *To: *Bastien Koert <phps...@gmail.com> > *Cc: *PHP General <php-general@lists.php.net> > *Subject: **Re: [PHP] Two troublesome fields* > > I just tried this and now it's not inserting at all where before everything > EXCEPT two fields go in... > > $sql = "INSERT INTO workorders ( CreatedDate, Location, WorkOrderName, > AdminID, FormName, Status, Notes) VALUES ("; > > $sql .= "Now(), "; > $sql .= "'". mysql_real_escape_string($Location) ."', "; > $sql .= "'". mysql_real_escape_string($WorkOrderName) ."', "; > $sql .= "'". mysql_real_escape_string($AdminID) ."', "; > $sql .= "'". mysql_real_escape_string("WorkOrder") ."', "; > $sql .= "'". mysql_real_escape_string("New Order") ."', "; > $sql .= "'". mysql_real_escape_string($Notes) ."', "; > > $WorkOrderID = mysql_insert_id(); > mysql_query($sql); > > > There's no closing parethesis to VALUES, try... > $sql .= "'". mysql_real_escape_string($Notes) ."')"; > > Sean DeNigris > s...@clipperadams.com >
![http://badge.facebook.com/badge/1542024891.237.919247960.png"](http://badge.facebook.com/badge/1542024891.237.919247960.png"){kind=link}