suddendly my code stopped working on 2 separate servers. did something in the new version of php change how this works or something?
$result = mysql_query("SELECT * FROM list WHERE email='$email'",$db); $myrow = mysql_fetch_array($result);
Am i missing something?
if the server was upgraded and changed to a more recent version...register globals will not be on therefore if you were to try and use the form element named email there is no automatic conversion to a variable called $email
you will need to use $POST or $GET depending on the form method
ex.
$email =$_POST['email'];
Yeah, i'm getting $email thru the url and using: extract($_REQUEST);
but i'm still getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
Make sure the table name and field name are correct. Also make sure the $db variable has the correct username password and db name in it etc..
Sounds like an SQL problem not a PHP problem.
echo out the sql before running the query and check for well-formedness (quotes in the right places, tablename correct etc)
