Re: [PHP] re-order a sql result

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

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['

[PHP] re-order a sql result

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['sname']=" "; }