Help duplicate name query

jd57

Hi
Can someone please tell me what is wrong with this code?
The code below is to avoid duplicate names. On my form the field name is “Bloom Name” and should be checked with the my database field “Bloom_Name” but I’m getting the following error. "Couldn't execute query."

<?php
$connection = mysql_connect(xxxxxxxx,xxx_xx,xxxx) or die ("Couldn't connect to server."); 
$db = mysql_select_db(xxx_xxx, $connection) or die ("Couldn't select database."); 
$sql = "SELECT Bloom_Name FROM ihsreg WHERE name='$fname'"; 
$result = mysql_query($sql) or die("Couldn't execute query."); 
$num = mysql_numrows($result); 
if ($num > 0) 
      { 
        $message_new = "$fname already Registered. Select another Name."; 
        echo $message_new; 
      } 
else 
  mysql_close($connection);
?>

Houdini

Add this to your die statement;

$result = mysql_query($sql) or die("Couldn't execute query. ". mysql_error());

Then you might get an idea what is causing the problem becuase the actual query looks OK.

jd57

After I added your code, I got the following error,

"Couldn't execute query. Unknown column 'name' in 'where clause'"

I'm a bit confuse, I'm not sure if this code is corect

$sql = "SELECT Bloom_Name FROM ihsreg WHERE name='Bloom Name'";

the field on my form is Bloom Name and on my table ihsreg the field name is Bloom_Name.

Can you please explain the error I made.

Megahertza

check that there is a column called "name". Maybe a speeling mistake. Its saying that it can't find a column called 'name' in that table.

jd57

Hi
Thank you so much for your help, it's working fine.
One more thing, how can I make the message to a larger font and in red.
Regards JD

<?php 
$connection = mysql_connect(xxxx,xxx_xx,jxxx) or die ("Couldn't connect to server."); 
$db = mysql_select_db(xxx_xx, $connection) or die ("Couldn't select database."); 
$sql = "SELECT Bloom_Name FROM ihsreg WHERE Bloom_Name = '$BloomName'"; 
$result = mysql_query($sql) or die("Couldn't execute query. ". mysql_error());$num = mysql_numrows($result); 
if ($num > 0) 
      { 
        $name_exist = "$BloomName BLA BLA. Select another Name."; 
        echo $name_exist; 
      } 
else
        $name_ok = "$BloomName is not BLA BLA . You may use this Name."; 
        echo $name_ok; 
  mysql_close($connection); 
?>

Houdini

This is assuming the the 'field' (column name) is BLOOM_NAME and that you are sending avariable $BLOOM NAME from a form or some other means in the query, so try this:

$sql = "SELECT BLOOM_NAME FROM ihsreg WHERE BLOOM_NAME ='$BLOOM NAME'";

Sorry you already found the error and I was close but no cigar in my suggestion but for the red and larger just do this.

$name_exist = "<font color=red size=14>$BloomName BLA BLA. Select another Name.</font>";

jd57

I want to close mysql connection if name exist. what's wrong with this code

$connection  = mysql_connect("xxxx","xxxx_xx","xxxx");
mysql_select_db("wayne_reg",$connection);
$sql = "SELECT Bloom_Name FROM ihsreg WHERE Bloom_Name = '$BloomName'"; 
$result = mysql_query($sql) or die("Couldn't execute query. ". mysql_error());$num = mysql_numrows($result); 
if ($num > 0) 
      { 
        $name_exist = "$BloomName already Registered. Select another Name."; 
        echo $name_exist;
mysql_close($connection); 
      } 
else
	 $name_ok = "$BloomName is not a Registered. You may use this Name."; 
        echo $name_ok;
		$query="insert into ihsreg

bradgrafelman

At first glane, there's nothing wrong with it. What is happening or not happening that makes you think something is wrong with it?