 |  |  |  |  |  |  |  |
I have problem with two value search
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Dear All,
I have problem with two value search, Please kindly see my code below:
My problem is when I choose the location=All location is ok but when I choose both Values it doesn't select the right criteria that I wish.
I have problem with two value search, Please kindly see my code below:
php Syntax (Toggle Plain Text)
Last edited by cscgal; Sep 28th, 2008 at 1:29 am. Reason: Added code tags
Hey,
You've posted a huge code segment but not explained what it does or why it does it? Your description is rather vauge and I, for one, don't really want to dig through all that code looking for a problem I don't know about.
Chris
You've posted a huge code segment but not explained what it does or why it does it? Your description is rather vauge and I, for one, don't really want to dig through all that code looking for a problem I don't know about.
Chris
•
•
•
•
Originally Posted by heenix 
Hey,
You've posted a huge code segment but not explained what it does or why it does it? Your description is rather vauge and I, for one, don't really want to dig through all that code looking for a problem I don't know about.
Chris
My problem is that I can search only both values like All=location and All category is fine
But I if select Location=Phnom Penh and Category= Computer is not show me the right criteria.
Thank so much in advance for your million help.
Kindly regards,
Bunhok
Hey,
I've spotted a slight problem near the beginning of your script. The section where you loop to show the job categories writes the category ID and the category name into an option field. You have a default field named "All Categories" with the value of 0. However, in MySQL, I believe it may be possible to get an index of 0.. this would produce html like this:
I recommend you make the "All Categories" and "All Locations" values to -1, a number outside the range of what MySQL may return. This will stop any duplication problems. As I mentioned earlier, it's very difficult to read your code, so this next comment may be wildly off.
On line 33, you check to see if "All Categories" and "All Locations" has been selected and you have tailored an entire section querying the database for that, and in the corresponding else statement (Line 97), you've begun to show the HTML table code, but you've commented out everything else to do with the database from line 111 onwards?
I hope this helps,
Christopher Lord
I've spotted a slight problem near the beginning of your script. The section where you loop to show the job categories writes the category ID and the category name into an option field. You have a default field named "All Categories" with the value of 0. However, in MySQL, I believe it may be possible to get an index of 0.. this would produce html like this:
PHP Syntax (Toggle Plain Text)
I recommend you make the "All Categories" and "All Locations" values to -1, a number outside the range of what MySQL may return. This will stop any duplication problems. As I mentioned earlier, it's very difficult to read your code, so this next comment may be wildly off.
On line 33, you check to see if "All Categories" and "All Locations" has been selected and you have tailored an entire section querying the database for that, and in the corresponding else statement (Line 97), you've begun to show the HTML table code, but you've commented out everything else to do with the database from line 111 onwards?
I hope this helps,
Christopher Lord
|
Similar Threads
- Help and support and Msconfig won't open, Search disabled (Windows NT / 2000 / XP)
- Redirect/Jump problem (Viruses, Spyware and other Nasties)
- IE Explorer/Search Engine problems! (fake/redirect search results;dysfunctional sites (Viruses, Spyware and other Nasties)
- Linked list search problems (Computer Science)
- Search Assistant problem won't go away (Viruses, Spyware and other Nasties)
- Dell dimension 3000 my way search assistant (Viruses, Spyware and other Nasties)
- Internet Explorer search problem (Windows NT / 2000 / XP)
- kinda clueless new girl - search extender won't go away (Viruses, Spyware and other Nasties)
Other Threads in the PHP Forum
- Previous Thread: Inserting delay in PHP scripts
- Next Thread: PHP progress bar
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
# 5.2.10 access alexa apache api array beginner broken cakephp checkbox class clean clients cms code convert cron curl database date directory display dissertation dropdown dynamic echo$_get[x]changingitintovariable... email encode error fairness file folder form forms function functions google hack href htaccess html image include indentedsubcategory ip javascript joomla legislation limit link local login mail memberships menu methods multiple multipletables mysql mysqlquery network newsletters object oop open passwords paypal pdf persist php provider query radio random redirect remote script search secure securephp server sessions simple sockets source space spam sql system table tutorial upload url user variable video voteup web youtube