PHP easy help please

[perezf]

this should be simple
i just wanted to know what was wrong for the following code

[code]<?php
//replace username and password with your mysql name and password
$conn = mysql_connect("*******","*****","*****");

//select the database
$db = mysql_select_db("*******");

$username = $_POST["username"];
$password = $_POST["password"];
$email = $_POST["email"];

$result = MYSQL_QUERY("SELECT * from registration WHERE username='$username' and password='$password'")
  or die ("Name and password not found or not matched");

$worked = mysql_fetch_array($result);

$username = $worked[username];
$password = $worked[password];
$email = $worked[email];

if($worked){
echo "<a href=\"#\" class=\"menu\">Home</a>-
<a href=\"#\" class=\"menu\">Learn HTML</a>-
<a href=\"#\" class=\"menu\">Learn CSS</a>-
<a href=\"#\" class=\"menu\">Learn PHP</a>-
<a href=\"#\" class=\"menu\">About Us</a>-
<a href=\"#\" class=\"menu\">FAQ's</a>";}

else{
echo "<a href=\"#\" class=\"menu\">Home</a>-
<a href=\"register.php\" class=\"menu\">Register</a>-
<a href=\"login.php\" class=\"menu\">Login In</a>-
<a href=\"#\" class=\"menu\">About Us</a>-
<a href=\"#\" class=\"menu\">FAQ's</a>";}
?>[/code]

[king arthur]

And the error you are getting is?

[perezf]

when the user is logged in i want a specific menu to appear
but when they are not logged in i want another menu to appear

but even when i logg in the same menu is always showing
which is the one which is not logged in

[perezf]

[code]if($worked){
echo "<a href=\"#\" class=\"menu\">Home</a>-
<a href=\"#\" class=\"menu\">Learn HTML</a>-
<a href=\"#\" class=\"menu\">Learn CSS</a>-
<a href=\"#\" class=\"menu\">Learn PHP</a>-
<a href=\"#\" class=\"menu\">About Us</a>-
<a href=\"#\" class=\"menu\">FAQ's</a>";}

else{
echo "<a href=\"#\" class=\"menu\">Home</a>-
<a href=\"register.php\" class=\"menu\">Register</a>-
<a href=\"login.php\" class=\"menu\">Login In</a>-
<a href=\"#\" class=\"menu\">About Us</a>-
<a href=\"#\" class=\"menu\">FAQ's</a>";[/code]

this is the part that is not working

[king arthur]

The problem is with your logic here
[code]
$result = MYSQL_QUERY("SELECT * from registration WHERE username='$username' and password='$password'")
  or die ("Name and password not found or not matched");

$worked = mysql_fetch_array($result);
[/code]

The query would only fail if there was an error, not if the matching name and password were not found.  The query might easily work but not return any matched rows. So you need to count how many rows were returned, if it was none then the username and password have no match.

[code]
$result = MYSQL_QUERY("SELECT * from registration WHERE username='$username' and password='$password'")
  or die ("Name and password not found or not matched");

$numofrows = mysql_num_rows($result);

$worked = mysql_fetch_array($result);

if($numofrows == 0)
{
    // no match found
}
[/code]

[perezf]

it worked
thank you so much