Mine
public text v1 · immutable $sql = "SELECT cat_id, cat_name FROM categories WHERE cat_parent_id < 1 ORDER BY cat_name";
$sql = mysql_query($sql) or die(mysql_error());
$categories = array();
while ($row = mysql_fetch_object($sql)) {
$categories[$row->cat_name] = $row->cat_id;
}
$sql = "SELECT MAX( image_id ), image_cat FROM images WHERE image_cat IN (".implode(',',$categories).")";
$sql = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($test_query)) {
var_dump($row);
}