{Solved}:How can i search a full field in 1 table...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mekha
Forum Contributor
Posts: 112
Joined: Sat Mar 31, 2012 6:50 am

{Solved}:How can i search a full field in 1 table...

Post by mekha »

How can i search a full field in 1 table...?
for example...
i want to search in all categories

<option value="????????">All categories</option>?

i search every category like this and success

Code: Select all

<?php
								mysql_query("SET NAMES 'utf8'");
							$result2 = mysql_query("SELECT Id as value,category_name as title FROM categories");
							while($row = mysql_fetch_assoc($result2)){
								extract($row);					
								?>
								<option value="<?=$value?>"><?=$title?></option>
								<?php
							}
							?>
<option value="????????">All categories</option>?
now how can i search all the Id's ? in 1 option (All categories)
Last edited by mekha on Fri Apr 27, 2012 7:37 am, edited 1 time in total.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How can i search a full field in 1 table...

Post by Celauran »

Searching all categories is the same as not specifying any category criteria in your WHERE clause.
mekha
Forum Contributor
Posts: 112
Joined: Sat Mar 31, 2012 6:50 am

Re: How can i search a full field in 1 table...

Post by mekha »

i didnt understand :\ ... how the query will be ?
mekha
Forum Contributor
Posts: 112
Joined: Sat Mar 31, 2012 6:50 am

Re: How can i search a full field in 1 table...

Post by mekha »

do you mean?

<?php
$sql4311=mysql_query("SELECT * FROM locations");
$resultall=mysql_fetch_assoc($sql4311);
?>

<option value="<?=$resultall['location_id']?>">كل المناطق</option>
mekha
Forum Contributor
Posts: 112
Joined: Sat Mar 31, 2012 6:50 am

Re: How can i search a full field in 1 table...

Post by mekha »

ok i solved it by myself..
i just added:
<option value=""></option>
value="empty"
Post Reply