Re: [PHP] re-order a sql result

2005-07-18 Thread Mikey
Mikey wrote: Ross wrote: I have a query $query = "SELECT * FROM sheet1 WHERE '$filter' LIKE '$search_field%'" This prints out a table while ($row = @mysql_fetch_array($result, MYSQL_ASSOC)){ // this just fills the empty cells if ($row['fname']==""){ $row['fname']=" "; } if ($row['sname

Re: [PHP] re-order a sql result

2005-07-18 Thread Mikey
Ross wrote: I have a query $query = "SELECT * FROM sheet1 WHERE '$filter' LIKE '$search_field%'" This prints out a table while ($row = @mysql_fetch_array($result, MYSQL_ASSOC)){ // this just fills the empty cells if ($row['fname']==""){ $row['fname']=" "; } if ($row['sname']==""){ $row['