TalkPHP - View Single Post

delayedinsanity · 04-30-2008, 04:12 PM

SELECT field1, field2 FROM games WHERE price < 30
SELECT field1, field2 FROM games WHERE price BETWEEN 1 AND 30

unless you mean the PHP code

PHP Code:


			

switch ($_POST['amount']) {
     case "30": // build your query
     case "60": // build your query
     default: // SELECT *
}

is one method. You may want to check out php.net and look up "control structures".
-m

04-30-2008, 04:12 PM	#13 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	SELECT field1, field2 FROM games WHERE price < 30 SELECT field1, field2 FROM games WHERE price BETWEEN 1 AND 30 unless you mean the PHP code PHP Code: `switch ($_POST['amount']) { case "30": // build your query case "60": // build your query default: // SELECT * }` is one method. You may want to check out php.net and look up "control structures". -m