Affiliate Marketing
Forum Search

Reply
 
LinkBack Thread Tools Display Modes

  #1 (permalink)  
Old 15-03-06
Wardy's Avatar
This is the one
  
Join Date: Aug 2003
Posts: 2,747
Thanks: 14
Thanked 0 Times in 0 Posts
Wardy is an unknown quantity at this point
  Display range of answers - PHP & MYSQL
Just got a bit of a mental block on how to do somehting.
I want to search through a databse to display a range of possibilties.

eg, I want to display all toys that cost between £20 and £30.

SELECT * FROM toys WHERE type='$type' and cost='***THE PROBLEM CODE***'";

Anyone able to help me out as I'm in thicko mode

Cheers
Wardy
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 15-03-06
morleymouse's Avatar
Super Member
  
Join Date: Aug 2003
Location: Costa Del Sheffield
Posts: 2,752
Thanks: 3
Thanked 10 Times in 6 Posts
morleymouse is an unknown quantity at this point
AND cost >= 20 AND cost <= 30

or something like that...
__________________
Dan Morley
Alpharooms.com
daniel at alpharooms dot com - Hotels, Flights, Airport Transfers, Care Hire + More! sign up
My Blog | Cheap Holidays
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 15-03-06
Registered User
  
Join Date: Mar 2004
Location: Reading, UK
Posts: 301
Thanks: 0
Thanked 0 Times in 0 Posts
dmorison is an unknown quantity at this point
alternatively;

AND cost BETWEEN 20 AND 30
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
php scripts to display data from MySql accelerator Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 3 03-01-06 03:26 AM
storing variables in php mysql eskimo Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 8 16-12-05 02:43 AM
php / mysql / insert into... morleymouse Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 2 23-02-05 04:28 PM
Anyone anygood with xml, php, mysql and Affiliate Window AnnonnyMouse The Affiliate Marketing Lounge 1 23-09-04 11:00 AM
PHP & MYSQL Affiliates4u Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 8 13-01-03 09:12 PM


Affiliate Marketing RSS Feeds - Contact Us - Affiliate Marketing - Archive - Privacy Statement - Top

Content Relevant URLs by vBSEO 3.2.0 RC7