Hey all,
i have a database that includes a table in which one of the fields is numerical and i need to do a search for a RANGE of these values and then return all the fields of that table to a webpage.
the search page submits the range the user wants to find.
I'm thinkin of using an sql statement like
$sql="SELECT * FROM table"
and then use the mysql_fetch_array() function to get the entire list and use a conditional statement to try and get the range i want
firstly:
would this work?
secondly:
is there a simpler method i cant see or dont know of?
Thanx in advanced
i have a database that includes a table in which one of the fields is numerical and i need to do a search for a RANGE of these values and then return all the fields of that table to a webpage.
the search page submits the range the user wants to find.
I'm thinkin of using an sql statement like
$sql="SELECT * FROM table"
and then use the mysql_fetch_array() function to get the entire list and use a conditional statement to try and get the range i want
firstly:
would this work?
secondly:
is there a simpler method i cant see or dont know of?
Thanx in advanced