Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

Looking for a function name

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

Looking for a function name

Postby da9nlc » 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
da9nlc
New php-forum User
New php-forum User
 
Posts: 21
Joined: Sun Feb 23, 2003 11:58 pm

Postby pootergeist » 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
pootergeist
New php-forum User
New php-forum User
 
Posts: 191
Joined: Wed Jan 29, 2003 7:11 am
Location: UK

Thanx

Postby da9nlc » 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
da9nlc
New php-forum User
New php-forum User
 
Posts: 21
Joined: Sun Feb 23, 2003 11:58 pm


Return to PHP coding => General

Who is online

Users browsing this forum: Google Feedfetcher and 4 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.