php $query help

[-__webdreamer__]

Well guys i finally made into php I never thought i would be posting here for help lol

Anyways here is my problem

I have created a user login system (flash+php+mysql)
And it just about works

Here's the prob when i go to register as a new user the code wont properly check to see if the username already exsist's in the DB, I am pretty sure the problem lies in my first $query

PHP:--------------------------------------------------------------------------------
$query = "SELECT name FROM contacts WHERE name='$name'";
if ($name == $name) {
print "loginT=UserName in Use";
}else{
$query = "INSERT INTO contacts (name, pass, email, id) VALUES ('$name', '$pass', '$email', NULL);";
}
$result = mysql_query($query);
// Gets the number of rows affected by the query as a check.
$numR = mysql_affected_rows($Connect);
if ($numR == 0) {
// Sends output to flash
print "loginT=Error - Register Again";
}
else if ($numR == 1) {
// Sends output to flash
print "loginT=Success&checklog=1";
}

---

If i take out
PHP:--------------------------------------------------------------------------------
$query = "SELECT name FROM contacts WHERE name='$name'";
if ($name == $name) {
print "loginT=UserName in Use";

---

THe login system works fine but dupilcate entries can be submitted to the database.

Please help i would love to get this up and running

Cheers

[Weedpacket]

$query = "SELECT name FROM contacts WHERE name='$name'";

What's missing here is anything that actually sends the query to the database, or looks at what gets returned.

if ($name == $name) {

This will always be true (since $name is always equal to itself).

If you're wanting to see if $POST['name'] (which is what you should be calling the submitted variable) is in the database:

$query = "SELECT count(name) FROM contacts WHERE name='$_POST[name]'";
$result=mysql_query($query);
$row = mysql_fetch_row($result);
$count = $row[0];
if($count!=0)
{ // found
}
else
{ // not found
}

[-__webdreamer__]

Cheers for replying m8, this is my first ever atempt @ something with php and mysql so please forgive if u see that i am missing somthing obviuos to u but am lost.

what did u jst say lol

cheers