Looking for a function name

A

Anonymous

Guest
I've searched php.net for 'RECORDSET' (as I know it in asp) to no avail so I guess that it comes under another term.

I have set $result = mysql_query(select * blah..) to search all and return rows as called by $searchterm.

What I am wanting to do is to be able to search the result of the above query to search for a range of items between two further variables.

Could someone help me by telling me what the terms are so that I could research them on php site such as php.net or even here.

Thanks
 
$getem = mysql_query("SELECT * FROM `t` WHERE a BETWEEN '$low' AND '$high'");

note: you should be looking on mysql.com - eg http://www.mysql.com/doc/en/Comparison_Operators.html
 
Yes I checked mysql.com it was my query syntax where the problem. Being used to mainly access(sorry didnt mean to swear) I was busy trying to mess about with <> rather than thinking more literal.

But I sorted the problem the other day and the query is producing the results as I want.

Thanks
 
Back
Top