MySQL query
Posted: Wed Dec 28, 2005 1:14 pm
Code: Select all
$query = "SELECT `name` FROM `users` WHERE product = 'ipod video 60gb'AND activated = '1' ORDER BY `order` ASC";Thanks
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$query = "SELECT `name` FROM `users` WHERE product = 'ipod video 60gb'AND activated = '1' ORDER BY `order` ASC";Code: Select all
$query = "SELECT `name` FROM `users` WHERE product = 'ipod video 60gb' AND (activated = '1' or activated = '2') ORDER BY `order` ASC";Code: Select all
$query = "SELECT `name` FROM `users` WHERE product = 'ipod video 60gb' AND activated in ('1','2') ORDER BY `order` ASC";