rberbe2002

$domains_sql = mysql_query("SELECT domains_id, domains_url, keywords_id, keywords_word, domains_comments_comment FROM ( SELECT domains_id,domains_url FROM domains ORDER BY RAND() LIMIT 1 ) as d INNER JOIN domains_comments ON domains_comments_domain = domains_id INNER JOIN domains_keywords ON domains_keywords_website = domains_id INNER JOIN keywords ON domains_keywords_keyword = keywords_id ORDER BY keywords_word ASC") or die (mysql_error()); $num = mysql_num_rows($domains_sql); $current_price = ""; for($i=0;$i<$num;$i++){ $domains_result = mysql_fetch_array($domains_sql); $domains_id = $domains_result['domains_id']; $domains_url = $domains_result['domains_url']; $domains_name = preg_replace('#^https?://www.#', '', $domains_url); $keywords_id = $domains_result['keywords_id']; $keywords_word = $domains_result['keywords_word']; $domains_comments = $domains_result['domains_comments_comment']; if($domains_url != $current_price) { echo $domains_name."<br /><br />"; $current_price = $domains_url; } echo $keywords_word."<br />"; echo $domains_comments."<br />"; } prints out: MS Office domain 1 MS Office domain 1 - part 1 MySQL domain 1 MySQL domain 1 - part 1 PHP domain 1 PHP domain 1 - part 1 Visual Basic domain 1 Visual Basic domain 1 - part 1 and i need it to be: (info from keywords) MS Office MySQL PHP Visual Basic (info from comments) domain 1 domain 1 - part 1