Looking for a function name

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

Post Reply
da9nlc
New php-forum User
New php-forum User
Posts: 21
Joined: Sun Feb 23, 2003 11:58 pm

Sun Mar 02, 2003 12:38 pm

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
DA CAMPBELL

pootergeist
New php-forum User
New php-forum User
Posts: 191
Joined: Wed Jan 29, 2003 7:11 am
Location: UK
Contact:

Mon Mar 03, 2003 7:47 am

$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
avatar image based upon nasas apod (only updates if I post though)

da9nlc
New php-forum User
New php-forum User
Posts: 21
Joined: Sun Feb 23, 2003 11:58 pm

Mon Mar 03, 2003 8:15 am

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
DA CAMPBELL

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 6 guests