No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi. I tried looking for this problem on Google, and found a lot, but nothing that actually seems to work. I basically have a search script that works fine when using one keyword, but when one uses more than that, it returns every single row per keyword. So a search … |
|
Hey. I've got this code, [CODE] // query article $query1 = "SELECT * FROM (articles LEFT JOIN authorisation ON articles.page_id = authorisation.page_id LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE articles.page_id NOT IN (authorisation.page_id) ORDER BY issue ASC"; $mysql_result1 = mysql_query ($query1) or die ("Query '$query1' failed with error message: … |
|
I'll start by publishing my code: [CODE]// query article $query1 = "SELECT page_title,author_id FROM articles WHERE category = 'fiction'"; $mysql_result1 = mysql_query ($query1) or die ("Query '$query1' failed with error message: \"" . mysql_error () . '"'); $fiction_articles = mysql_fetch_assoc($mysql_result1); // query author $auth_result = &$fiction_articles['author_id']; $query2 = "SELECT author … |