Jump to content

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

Link to comment
Share on other sites

  • 3 weeks later...

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

 

 

 

 

 

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.