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