[SOLVED] probably more sql than PHP but here's the problem...

[rhock_95]

 $sql="select * from table  where name='$name' and title='$query'  ORDER BY name";

 

My problem is the above query works fine unless the data in the "title" column has an "&" in the text...then the script does not display any results...is there a way to correct this with the query or do I have to change the records?

 

TIA

[teng84]

sample data ? so we can build a query for yahh

[darkfreaks]

$title= mysql_real_escape_string($title);
$title= strip_tags($title);

 

make sure to safely remove special characters from being entered

[rhock_95]

Not sure that would work because the & is actually in the title (data) as part of the record.

 

This particular script runs inside the results of a parent script... it allows the user to display all the names with the same "title"...

 

...the parent script originally returns all the names and titles

[darkfreaks]

$sql="select * from table  where name='$name' & title='$query'  ORDER BY name";

[teng84]

if you dont want the exact value the  use " like "

 

well im confuzed on what your trying to do but you can remove the & trough sql then after removing the & compare it..

[rhock_95]

you lost me now...can you show me an example of using LIKE with the query  posted?

[revraz]

You can use LIKE, for example, LIKE 'Hi%' and that will get every word that starts with Hi

[teng84]

show titles samples... and your title your trying to compare

[rhock_95]

I got it... LIKE '%title%'  works like a charm...

 

Thanks for the help...