Won't the same name two times

raschidt

Before my clients insert your comercial name, I need check if the comercial name are used. Then I do:

$sql = mysql_query("SELECT * FROM Comercials WHERE cTitle='".mysql_escape_string($title)."' ")

//$sql = mysql_query("SELECT * FROM Comercials WHERE cTitle='$title' ")
or die(mysql_error());
$row = mysql_fetch_array($sql);

$temp = "".$row["cTitle"]."";

if ($temp == $title) {
echo "that Comercial Name: ".$title." is already taken -go back and chose another one.";

} else {
insert here
}

But when somebody insert some like Ben's Beans the script don't work.

How can I chek for used names like A'haha.. with ' or specials characters?

thanks.

abnfire

i recommend to use regular experssion for doing that.
functions in regular expersions are:
eregi()
eregI_match()

and lot more...
research on php.net or in this forum.

diego25

The reason it won't work is because the company name has a single quote, which conflits with the single quotes around $title in the SQL query. Check out mysql_escape_string to solve the problem.

Diego

raschidt

Well I have not the answer!

I change my sentence, bacause I want print the sql, then now I'm using
$title2= htmlspecialchars($title);

$sql ="SELECT * FROM Comercials WHERE cTitle='$title2'";
echo "sql ",$sql," ";
echo "title2 ",$title2," ";
echo "title ",$title," ";
//$row = mysql_fetch_array($sql);

$temp = "".$row["cTitle"]."";

if ($temp == $title2) {
echo "that Comercial Name: ".$title." is already taken -go back and chose another one.";
}
insert
}

It don't work!

then I try:

$title3= mysql_escape_string($title);

$sql ="SELECT * FROM Comercials WHERE cTitle='$title3'";
echo "sql ",$sql," ";
echo "title3 ",$title3," ";
echo "title ",$title," ";
//$row = mysql_fetch_array($sql);

$temp = "".$row["cTitle"]."";

if ($temp == $title3) {
echo "that Comercial Name: ".$title." is already taken -go back and chose another one.";
}
insert
}

But it don't work.

The print is:
sql SELECT * FROM Comercials WHERE cTitle='She\\'s thing'
title2 She\'s thing
title3 She\\'s thing
title She\'s thing

Somebody know how to made that.

I don't want my clients can put two equal titles.
But wen they put things with ' my sentence don't work.

Things like she's house can put in my db any times, and I won't that.

Help please!
😕 😕 😕

note: My server has Magic quotes =On