going blind for looking...need eyes

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

 



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

[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