sort results by another column

[rhock_95]

A script lets users search a database for 'last name' and displays those results

 

what is the simplest way to let them sort those (further query) results by 'first name' ?

[aebstract]

When you search for results by first name, limit to only the ones that you grabbed when searched by last name.

[rhock_95]

what I am hoping to do is just reuse the original query and run a second query using the original $query (variable)

 

what I am seeking is the correct syntax

 

 $sql="select * from  my_table  where last='$query' and first LIKE '%$first%' ORDER BY first";

 

the above is not working

 

"$query is the original "last name" searched for

[sasa]

try

$sql="select * from  my_table  where last='$query' ORDER BY first";

[rhock_95]

thanks for the reply...but that does not allow the user to select a "first initial/name" etc...

[Ninjakreborn]

$sql="SELECT * FROM  my_table  where last='$query' AND first LIKE '%$first%' ORDER BY first";

Try that, post back the results.

[sasa]

i don't understund your problem

is user input full last name or just part of it

is user input somethin from first name

can you post some example what user input, and what script must return

[rhock_95]

i don't understund your problem

is user input full last name or just part of it

is user input somethin from first name

can you post some example what user input, and what script must return

 

The initial query posts (last)  last and returns the records that match the "$query"

 

what I'm trying to do is run a second query (from an integrated form $first) that when submitted sorts the initial results by a second column (first)...where the second query input can be just a single letter (first initial etc)...