Sorting data

[Anon]

Hi, after looking for about 30 minutes through this site I haven't quite found the answer to my questions.

I have a review system in place. Right now there's 3 pages total. The first page is a form where users fill in fields to submit their review. The form action points to a php page that then inserts the data into a mySQL db and also displays what they just entered.

Form page:
http://www.calstudents.com/reviews/submit.html

PHP Submit page source:
http://www.calstudents.com/reviews/submit.phps

The 3rd page lists ALL the contents of the db in a nice page:
http://www.calstudents.com/reviews/list.php
Source for it is here:
http://www.calstudents.com/reviews/list.phps

What I'd like to do is allow the user to get just the information they need out of the list page. I made a page that contains a form where the user can select the info they want. Located here:

http://www.calstudents.com/reviews/search.html

My question is, how do I modify the list.php page to accept the query from my search form. Should I make a new list page just for this or what? I'm new to PHP so most of the code on my pages have been taken from examples on this site so I don't fully understand all of it. I tried modifying the mySQL query to this:

SELECT * FROM reviews WHERE school LIKE '$school' AND course_title LIKE '%$course_title' AND course_number LIKE'%$course_number AND prof_name LIKE '%$prof_name' ORDER by timestamp limit $offset,$limit

But it doesn't work. Thanks for any help.

[sarahk]

Hi

I haven't got time to check out all your pages but if you had a sort by option on your page you could construct your query as:

$sqlstr = "SELECT * FROM reviews WHERE school LIKE '$school' AND course_title LIKE '%$course_title' AND course_number LIKE '%$course_number' AND prof_name LIKE '%$prof_name' ORDER by $sortorder limit $offset,$limit ";

[Anon]

I tried that exact string, but it doesn't seem to work. On my list page, I have 3 locations where I see a mySQL query string and I'm not sure which one is supposed to use it. I'll paste the relevant source below:

$numresults=mysql_query("SELECT * FROM reviews ORDER BY timestamp ASC");

$numrows=mysql_num_rows($numresults);

$sql = "SELECT FROM reviews ORDER BY timestamp ASC limit $offset,$limit ";

$result = mysql_query("select ".
"from reviews".
" order by timestamp limit $offset,$limit") or die("Could not execute query.");

while ($row = mysql_fetch_array($result)) {

I know I'm very close to getting it because I tried the same query you did, but apparently I placed it in the wrong location or something.