Looping & seperating data

[graham23s]

Hi Guys,

 

In a search query on my site i have the basic code setup like this:

 

<?php
   $s = mysql_query("SELECT * FROM `cpa` WHERE `raw_search` LIKE '%$search%' ORDER BY `raw_search` DESC");
   
   while ($r = mysql_fetch_array($s))
   {
   
     print $r['link'] . "<br />";
    
   }
?>

 

This prints all the search data in a row, the only thing that groups the data together is the time stamp it was inserted in to the database with.

 

search1 (timestamp1)

search1 (timestamp1)

search2 (timestamp2)

search2 (timestamp2)

search2 (timestamp2)

 

what i am trying to do is put a <hr> under the last result to seperate them up a bit on page like:

 

search1 (timestamp1)

search1 (timestamp1)

_________________

search2 (timestamp2)

search2 (timestamp2)

search2 (timestamp2)

 

i can't think of way to do it, any help would  be appreciated.

 

thanks guys

 

Graham

[Catfish]

have a look in SQL manual at 'GROUP BY'.

[JAY6390]

Can you give an example of a couple of the rows output?

Also, do the search queries all have single words or multiple words?

[graham23s]

Hi Guys

 

The output would be like:

 

site1.com/page1 added on 2010-01-31 23:17:53

site1.com/page2 added on 2010-01-31 23:17:53

site2.com/page1 added on 2010-01-31 23:17:56

site2.com/page2 added on 2010-01-31 23:17:56

site2.com/page3 added on 2010-01-31 23:17:56

 

they output one after each other, to make them a little better i was trying to seperate them like:

 

site1.com/page1 added on 2010-01-31 23:17:53

site1.com/page2 added on 2010-01-31 23:17:53

-------------------------------------------------------------- <- seperator

site2.com/page1 added on 2010-01-31 23:17:56

site2.com/page2 added on 2010-01-31 23:17:56

site2.com/page3 added on 2010-01-31 23:17:56

 

thanks guys

 

Graham

[JAY6390]

<?php

$s = mysql_query("SELECT * FROM `cpa` WHERE `raw_search` LIKE '%$search%' ORDER BY `raw_search` DESC");

$last_timestamp = '';
while ($r = mysql_fetch_array($s)) {

print $r['link']."<br />";
    preg_match('added on \K.*',$r['link'], $out);
    if($out[0] != $last_timestamp && $last_timestamp != '')
        echo '<hr />';
    $last_timestamp = $out[0];

}

?>

Try that