Question
Posted: Sun Jul 27, 2003 5:01 pm
Code: Select all
$query = mysql_query("SELECT username FROM verify, username FROM account WHERE username='$username'");
$num = mysql_num_rows($query);Thanks,
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$query = mysql_query("SELECT username FROM verify, username FROM account WHERE username='$username'");
$num = mysql_num_rows($query);Code: Select all
$sql = "SELECT username FROM verify, username, account WHERE verify.username = '$username'";
$query = mysql_query($sql) or die(mysql_error().'<p>'.$sql.'</p>');Code: Select all
$query = mysql_query("SELECT username FROM verify, username FROM account WHERE username='$username'");
$num = mysql_num_rows($query);
if ($num > 0)
{
echo "<center><b>Error!</b> The username "$username" is already in use. Please try a differant one.";
form();
exit();
}Code: Select all
<?php
$result = mysql_query("SELECT a.* FROM `verify` as a, `account` as b WHERE a.username = '$username' AND b.username = '$username'") or die ("b0rked: ".mysql_error());
if (mysql_num_rows($result) >= 1) {
?>