View Single Post
  #61 (permalink)  
Old 05-11-2008, 04:08 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
 
Join Date: Feb 2008
Posts: 704
Last Blog:
Programming "Just a ...
Rep Power: 8
phpforfun will become famous soon enoughphpforfun will become famous soon enough
Default Re: My new site... wanna give me a quick hand?

wtf, do you guys see an error?
PHP Code:
                    $query  "UPDATE `webmasters` SET `hostemail` = '$newhostemail', `hosttitle` = '$newhosttitle',";
                                        
$query .= " `hosturl` = '$newurl', `profile` = '$clean_newprofile', `PHP` = '$PHP',";
                                        
$query .= " `ASP` = '$ASP', `java` = '$java', `python` = '$python', `JDK` = '$JDK', `flash` = '$flash',";
                                        
$query .= " `ruby` = '$ruby', `tomcat` = '$tomcat', `SSI` = '$SSI', `CGI`='$CGI', `cpanel` = '$cpanel',"
                                        
$query .= " `SQL` = '$SQL', `emails` = '$emails', `subdomains` = '$subdomains', `SSH` = '$SSH',";
                                        
$query .= " `winxp` = '$newwinxp', `winnt` = '$newwinxp', `win03` = '$newwin03', `win08` = '$newwin08',";
                                        
$query .= " `macos` = '$newmacos', `linrh3` = '$newlinrh3', `linrh4` = '$newlinrh4', `linrh5 = '$newlinrh5',";
                                        
$query .= " `linopensuse` = '$newlinopensuse', `linopenbsd` = '$newlinopenbsd', `linfreebsd` = '$newlinfreebsd',";
                                        
$query .= " `linfed1` = '$newlinfed1', `linfed2` = '$newlinfed2', `linfed3` = '$newlinfed3',";
                                        
$qyery .= " `linfed4` = '$newlinfed4', `linfed5` = '$newlinfed5', `linfed6` = '$newlinfed',";
                                        
$query .= " `sitebuilder` = '$sitebuilder', `lastupdated` = '$date', `picture` = '$usepic' WHERE `id`='$id'";
                    
mysql_query($query) or die('Error in query: '.$query.' :<br /><br /> 'mysql_error()); 
Quote:
Error in query: UPDATE `webmasters` SET `hostemail` = 'support@analyzethathost.com', `hosttitle` = 'Sample Profile', `hosturl` = 'http://analyzethathost.com', `profile` = 'This is a sample profile used to show you what a webmasters profile looks like.', `PHP` = 'yes', `ASP` = 'yes', `java` = 'yes', `python` = 'yes', `JDK` = 'yes', `flash` = 'yes', `ruby` = 'yes', `tomcat` = 'yes', `SSI` = 'yes', `CGI`='yes', `cpanel` = 'yes', `SQL` = 'yes', `emails` = 'yes', `subdomains` = 'yes', `SSH` = 'yes', `winxp` = 'no', `winnt` = 'no', `win03` = 'no', `win08` = 'no', `macos` = 'no', `linrh3` = 'no', `linrh4` = 'no', `linrh5 = 'no', `linopensuse` = 'no', `linopenbsd` = 'no', `linfreebsd` = 'no', `linfed1` = 'no', `linfed2` = 'no', `linfed3` = 'no', `sitebuilder` = 'yes', `lastupdated` = '05.11.08', `picture` = 'yes' WHERE `id`='1' :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'linopensuse` = 'no', `linopenbsd` = 'no', `linfreebsd` = 'no', `linfed1` = 'no',' at line 1
Im so confused
__________________
Free Proxy || Reliable Hosting
Reply With Quote