Hey guys. I posted before about this problem but I think I scared you off by the large amount of code I posted heh. Well ive narrowed down the problem to the $mid var. The problem is that it wont get into my UPDATE query! here is the following code: (MUCH shorter this time heh)
variables.php
if($a_row = mysql_fetch_array($query0)){
$mid = $a_row["mid"];
}
In the variables.php file. The var $mid gets defined. I've tested it by echoing it on a random part of the page, and it was successful. Now if I put $mid into my UPDATE query, which is...
"UPDATE cph_members SET email = '$email', firstName = '$firstName', lastName = '$lastName', username = '$username', aboutme = '$aboutme' WHERE mid = '" . $mid . "'";
...it wont work! The display.php page includes the following files in this order:
variables.php
functions.php
Note: The UPDATE query is in a function called "update_profile()" in the functions.php file.
Help will be much appreciated! thankyou!
PS: If you would like to see the update_profile() function, then just post so. thx again.
