Re: [PHP] php $query help

[Leif K-Brooks]

What the heck is if($name == $name){ supposed to mean? I've never seen
a variable that's not equal to itself... :-)

- [ Paul Ferrie ] - wrote:

> 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
>
>
>
>
>

--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php