tombruton

I not have it working. I deleted the query and wrote exactly the same thing again and it worked. I did copy and past the statment then changed the info inside. Might be some of those microsoft magic quotes in there

I can fetch the results not a problem. tried removing all wite space cant get it working

i will have a look as soon as my girlfriend has finished watching xfacor on my laptop, any other ideas of what it could be, I really just can't work it out

sorry its the validated field, checked the right information is being posted in GET, thats why I put it in hardcoded. no luck tho.

no errors its just not updating the field from no to yes. cheers for the reply

<?php include 'heading.php'; include 'connect.php'; $username = $_GET["username"]; $validate = $_GET["key"]; print $username; print $validate; $query_activate_account = "UPDATE user SET validated = 'yes' WHERE (username = '$username' AND validationkey = '$validate')"; mysql_query("UPDATE user SET validated = 'yes' WHERE (username = 'lkmlklkmlkm' AND validationkey = '09f6b3d1fb65bb9f25965ab910376ef8'"); ?> it was mysql_query("UPDATE user SET validated = 'yes' WHERE (username = '$username' AND validationkey = '$validate'"); just put fixed values into test

I have a class in which I have a function called connection. I am now trying to call this function from another class, but it will not work. It works if I put the code in from the other function rather than calling it but that defeats the purpous. class locationbox { function location() { $databaseconnect = new databaseconnect(); $databaseconnect -> connection();{ $result = mysql_query("SELECT * FROM locations"); while($row = mysql_fetch_array($result)) // line that now gets the error, mysql_fetch_array() expects parameter 1 to be resource, boolean given //in { echo "<option>" . $row['location'] . "</option>"; } } }}