Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 5 of 5
Search took 0.09 seconds. Search: Posts Made By: mjstehn
Forum: MySQL 09-19-2012, 06:19 AM
Replies: 10
Views: 1,190
Posted By mjstehn
Thanks, good to know. It buys me some time to...

Thanks, good to know. It buys me some time to work on the PHP portion.

I was actually thinking that just having a table with Week1, Week2, Week3, etc. might actually work better. Might not be...
Forum: MySQL 09-19-2012, 05:28 AM
Replies: 10
Views: 1,190
Posted By mjstehn
I really appreciate the help. One more question....

I really appreciate the help. One more question. I am going to have 17 weeks so is there a more efficient way to do this than what I am doing? Is there a better way to design the tables to make...
Forum: MySQL 09-19-2012, 12:07 AM
Replies: 10
Views: 1,190
Posted By mjstehn
That worked. Thanks, I did try yours and...

That worked. Thanks,

I did try yours and forgot to post the results, sorry. Since I did not state that there were 2 table (sorry, I thought I did) that query did not work.

I am very new at...
Forum: MySQL 09-17-2012, 11:56 PM
Replies: 10
Views: 1,190
Posted By mjstehn
I tried this: I use Alias instead of name. This...

I tried this: I use Alias instead of name. This pull the info I am looking for, but does not put Week 2 in the recordset as an additional column.

I was trying to avoid programming on the front...
Forum: MySQL 09-17-2012, 02:56 AM
Replies: 10
Views: 1,190
Posted By mjstehn
Help with Query

I have a table that has Name,PickID,Week.

I want to run 1 query that will pull into 1 result set the following

Name, PickID for Week1, PickID for Week2.

Can anyone help? Thanks,
Showing results 1 to 5 of 5

 
Forum Jump

All times are GMT +1. The time now is 11:16 PM.