& Symbol with PHP

[a1amattyj]

Hello,

 

Im getting a name from the url, for instance,

 

index.php?name=C.-and-G

 

The "and" is then converted to a & symbol and dashes converted to spaces.

 

This then uses the new name "C. & G" to select a record from mysql. However, it does not recognise the & symbol, the name in mysql is "C. & G" but returns 0 records.

 

Any ideas? Thanks!

[Adam]

I imagine you don't quite have the expected value for "C. & G" you think. What does a var_dump on the variable return?

[a1amattyj]

C. & G

 

Query produced:

 

SELECT * FROM `businesses` WHERE `company` = 'C. & G' LIMIT 1

 

In PHP, this returns 0 rows.

 

In phpMyAdmin, returns 1 row.

[Adam]

How are you determining the rows returned, could you show the code?

[a1amattyj]

$query = mysql_query("
SELECT * FROM `businesses` 
WHERE `company` = '".clean_up(nice_business_name_back($_GET['id']))."'
LIMIT 1") or die(mysql_error());

if(mysql_num_rows($query) != 1)
{
$smarty->display('header.tpl');
$smarty->display('business.not.found.tpl');
$smarty->display('footer.tpl');
exit;
}

 

 

clean_up(nice_business_name_back($_GET['id']

 

Produces: C. & G

 

[rwwd]

index.php?name=C.-and-G

 

should be:

 

index.php?name=C&G

 

when in the anchor ref '&' will NOT validate but '&' will and this makes the url more friendly too

 

Rw

[a1amattyj]

Hi,

 

When I do this, the '&' in the url cuts off the rest of the request and therefore misses the final few letters.

 

index.php?name=C.-and-G

 

should be:

 

index.php?name=C&G

 

when in the anchor ref '&' will NOT validate but '&' will and this makes the url more friendly too

 

Rw