prongs_386

err.... that didn't work... Unknown column 'usrec' in 'where clause' any other suggestions

thankyou redarrow, I will try that. I have one last query, i have written a section that will call an unregister page and this page must call delete on a sql database. the first collumn is user for usernames, and the second is conf for confirmation status. I have a variable $usrrec that holds the username which i want to remove eg 'user1' and i want to delete the row in which user has an entry of 'user1' How can i do this?

ok, thanx for the quick replies. But i just managed to solve it! the solution didnt make sense to me in relation to the behaviour but what i did was remove the second while statement and put the if statement in the first 1(the statement which sets $stat = 1) my other problem is though, my register function happens after the display function, so if a user successfully registers, their name wont appear untill the next refresh. how can i insert a bit of code that will just load the page again?

Hi, my code bassically allows a user to add their username by clicking a button. (the username is given through a phpbb function) A table is then displayed with al the results. This is working fine, but my error has come up when trying to stop users registering if they already exist on the database. I did this by having a loop which will set $stat = '1'; only if the userrname is the same, people can only press the register button while $stat = '0'; The problem is, $stat never seems to be set to 1, even though i know both values which i am comparing are equal. I echo them both and they are both the same, but my if ($usr == $username){ $stat = '1';} never seems to get through I have attached my code. Please help P.S. I know its a mess ;) [attachment deleted by admin]