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.. 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. 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" 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"); Link to comment https://forums.phpfreaks.com/topic/164175-php-select/#findComment-866214 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.