Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
skrodzki #1
Multiparameter query for MySQL DB on ASP page
:confused; I am trying to find the correct query string to give the following
result....The input form has 6 serach criteria, if a user inputs only three of
the six, the result should be only the records matching those inputs. My
current statement does not do this.
I am using a MySQL database with one table. The code needs to be able to work
with any amount of the criteria specified by the input. I am having a difficult
time figuring this out. Please help!!!!!!!!
SELECT *
FROM docimg.tickets
WHERE (ticketdate = 'MMTicketDate') OR ( ticketnum = 'MMTicketNum') OR
(customername = 'MMCustomerName') OR (customernum = 'MMCustomerNum') OR
(jobnum = 'MMJobNum') OR (trucknum = 'MMTruckNum')
ORDER BY ticketnum ASC
skrodzki Guest
-
MySQL Query Cache Not Working: MySQL 5 / Windows XP
Please excuse this post if you've already read it on mailing.database.mysql - i just discovered these other groups. future posts will be... -
results page from mysql query
i have created a search page for locations by country in php and a dynamic table on a results page. Doing a test from the recordset details it... -
MYSQL query: AND OR?
This will probably sound stupid. How would you do a MYSQL query that was to evaluate if either condition A or B was meet? And if so, in what... -
query a DB - pass the query to next page
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned,... -
[PHP] PHP - MySQL Query...
$dbh = mysql_connect("localhost", "login", "password") or die('cannot connect to the database because: ' . mysql_error());...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
