View Single Post
  #1 (permalink)  
Old 05-01-2008, 06:17 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
 
Join Date: Feb 2008
Posts: 969
Last Blog:
Programming "Just a ...
Credits: 1
Rep Power: 11
phpforfun has a spectacular aura aboutphpforfun has a spectacular aura about
Default query wont insert?

ok, so I dont understand why this script isnt working..

PHP Code:
                    if(isset($ASP)){ $ASP "yes"; } Else { $ASP "no"; }
                    if(isset(
$PHP)){ $PHP "yes"; } Else { $PHP "no"; }
                    if(isset(
$java)){ $java "yes"; } Else { $java "no"; }
                    if(isset(
$python)){ $python "yes"; } Else { $python "no"; }
                    if(isset(
$perl)){ $perl "yes"; } Else { $perl "no"; }
                    if(isset(
$JDK)){ $JDK "yes"; } Else { $JDK "no"; }
                    if(isset(
$flash)){ $flash "yes"; } Else { $flash "no"; }
                    if(isset(
$ruby)){ $ruby "yes"; } Else { $ruby "no"; }
                    if(isset(
$tomcat)){ $tomcat "yes"; } Else { $tomcat "no"; }
                    if(isset(
$SSI)){ $SSI "yes"; } Else { $SSI "no"; }
                    if(isset(
$CGI)){ $CGI "yes"; } Else { $CGI "no"; }
                    if(isset(
$cpanel)){ $cpanel "yes"; } Else { $cpanel "no"; }
                    if(isset(
$SQL)){ $SQL "yes"; } Else { $SQL "no"; }
                    if(isset(
$emails)){ $emails "yes"; } Else { $emails "no"; }
                    if(isset(
$subdomains)){ $subdomains "yes"; } Else { $subdomains "no"; }
                    if(isset(
$SSH)){ $SSH "yes"; } Else { $SSH "no"; }
                    if(isset(
$sitebuilder)){ $sitebuilder "yes"; } Else { $sitebuilder "no"; }
                    
$date date("m.d.y"); 
                    
$query="UPDATE webmasters SET hostemail='$newhostemail', hosttitle='$newhosttitle', hosturl='$newhosturl', profile='$newprofile', OS='$newOS', PHP='$PHP', ASP='$ASP', java='$java', python='$python', JDK='$JDK', flash='$flash', ruby='$ruby', tomcat='$tomcat', SSI='$SSI', CGI='$CGI', cpanel='$cpanel', SQL='$SQL', emails='$emails', subdomains='$subdomains', SSH='$SSH', sitebuilder='$sitebuilder', lastupdated='$date', WHERE id='$id'";
                    
mysql_query($query);
                    
                    
$noticetitle "Success";
                    
$noticedata "Your Profile Has Been Updated";
                    
$refresh "index.php?action=viewhost&hostid=$id";
                    include(
"notice.php"); 
It will say success, your profile has been updated, but wont update, or give me an SQL error, do you guys see something wrong with it? I feel stupid asking
Reply With Quote

Sponsored Links