Hi, I'm trying to take a list of 1300 events and merge the ones that repeat monday, wednesday, friday or on other days. What's the best way to do this? The $result set and ends up repeating over rows after they're matched! Is there an easy way to write this in a query alone?
Thanks for any help!
1, alpha, monday, 8pm
2, alpha, tuesday, 8pm
3, beta, monday, 12pm
4, alpha, friday, 8pm
$m_id = array();
$result = db_query("SELECT * FROM meetings_import_merge ORDER BY title, id ASC");
while($data = db_fetch_object($result))
{
$m_days = array($data->day);
$result_m = db_query("SELECT * FROM meetings_import_merge WHERE id!='%s' AND title='%s' AND location='%s' AND time='%s'", $data->id, $data->title, $data->location, $data->time);
while($data_m = db_fetch_object($result_m))
{
$m_id[] = $data_m->id;
$m_days[] = $data_m->day;
}
if(count($m_days))
{
db_query("UPDATE meetings_import_merge SET days='%s' WHERE id='%s'", implode(',', $m_days), $data->id );
}
}
db_query("DELETE FROM meetings_import_merge WHERE id IN (%s)", implode(',', $m_id) );
before: 1300, after 800 rows
