View Single Post
  #7 (permalink)  
Old 05-02-2008, 04:10 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 Re: query wont insert?

Hum.. I tried that too john, doesnt work..

feel free to log in and test it.

Analyze That Host
click login
use "Justin" and "pass"
after you login, hover over "member actions" (where login was), and click edit host profile

and then just edit whatever

here is the code
PHP Code:
                    $newprofile mysql_real_escape_string($newprofile);
                    
$query="UPDATE webmasters SET hostemail='$newhostemail', hosttitle='$newhosttitle', hosturl='$newurl', 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) or die('Error in query: '.$query.' : '.mysql_error($connection));  
                    
                    
$noticetitle "Success";
                    
$noticedata "Your Profile Has Been Updated";
                    
$refresh "index.php?action=viewhost&hostid=$id";
                    include(
"notice.php"); 

EDIT: The sql type is set as "text", is that ok?

Last edited by phpforfun; 05-02-2008 at 04:16 PM. Reason: sql stuff
Reply With Quote