ctcp Posted June 30, 2009 Share Posted June 30, 2009 $results = mysql_query("SELECT * FROM crackz WHERE `option` = 'yes' and `type` = '$type' and name LIKE '%". $query ."%' ORDER BY date DESC LIMIT $page, $limit"); i got this for my search form .. type = games or movies.. how to search ... all now movies and games together? type = $type or ???? thanks for help.. Quote Link to comment https://forums.phpfreaks.com/topic/164175-php-select/ Share on other sites More sharing options...
.josh Posted June 30, 2009 Share Posted June 30, 2009 I have no Idea what you just said...but...<sniff> I feel you man. I wish you the best of luck on this epic quest of yours. Hey, I just noticed, your post looks like a giant gun. Like Megatron's gun. Or the joker in the first batman movie where Jack Nickleson was the joker, and he shot down batman's plane with that long ass gun. BLAMBLAMBLAM! pow. Quote Link to comment https://forums.phpfreaks.com/topic/164175-php-select/#findComment-866048 Share on other sites More sharing options...
joel24 Posted June 30, 2009 Share Posted June 30, 2009 if you want both have type = "$type1" or type="$type2" Quote Link to comment https://forums.phpfreaks.com/topic/164175-php-select/#findComment-866070 Share on other sites More sharing options...
ctcp Posted June 30, 2009 Author Share Posted June 30, 2009 i got form multi search .. All=all Games=Games Music=music how to search all ..(music and games) $results = mysql_query("SELECT * FROM crackz WHERE `option` = 'yes' and `type` = '$type' and name LIKE '%". $query ."%' ORDER BY date DESC LIMIT $page, $limit"); Quote Link to comment https://forums.phpfreaks.com/topic/164175-php-select/#findComment-866214 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.