rhock_95 Posted November 27, 2007 Share Posted November 27, 2007 $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 Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/ Share on other sites More sharing options...
teng84 Posted November 27, 2007 Share Posted November 27, 2007 sample data ? so we can build a query for yahh Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399972 Share on other sites More sharing options...
darkfreaks Posted November 27, 2007 Share Posted November 27, 2007 $title= mysql_real_escape_string($title); $title= strip_tags($title); make sure to safely remove special characters from being entered Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399973 Share on other sites More sharing options...
rhock_95 Posted November 27, 2007 Author Share Posted November 27, 2007 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 Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399978 Share on other sites More sharing options...
darkfreaks Posted November 27, 2007 Share Posted November 27, 2007 $sql="select * from table where name='$name' & title='$query' ORDER BY name"; Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399982 Share on other sites More sharing options...
teng84 Posted November 27, 2007 Share Posted November 27, 2007 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.. Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399985 Share on other sites More sharing options...
rhock_95 Posted November 27, 2007 Author Share Posted November 27, 2007 you lost me now...can you show me an example of using LIKE with the query posted? Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399988 Share on other sites More sharing options...
revraz Posted November 27, 2007 Share Posted November 27, 2007 You can use LIKE, for example, LIKE 'Hi%' and that will get every word that starts with Hi Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399995 Share on other sites More sharing options...
teng84 Posted November 27, 2007 Share Posted November 27, 2007 show titles samples... and your title your trying to compare Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399996 Share on other sites More sharing options...
rhock_95 Posted November 27, 2007 Author Share Posted November 27, 2007 I got it... LIKE '%title%' works like a charm... Thanks for the help... Link to comment https://forums.phpfreaks.com/topic/79036-solved-probably-more-sql-than-php-but-heres-the-problem/#findComment-399998 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.