checking database for an existing subdomain name...

phil

Hello Everybody,

I want to compare the content of an input field in
a page if an identical entry already exists in the table cm_users in my database, to avoid multiple entries in the case of users requesting their own subdomain, i.e.: www.phil.philiplynch.de.

All works fine sofar until I get a parse error on line 22 with the echo part. There must be somthing I am missing. Can anybody help...?

Kind Regards from Frankfurt
Philip

<?
//Modus subdomain
if ($mode == subdomain) {
require("./mysqlCall.php");

$link_identifier = mysql_connect($hostname,$username,$passwd);
if ($link_identifier<=0)
{
echo mysql_errno().": ".mysql_error()." ";
exit;
}
$SQLStatement =
"SELECT * FROM cm_users where subdomain like '$subdomain';

// echo $SQLStatement;

$result = mysql_query($SQLStatement,$link_identifier);

if (mysql_num_rows($result) > 0)
{
echo "The desired subdomain name is already being used - please try different subdomain name. \n";

else

echo "The desired subdomain name is still available. \n";
}

mysql_close($link_identifier);

wizkid

Hi,

try following:

//Modus subdomain 
if ($mode == subdomain) { 
require("./mysqlCall.php"); 

$link_identifier = mysql_connect($hostname,$username,$passwd); 
if ($link_identifier<=0) 
{ 
echo mysql_errno().": ".mysql_error()."<br>"; 
exit; 
} 
$SQLStatement = "SELECT * FROM cm_users where subdomain like '$subdomain'"; 

// echo $SQLStatement; 

$result = mysql_query($SQLStatement,$link_identifier); 


if (mysql_num_rows($result) > 0) 
{ 
echo "The desired subdomain name is already being used - please try different subdomain name.<br><br>\n"; 
}
else 
{
echo "The desired subdomain name is still available.<br><br>\n"; 
} 

mysql_close($link_identifier); 
}

wizkid

phil

Thank You WIZJID, for your help.

You did help me getting started to find a few more errors. Now that I have succeeded in avoiding all the sstem error messages, all I need is to get the actual data output right.

With the script below, I still get a positive response (i.e. response says subdomain name is available although it actually exists in the table).

Where am I going wrong now...?

Kind Regards
Philip

<?
//Modus subdomain
if ($mode == subdomain) {
//require("./mysqlCall.php");
include("connect.php");

$link_identifier = mysql_connect($hostname,$username,$passwd);
if ($link_identifier<=0)
{
echo mysql_errno().": ".mysql_error()." ";
exit;
}

// $subdomain = $subdomain."%";
// $name = $name."%";
// $nummer = $nummer."%";

$SQLStatement =
"select ID, subdomain from cm_users where subdomain == '$subdomain'
order by ID";

$result = mysql_query($SQLStatement,$link_identifier);

echo $result;

$num_rows = $result;

echo $num_rows;

if ($num_rows >1)
{
echo "The desired subdomain name is already being used - please try different subdomain name. \n";
}

// else

if ($num_rows <=1)
{
echo "The desired subdomain name is still available. \n";
}

mysql_close($link_identifier);
}

wizkid

Hi,

try following:

<? 
//Modus subdomain 
if ($mode == subdomain) { 
//require("./mysqlCall.php"); 
include("connect.php"); 

$link_identifier = mysql_connect($hostname,$username,$passwd); 
if ($link_identifier === FALSE) 
{ 
echo mysql_errno().": ".mysql_error()."<br>"; 
exit; 
} 

// $subdomain = $subdomain."%"; 
// $name = $name."%"; 
// $nummer = $nummer."%"; 

$SQLStatement = 
"select ID, subdomain from cm_users where subdomain == '".addslashes($subdomain)."' 
order by ID"; 

$result = mysql_query($SQLStatement,$link_identifier); 

echo $result; 

$num_rows = @mysql_num_rows($result); 


echo $num_rows; 


if ($num_rows >= 1) 
{ 
echo "The desired subdomain name is already being used - please try different subdomain name.<br><br>\n"; 
} 

// else 

if ($num_rows == 0) 
{ 
echo "The desired subdomain name is still available.<br><br>\n"; 
} 

mysql_close($link_identifier); 
} 

?>

Greetings from Wiesbaden,
wizkid