Re: going blind for looking...need eyes
| From: | Frank Stanovcak | Date: | Fri, 06 Feb 2009 18:41:38 +0000 |
| Subject: | Re: going blind for looking...need eyes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287842@lists.php.net to get a copy of this message | ||
"Terion Miller" <webdev.terion@gmail.com> wrote in message
news:37405f850902060944y74a7a5e8ndce0c3456a32d320@mail.gmail.com...
> 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
> ...
>
> ---------------------
> $sql = "INSERT INTO admin (UserName, Password, Name, Email, Property,
> Department, AddWorkOrder, ";
> $sql .= "ViewAllWorkOrders, ViewNewOrders, ViewNewArt,
> ViewPendingWorkOrders, ViewPendingArtwork, ViewCompletedArt, ";
> $sql .= "ViewCompletedWorkOrders, SearchWorkOrder, EditWorkOrder,
> DelWorkOrder, ChangeStatus, AddEditAdmin";
> $sql .= ") VALUES( '$UserName', '$Password',
> '$Name', '$Email',
> '$Property', '$Department', '$AddWorkOrder', ";
> $sql .= "'$ViewAllWorkOrders', '$ViewNewOrders',
> '$ViewNewArt',
> '$ViewPendingWorkOrders', '$ViewPendingArtwork', ";
> $sql .= "'$ViewCompletedArt', '$ViewCompletedWorkOrders',
> '$SearchWorkOrder', '$EditWorkOrder', '$DelWorkOrder', ";
> $sql .= "'$ChangeStatus', '$AddEditAdmin',
> '$ViewMyOrders')";
> $result = mysql_query($sql);
>
Try this for readability
------------
$sql = "INSERT INTO admin SET
UserName='$UserName',
Password='$Password',
Name='$Name',
Email='$Email',
Property='$Property',
Department='$Department',
AddWorkOrder='$AddWorkOrder',
ViewAllWorkOrders='$ViewAllWorkOrders',
ViewNewOrders='$ViewNewOrders',
ViewNewArt='$ViewNewArt',
ViewPendingWorkOrders='$ViewPendingWorkOrders',
ViewPendingArtwork='$ViewPendingArtwork',
ViewCompletedArt='$ViewCompletedArt',
ViewCompletedWorkOrders='$ViewCompletedWorkOrders',
SearchWorkOrder='$SearchWorkOrder',
EditWorkOrder='$EditWorkOrder',
DelWorkOrder='$DelWorkOrder',
ChangeStatus='$ChangeStatus',
AddEditAdmin='$AddEditAdmin'";
------------
plus there is an extra value with no matching field in the original query.
$ViewMyOrders has no field assigned to it.
Hope that helps some!
Frank