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);

Reply via email to