Jump to content

Archived

This topic is now archived and is closed to further replies.

homchz

Mutiple Search

Recommended Posts

I want to beable to search account information by three options

 

Account Number

Phone Number

Company Name

 

I have the query working for each individually, but I think I need to create three different queries for it to work on the page, each query needs a place to put the info and I want to use the same page for the info display.

 

Working with record sets in Dreamweaver, I can accoplish what I want but lay out is a pain, I though I had a solutions using form fields but it looks like I can only insert one record set into a form field

<input name="AcctType" type="text" id="AcctType" value="<?php echo $row_Recordset1['customer_type']; ?>" size="20">

 

But can I manually insert multiple record sets?

 

Thanks

Josh

Share this post


Link to post
Share on other sites

josh,

 

want to be able to search account information by three options

 

Don't know if this will help, but by the way I understand it one option may be to apply recordsets for all three results and only display the ones you want by using "show region" server behavior (can be applied to a recordset result directly)

 

Another option may be to link the tables or do a table join (foreign keys, etc), to help keep everything tidy and then simply drag the resulting recordset fields where you want them. Sounds as if you wouldn't need a repeat region for this.

(don't know if you have multiple accounts or listings for same company, etc)

 

I have a related situation, posted today (creating additional select menu; menu names and variables/the statement for this).

 

Hope this brought you closer.

 

Brad

 

 

 

 

 

 

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.