stebuklas Posted October 21, 2006 Share Posted October 21, 2006 Hi, I'm trying to take all links from the file with this pattern: $pattern = "/<li class=\"first\">(.*)<\/li>/"; and then when I launch site they put an error: 'You have an error in your SQL syntax near 't get the results you expected?'Maybe someone can help me? what's wrong with it? Quote Link to comment Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 Nobody know? Quote Link to comment Share on other sites More sharing options...
LazyJones Posted October 22, 2006 Share Posted October 22, 2006 The problem is not in the pattern, it's somewhere else (SQL syntax maybe......) Quote Link to comment Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 [code]$pattern = "/<li class=\"first\">(.*)<\/li>/";preg_match_all($pattern, $fd, $matches); // ..............foreach($matches[1] as $num => $bu){ $new_link_insert = "INSERT INTO linkai (linkai) VALUES('$bu')"; mysql_query($new_link_insert,$db_connection) or die (mysql_error());}[/code]I think pattern :) But maybe is smth with SQL Quote Link to comment Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 btw... when I try to make output in window.. Then It puts all file, not a links what I need.... Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted October 22, 2006 Share Posted October 22, 2006 try going like this:[code=php:0]new_link_insert = "INSERT INTO linkai (linkai) VALUES('".addslashes($bu)."')";[/code]mysql dosnt like '. so when you add slashes words like don't become don\'t. I think this should solve your problem. Quote Link to comment Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 Thanks, it's working correctly, but... Like I sayed it not take all links from file, but he shows all file... I think you understand me... Quote Link to comment Share on other sites More sharing options...
stebuklas Posted October 23, 2006 Author Share Posted October 23, 2006 please, somebody help me :) Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted October 25, 2006 Share Posted October 25, 2006 whats exactly wrong with it now? it isnt grabbing all the links from the text file. well if it isnt doing that smething is wrong with your pattern. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.