I have been working on a script for a while now and I am nearly finished but I was just thought I was done with this file today when I got an error, Can somebody tell me what end tag to use please? I have the ?> php end tag but it will not accept it apparently. Code is bellow. If you find any errors in it please let me know, as far as I can tell this is the only problem. Thanks! <?php //==================================== // USER MANAGEMENT FUNCTIONS //==================================== //==================================== // Check if user exists //==================================== function check_user($user) { { $res = query("SELECT * FROM `cu_users` WHERE `userid` = $user"); } //==================================== // Add a new user data //==================================== function add_user( $user ) { query("INSERT INTO `cu_users` (`userid`, `ucash`, `uhealth`, `uenergy`, `uexperience`, `ulevel`, `jobs_completed`, `kill_count`, `death_count`) VALUES ( $user, 10000, 100, 10, 10, 1, 0, 0, 0 )"); } //==================================== // Add cash to user //==================================== function add_cash( $u, $c ) { $res = query("UPDATE `cu_users` SET `ucash`=(`ucash`+$c) WHERE `userid`=$user"); } //==================================== // Get User Cash //==================================== function get_cash( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[ucash]; } //==================================== // Get User Health //==================================== function get_health( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[uhealth]; } //==================================== // Get User Energy //==================================== function get_energy( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[uenergy]; } //==================================== // Get User Experience //==================================== function get_experience( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[uexperience]; } //==================================== // Get User Level //==================================== function get_level( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[ulevel]; } //==================================== // Update User Level //==================================== function update_level( $u ) { $user_exp = get_experience( $u ); $new_level = ($user_exp/50); $new_level = intval($new_level); if( $user_exp < 50 ) $new_level = 1; else $new_level++; $res = query("UPDATE `cu_users` SET `ulevel`=$new_level WHERE `userid`=$user"); } //==================================== // Get User Jobs Completed //==================================== function get_jobs_completed( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[jobs_completed]; } //==================================== // Get User Kill Count //==================================== function get_kill_count( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[kill_count]; } //==================================== // Update User Kill Count //==================================== function update_kill_count( $u ) { query("UPDATE `cu_users` SET `kill_count`=(`kill_count`+1) WHERE `userid`=$user"); } //==================================== // Get User Death Count //==================================== function get_death_count( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[death_count]; } //==================================== // Update User Death Countt //==================================== function update_death_count( $u ) { if( get_health($u) <= 0 ) { query("UPDATE `cu_users` SET `death_count`=(`death_count`+1) WHERE `userid`=$user"); return true; } else return false; } //==================================== // Get User Fight Won //==================================== function get_fight_won( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[fight_won]; } //==================================== // Get User Fight Lost //==================================== function get_fight_lost( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user"); $row = mysql_fetch_assoc($res); return $row[fight_lost]; } //==================================== // Get User Cash in BANK //==================================== function get_bank_cash( $u ) { $res = query("SELECT * FROM `cu_bank` WHERE `userid`=$user"); while( $row = mysql_fetch_array($res) ) { $user_cash = $row[bamount]; } return $user_cash; } //==================================== // Get User Rank //==================================== function get_rank( $u ) { $rank = 1; $res = query("SELECT * FROM `cu_users` ORDER BY `fight_won` DESC"); while( $row = mysql_fetch_array($res) ) { if( $row[userid] == $u ) break; else $rank++; } return $rank; } ?> Code (markup):
OK I have this now, I changed it a little, any suggestions, error is now code is <?php //==================================== // USER MANAGEMENT FUNCTIONS //==================================== //==================================== // Check if user exists //==================================== function check_user( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid` = $u"); list($total_rows) = mysql_fetch_array($res); if( $total_rows > 0 ) return true; else return false; } //==================================== // Add a new user data //==================================== function add_user( $u ) { query("INSERT INTO `cu_users` (`userid`, `ucash`, `uhealth`, `uenergy`, `uexperience`, `ulevel`, `jobs_completed`, `kill_count`, `death_count`) VALUES ( $u, 10000, 100, 10, 10, 1, 0, 0, 0 )"); } //==================================== // Add cash to user //==================================== function add_cash( $u, $c ) { $res = query("UPDATE `cu_users` SET `ucash`=(`ucash`+$c) WHERE `userid`=$u"); } //==================================== // Get User Cash //==================================== function get_cash( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[ucash]; } //==================================== // Get User Health //==================================== function get_health( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[uhealth]; } //==================================== // Get User Energy //==================================== function get_energy( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[uenergy]; } //==================================== // Get User Experience //==================================== function get_experience( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[uexperience]; } //==================================== // Get User Level //==================================== function get_level( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[ulevel]; } //==================================== // Update User Level //==================================== function update_level( $u ) { $user_exp = get_experience( $u ); $new_level = ($user_exp/50); $new_level = intval($new_level); if( $user_exp < 50 ) $new_level = 1; else $new_level++; $res = query("UPDATE `cu_users` SET `ulevel`=$new_level WHERE `userid`=$u"); } //==================================== // Get User Jobs Completed //==================================== function get_jobs_completed( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[jobs_completed]; } //==================================== // Get User Kill Count //==================================== function get_kill_count( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[kill_count]; } //==================================== // Update User Kill Count //==================================== function update_kill_count( $u ) { query("UPDATE `cu_users` SET `kill_count`=(`kill_count`+1) WHERE `userid`=$u"); } //==================================== // Get User Death Count //==================================== function get_death_count( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[death_count]; } //==================================== // Update User Death Countt //==================================== function update_death_count( $u ) { if( get_health($u) <= 0 ) { query("UPDATE `cu_users` SET `death_count`=(`death_count`+1) WHERE `userid`=$u"); return true; } else return false; } //==================================== // Get User Fight Won //==================================== function get_fight_won( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[fight_won]; } //==================================== // Get User Fight Lost //==================================== function get_fight_lost( $u ) { $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u"); $row = mysql_fetch_assoc($res); return $row[fight_lost]; } //==================================== // Get User Cash in BANK //==================================== function get_bank_cash( $u ) { $res = query("SELECT * FROM `cu_bank` WHERE `userid`=$u"); while( $row = mysql_fetch_array($res) ) { $user_cash = $row[bamount]; } return $user_cash; } //==================================== // Get User Rank //==================================== function get_rank( $u ) { $rank = 1; $res = query("SELECT * FROM `cu_users` ORDER BY `fight_won` DESC"); while( $row = mysql_fetch_array($res) ) { if( $row[userid] == $u ) break; else $rank++; } return $rank; } ?> Code (markup): Thanks!
All of your Select queries need apostrophes around your variables. Ex: $res = query("SELECT * FROM `cu_users` WHERE `userid` ='$u'");