i have BIG BIG problems with the UPDATE function:
Code: Select all
<?php
require_once('authenticate.inc');
require_once('connect.inc');
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Database connection failed.");
@mysql_select_db("$dbName") or die("Database not found.");
switch ($login) {
case '01': $uquery = "UPDATE staff SET staff.s01 = '".$sn01."', staff.s02 = '".$sn02."', staff.s03 = '".$sn03."', staff.s05 = '".$sn05."', staff.s06 = '".$sn06."', staff.s07 = '".$sn07."', staff.s08 = '".$sn08."', staff.s09 = '".$sn09."', staff.s10 = '".$sn10."', staff.s11 = '".$sn11."', staff.s12 = '".$sn12."', staff.s13 = '".$sn13."', staff.s21 = '".$sn21."', staff.s22 = '".$sn22."', staff.s23 = '".$sn23."', staff.s25 = '".$sn25."', staff.s26 = '".$sn26."', staff.s35 = '".$sn35."', staff.s39 = '".$sn39."', staff.s49 = '".$sn49."', staff.s50 = '".$sn50."', staff.s51 = '".$sn51."', staff.s52 = '".$sn52."', staff.s53 = '".$sn53."', staff.s54 = '".$sn54."', staff.s55 = '".$sn55."', s56 = '".$sn56."', staff.s58 = '".$sn58."', staff.s59 = '".$sn59."', staff.s60 = 'done', staff.s64 = '".$sn64."' WHERE staff.staff.s04 = '".$sc04."' AND staff.id = '".$cid."'"; break;
case '02': $uquery = "UPDATE staff SET staff.s01 = '".$sn01."', staff.s02 = '".$sn02."', staff.s03 = '".$sn03."', staff.s05 = '".$sn05."', staff.s06 = '".$sn06."', staff.s07 = '".$sn07."', staff.s08 = '".$sn08."', staff.s09 = '".$sn09."', staff.s10 = '".$sn10."', staff.s11 = '".$sn11."', staff.s12 = '".$sn12."', staff.s13 = '".$sn13."', staff.s21 = '".$sn21."', staff.s22 = '".$sn22."', staff.s23 = '".$sn23."', staff.s25 = '".$sn25."', staff.s26 = '".$sn26."', staff.s35 = '".$sn35."', staff.s39 = '".$sn39."', staff.s49 = '".$sn49."', staff.s50 = '".$sn50."', staff.s51 = '".$sn51."', staff.s52 = '".$sn52."', staff.s53 = '".$sn53."', staff.s54 = '".$sn54."', staff.s55 = '".$sn55."', s56 = '".$sn56."', staff.s58 = '".$sn58."', staff.s59 = '".$sn59."', staff.s60 = 'done', staff.s64 = '".$sn64."' WHERE staff.staff.s04 = '".$sc04."' AND staff.id = '".$cid."'"; break;
case '03': $uquery = "UPDATE staff SET staff.s01 = '".$sn01."', staff.s02 = '".$sn02."', staff.s03 = '".$sn03."', staff.s05 = '".$sn05."', staff.s06 = '".$sn06."', staff.s07 = '".$sn07."', staff.s08 = '".$sn08."', staff.s09 = '".$sn09."', staff.s10 = '".$sn10."', staff.s11 = '".$sn11."', staff.s12 = '".$sn12."', staff.s13 = '".$sn13."', staff.s21 = '".$sn21."', staff.s22 = '".$sn22."', staff.s23 = '".$sn23."', staff.s25 = '".$sn25."', staff.s26 = '".$sn26."', staff.s35 = '".$sn35."', staff.s39 = '".$sn39."', staff.s49 = '".$sn49."', staff.s50 = '".$sn50."', staff.s51 = '".$sn51."', staff.s52 = '".$sn52."', staff.s53 = '".$sn53."', staff.s54 = '".$sn54."', staff.s55 = '".$sn55."', s56 = '".$sn56."', staff.s58 = '".$sn58."', staff.s59 = '".$sn59."', staff.s60 = 'in progress', staff.s64 = '".$sn64."' WHERE staff.staff.s04 = '".$sc04."' AND staff.id = '".$cid."'"; break;
case '04': $uquery = "UPDATE staff SET staff.s01 = '".$sn01."', staff.s02 = '".$sn02."', staff.s03 = '".$sn03."', staff.s05 = '".$sn05."', staff.s06 = '".$sn06."', staff.s07 = '".$sn07."', staff.s08 = '".$sn08."', staff.s09 = '".$sn09."', staff.s10 = '".$sn10."', staff.s11 = '".$sn11."', staff.s12 = '".$sn12."', staff.s13 = '".$sn13."', staff.s21 = '".$sn21."', staff.s22 = '".$sn22."', staff.s23 = '".$sn23."', staff.s25 = '".$sn25."', staff.s26 = '".$sn26."', staff.s35 = '".$sn35."', staff.s39 = '".$sn39."', staff.s49 = '".$sn49."', staff.s50 = '".$sn50."', staff.s51 = '".$sn51."', staff.s52 = '".$sn52."', staff.s53 = '".$sn53."', staff.s54 = '".$sn54."', staff.s55 = '".$sn55."', s56 = '".$sn56."', staff.s58 = '".$sn58."', staff.s59 = '".$sn59."', staff.s60 = 'in progress', staff.s64 = '".$sn64."' WHERE staff.staff.s04 = '".$sc04."' AND staff.id = '".$cid."'"; break;}
$uerg = MYSQL_QUERY($uquery);
?>The mysql err.log is also empty:
040129 08:30:16 mysqld started
/export/home/local/mysql-3.23.53-sun-solaris2.7-sparc/bin/mysqld: ready for connections
bluenote# date
Thu Jan 29 14:33:42 MET 2004
Does anyone have a tip?
-bluenote
Help would be great.