Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: gruskoff20040319

Message # 1031381:
Date: 11/06/05 08:59
By: Devendra Singh Sengar
Subject: How to select multiple valve from the dropdow

how to select multiple valve from the dropdown program in PHP.for eg- thats the question:-
This is the drop down:-
<select name="dept[]" MULTIPLE size="1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="other">other</option>
</select>
This is SQL query:-
if($dept==other){
SELECT name from aa WHERE dept NOT LIKE '1%'
AND dept NOT LIKE '2%'
AND dept NOT LIKE '3%'
AND dept NOT LIKE '4%'

}
else{
SELECT name from aa WHERE dept LIKE '".$dept."%'
}
whats improvement i have to do in the query so that i get the correct result.

Previous Message | Next Message


Comments:
How to select multiple valve from the dropdowDevendra Singh Sengar11/06/05 08:59
I understood clearlyArunmohan07/29/05 20:54
more usefull functionsEd van den Berg07/29/05 17:39
very confusinghabeeb12/06/04 15:44
very confusinghabeeb12/06/04 15:44
RE: Not clear Jobin Augustine08/09/04 07:13
RE: Not clear Jobin Augustine08/09/04 05:08
Not clear Francesco05/10/04 06:58
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.