Re: Why oh Why????

On Thursday 16 January 2003 17:17, WMB wrote: Please use a descriptive subject! > Am trying to get rid of spaces and change all into uppercase in an entered > form variable, which I am able to do when trying things out but when > running the full php statement it refuses to change and enters the original > variable into the database anyway. Haven't got a clue why. > > Please, what's wrong with the following: > > if(mysql_result($query, 0, 0) == 0)// && (mysql_result($query2) > 0)#) > { > $password = md5($_POST['strPassword']); > $newstrUserName = $_POST['strUsername']; > $newstrUserName = strtoupper(ereg_replace(" ", "", > $newstrUserName)); So here if you echo $newstrUserName, it is correct and what you had expected? > $strQuery = "INSERT INTO users ("; > $strQuery .= "username, > password, level, > firstname, > lastname, ngfnummer, > email) VALUES ("; > $strQuery .= "'$newstrUserName', '$password', '1', > '{$_POST['strFirstName']}', '{$_POST['strLastName']}', > '{$_POST['strNgfnummer']}', > '{$_POST['strEmail']}')"; What if you now echo $strQuery? Is it still what you expected? > if(mysql_query($strQuery)) etc etc etc And you should have error checking in your code, something like: if (mysql_query($strQuery)) { do_your_stuff; } else { //an error echo mysql_error(); } or checkout the examples in the manual. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* The most costly of all follies is to believe passionately in the palpably not true. It is the chief occupation of mankind. -- H.L. Mencken */