RE: [PHP] i need some help with extracting data from mysql desperately!!

2001-05-10 Thread Sandeep Hundal
need some help with extracting data from mysql desperately!! unfortunately, that doesn't seem to work either. it basically only gives me on name per group. here's my php: $query = "SELECT * FROM $tablename WHERE approved='yes' GROUP BY group ORDER BY group, name"

[PHP] i need some help with extracting data from mysql desperately!!

2001-05-10 Thread Sandeep Hundal
unfortunately, that doesn't seem to work either. it basically only gives me on name per group. here's my php: $query = "SELECT * FROM $tablename WHERE approved='yes' GROUP BY group ORDER BY group, name"; $result2 = mysql_query($query2); if ($result2) { while ($r2 = mysql_fetch_array($result