think this is wrong ... as it gives unique alias even if the query is not
executed ..


rajesh


On Sun, 2 Oct 2005, Bastien Koert wrote:

you need to check the num of rows returned, since the query always(if it works) returns true


$result = mysql_query($query);
if (($result)&&(mysql_num_rows($result)==1))

{

echo "Alias already in use";

} else {

echo "Unique alias";

mysql_close();

}



Bastien


From: "Ron Piggott" <[EMAIL PROTECTED]>
Reply-To: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB" <php-db@lists.php.net>
Subject: [PHP-DB] If syntax
Date: Sat, 1 Oct 2005 22:28:46 -0500

Take a look at my if ( ) syntax line below.  I am wondering if I have it
wrong in same way.  What I am trying to achieve is if the alias the user
enters is already found in the database I want the words "Alias already in
use" to be shown on the screen; otherwise "Unique alias" to be shown on the
screen.

PRESENTLY alias already in use is what comes up all the time.

Ron


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename WHERE alias LIKE '$alias%'";

if (mysql_query($query))

{

echo "Alias already in use";

} else {

echo "Unique alias";

mysql_close();

}

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




--
*********************************************************************************************

        You wouldn't know an OS if it hit you in the face ...

                                                Linux Baby !

*********************************************************************************************

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

Reply via email to