Hi,
I'm creating a simple login page which goes into another page displaying the query for the user that logged in.
The problem is that it doesn't show anything and when i take out "[red]WHERE EMAIL = '$email'[/red]" it displays all the table in the DB and I only want it to show the row related to the email.
This is how the query looks like:
$email=$HTTP_POST_VARS['email'];
mysql_select_db($database_myConn, $myConn);
$query_myRs = "SELECT * FROM request [red]WHERE EMAIL = '$email'[/red] ";
Thanks,
sbayter
I'm creating a simple login page which goes into another page displaying the query for the user that logged in.
The problem is that it doesn't show anything and when i take out "[red]WHERE EMAIL = '$email'[/red]" it displays all the table in the DB and I only want it to show the row related to the email.
This is how the query looks like:
$email=$HTTP_POST_VARS['email'];
mysql_select_db($database_myConn, $myConn);
$query_myRs = "SELECT * FROM request [red]WHERE EMAIL = '$email'[/red] ";
Thanks,
sbayter