Re: Two troublesome fields (Resolved)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux