results display question

[slashpine]

hope someone will help a non-coder (just a hack)

 

The following displays the results from a db query...I have two questions....

echo '  <td>'.$row['id'].'</td>'; 
  echo '  <td>'.$row['name'].'</td>';
  echo '  <td>'.$row['address'].'</td>'; 
  echo '  <td>'.$row['city'].'</td>';
  echo '  <td>'.$row['state'].'</td>'; 
  echo '  <td>'.$row['zip'].'</td>';

1.) how can I make the results display in a table where I can put a heading at the top each column?

 

2.) how difficult would it be to be able to sort the columns by the "heading" (column name)

 

Thanks...

[AV1611]

You create the <table> tag and the first row before the query then put the query then close it after the query

[slashpine]

and the first row

 

can you explain this a little further?

[slashpine]

ok I got the first part...can anyone help me or show me an example on how to make the columns sortable by column heading?

[MadTechie]

On the titles your need a link ie

<a href="?Sort=Name">Name</a>

<a href="?Sort=City">City</a>

 

then on the SQL statment your need yo have ORDER BY $_GET['Sort']

ie

$query = "SELECT * FROM table ORDER BY ".$_GET['Sort'];