close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Tables Question

Thread began 5/22/2009 3:58 pm by RobertB | Last modified 5/22/2009 7:36 pm by RobertB | 1285 views | 5 replies |

RobertB

Tables Question

Ok...I FINALLY got DA to connect to my online db.

Now, I venture into total noobdom as far as understanding mySql lingo....

I am still working on the Yoga locations mockup...

so, I want to search by these parameters:

1) Day of the Week
2) Quadrant
3) Type of Yoga

Exactly in that order. So, I assume those are text fields and where do I put the variables, e.i. Monday, Tuesday, etc. Also the characters required to do that. Thank you in advance.

Sign in to reply to this post

RobertB

Not sure if I made my post clear.....when I login into my database manually and create the table, I am looking for guidance on how to format the table as per my prescribed needs.

Thanks.

Sign in to reply to this post

Ray BorduinWebAssist

Create columns for the data you want searched on, so:


1) Day of the Week
2) Quadrant
3) Type of Yoga

(don't actually name them with spaces) order doesn't matter.

Sign in to reply to this post

RobertB

Thanks Ray...I did that...but, how to I pre-format Mon, Tues, etc options?

Sign in to reply to this post

Ray BorduinWebAssist

What do you mean by pre-format? Maybe use a select list?

Sign in to reply to this post

RobertB

yes, I think that is what I mean....

In my desired three categories, I need to have a list....

So, day of the week would have all the obvious options...
Type of yoga, would be all those options.

Thanks for your help Ray.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...