Tables Question

[RobertB]

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.

[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.

[Ray Borduin]

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.

[RobertB]

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

[Ray Borduin]

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

[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.