stuieb

Many thanks to you all for your brill help. Stu.

Thanks, I'll try it but I must admit I'm a little confused with it. I'll keep you posted as to its progress. (I'm a little new to this, sorry!) Many thanks, Stu.

Wow, Thanks for that. You mentioned that that was one way. Is there another way? Many thanks in advance, Stu.

Hi, I have a search form on a page that has three select fields. make location price Each is dynamicly generated from information in the database. The form goes to a results page (GET) and displays the results. The problem I am having is with the MySQL SELECT on the results page. Basicly I want the user to be able to search for all records from 'make' from within the table, or all records from 'location' or all records from 'price' or by a combination of all three. Make, location and price are all cols in a table bye the way. MySQL Version 4.1 Please help! Stu.

Hi, I have a search form on a page that has three select fields. make location price Each is dynamicly generated from information in the database. The form gos to a results page (GET) and displays the results. The problem I am having is with the MySQL SELECT on the results page. Basicly I want the user to be able to search for all records from 'make' from within the table, or all records from 'location' or all records from 'price' or by a combination of all three. Make, location and price are all cols in a table bye the way. Please help! Stu.

Fantastic, Just the ticket. Many thanks. Stu.

Hi, I'm new here but really do need some help. I have a site that is PHP and MySQL and it has detail pages that are served via a url string like view_page.php?recordID=xxx. I want to insert an update comand on the page to count hits. I know the difference between hits and page views etc, but just need to count the number of times the page is loaded (by whatever means). I have the code as follows which can be used in a static page: mysql_query("UPDATE tabel set hits = hits+'1'"); but I can't figure out how to do a WHERE id=(url variable recordID) so that just that record in the database gets updated. Please help. Many thanks in advance, Stu.