Re: Two troublesome fields (Resolved)

[Terion Miller <webdev.terion@xxxxxxxxx>]

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 <sean@xxxxxxxxxxxxxxxx>wrote:

> *From: *Terion Miller <webdev.terion@xxxxxxxxx>
> *Date: *February 19, 2009 5:34:50 PM EST
> *To: *Bastien Koert <phpster@xxxxxxxxx>
> *Cc: *PHP General <php-general@xxxxxxxxxxxxx>
> *Subject: **Re:  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
> sean@xxxxxxxxxxxxxxxx
>