My new site... wanna give me a quick hand?

[phpforfun]

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


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

[phpforfun]

I See It!

[Xav]

I See It As Well!

[Martin_kp]

Originally Posted by phpforfun

Will include various versions of windows, linux, and mac os, thank you guys!
So what do you think I should add?
Windows xp, windows 2003, windows server 2008, linux centos, linux redhat, linux fedora, mac os... any others?

Ill add in certain versions of things too, php, apache, sql, OS, etc...

site is laggy now because its on my "server", once its done, I think ill go with toasted penguin.

I posted it in the hosting forum because.. its for host, I figured people would help me there more than here, but this works as well, thanks!

You might want to add Windows Vista. I'm using Vista, went to the site and ERROR!

[Xav]

Windows Vista as a server? Ouch.

[phpforfun]

im hoping its windows 2008, thats vista based, lol

[DevilsCharm]

I can't imagine a Vista server would operate very well. Stick with Linux when it comes to servers, very efficient.

[phpforfun]

true! But I did get a chance to play with win server 2008, very nice

[Jordan]

I've yet to try Server 2008. You should write a blog about is so I can get an inside opinion!

[Xav]

To be honest, I'm not sure I'd trust Vista with my website...