Updating a MySQL table with UPDATE - Big Prolems...
Posted: Thu Jan 29, 2004 7:31 am
Hello alltogether,
i have BIG BIG problems with the UPDATE function:
authenticate.inc and connect.inc do their work, and my vars are also initialized withe the correct values... but
NOTHING
happens! The code causes no log errors, the ZEND Debug server does not complain, and the database is not updated.
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.
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.