going blind for looking...need eyes
| From: | Terion Miller | Date: | Fri, 06 Feb 2009 17:44:16 +0000 |
| Subject: | going blind for looking...need eyes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-287833@lists.php.net to get a copy of this message | ||
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);