I need help with &quot;Sort By&quot;

I need help with "Sort By"

mband2000

I'm creating a student database and I need some help with sorting.

Ok... I've created a php form ... that inputs info into MySQL ... now that the info is in the database I would like to make a seperate page that sorts the entered data by state.

For example... if I have a link on that page that says... "Show all members that are from Georgia"

^How can I make it where it only shows the info from the people that live in Georgia.

I've already created the tables... so what should I do next?

jpmoriarty

select * from table where state="georgia"

mband2000

^{^Thanks!}

mband2000

Ok I just tried it but I got this error....

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/showtime/public_html/Database/test.php3 on line 37

Here is the code I used.. can someone tell me where I went wrong.

<html>
<body>

<?php

$db = mysql_connect("localhost", "****", "****");

mysql_select_db("showtime_student",$db);

$result = mysql_query("SELECT * FROM HS WHERE state=Georgia",$db);

echo "<table border=1>\n";

echo "<tr><td>Name</td><td>Email</td><td>Instrument</td><td>Class of</tr>\n";

while ($myrow = mysql_fetch_row($result)) {

	printf("<tr><td>%s %s</td><td>%s</td><td>%s</td><td>%s</tr>\n",
	$myrow[1], $myrow[2], $myrow[4], $myrow[5], $myrow[6]);


}


echo "</table>\n";

?>


</body>

</html>

cgraz

try

$result = mysql_query("SELECT * FROM HS WHERE state='Georgia'") or die(mysql_error());

I added the single quotes, and you don't need the ,$db

Cgraz

mband2000

Thanks to the both of you.

It works great🙂