Jump to content

kts

Members
  • Posts

    221
  • Joined

  • Last visited

About kts

  • Birthday 07/23/1986

Contact Methods

Profile Information

  • Gender
    Male
  • Location
    New York, NY
  • Age
    27

kts's Achievements

Regular Member

Regular Member (3/5)

0

Reputation

  1. Hey, What kind of information are you storing? I'm assuming that none of it is secure financial data. If so could you provide a list of data you need to store and a bit of a description on what this application would need to do. Feel free to PM me. Thanks, Kyle
  2. Your original code worked for me pasting in js fiddle.. so not sure the question. Rather than generate the input as an append for the body, it makes more sense to put this in a div that you are showing and hiding. You can set the div to hidden on default. You can see the changes here: http://jsfiddle.net/uGPJ5/
  3. Make sure all of your seeing all of your errors, it could be something else causing this.
  4. If you look you will realize you only labeled out all information for 2 items.. You mislabeled the numbers for the rest of these pieces.. See bold below. $output[] = '<input type="hidden" name="item_number_3" value="3">'; $output[] = '<input type="hidden" name="item_name_2" value="'.$product.'">'; $output[] = '<input type="hidden" name="amount_2" value="'.$trade.'">'; $output[] = '<input type="hidden" name="item_number_4" value="4">'; $output[] = '<input type="hidden" name="item_name_2" value="'.$product.'">'; $output[] = '<input type="hidden" name="amount_2" value="'.$trade.'">'; $output[] = '<input type="hidden" name="item_number_3" value="5">'; $output[] = '<input type="hidden" name=item_name_2" value="'.$product.'">'; $output[] = '<input type="hidden" name="amount_2" value="'.$trade.'">'; $output[] = '<input type="hidden" name="item_number_4" value="6">'; $output[] = '<input type="hidden" name="item_name_2" value="'.$product.'">'; $output[] = '<input type="hidden" name="amount_2" value="'.$trade.'">'; $output[] = '<input type="hidden" name="item_number_3" value="7">'; $output[] = '<input type="hidden" name="item_name_2" value="'.$product.'">'; $output[] = '<input type="hidden" name="amount_2" value="'.$trade.'">';
  5. The table of students has already been consolidated... when I try to LEFT JOIN ON c.Title = oc.Title I'm not getting all 12 of the rows for each student like I should be...
  6. I have two tables. OTRegents just has 12 rows one for each "Title" FullCredits has all of the results by studentid for any completed Title's with Mark. I am trying to display All Title's regardless if they exist in FullCredits and have them show up null if they do not exist,but still have them display so that each StudentID has 12 rows regardless. When I use this query: SELECT c.StudentID, oc.Department, oc.Title, (case when oc.Title = c.Title then c.Mark else 0 end) Mark, (case when c.Grade >= oc.Grade then 1 else 0 end) Required, (case when c.Grade >= oc.Grade AND c.Mark >= oc.OnTrack then 1 else 0 end) Passed FROM FullCredits c JOIN OTRegents oc ON (oc.Title = c.Title) WHERE c.Type = 'Regents' GROUP BY c.StudentID, oc.Department, oc.Title I am receiving the proper mark's for each test, but the problem is not all of the tests are showing. I need it show all 12 tests for each StudentID When i Remove the FROM FullCredits c JOIN OTRegents oc ON ---> remove the join on (oc.Title = c.Title) I get all of the tests, but the mark will only show correctly for ONE test. I am simply trying to have all 12 rows in the OTRegents be shown for each StudentID and show Mark for each one, if there is no row existing for the Title/Mark for that StudentID I need it to still show up, but for it to be null. Hopefully this makes sense, its clearly a joining issue, but I have been trying many ways and running out of ideas.
  7. Yea, I was just getting desperate... The issue still arises, its strange.. they all seem random highest is 192 and just scatters down randomly no rhyme or reason... New query: SELECT q.StudentID StudentID, q.LastName LastName, q.FirstName FirstName, q.Grade Grade, q.Department Department, sum(crp.RegentPass) FROM CredDetails q JOIN CountRegentsPassed crp ON (crp.StudentID = q.StudentID AND crp.Department = q.Department) GROUP BY q.Department, q.StudentID
  8. Good point, let me clarify a bit. For each student I have 0 and 1's for the RegentPass value. There are about 20 or so per StudentID. Although when using the sum() in this manner, I am getting 74 and 138, 384 for the value of sum(crp.RegentPass) not sure why, but it seems to be summing incorrectly... its not consistent though.
  9. hey, i am trying to sum a bunch of values that are 1's but when it is summed it, it seems to be summing more than just the "Department" and "StudentID" like the where clause states... I'm getting sums of over 100, not sure why ... SELECT q.StudentID StudentID, q.LastName LastName, q.FirstName FirstName, q.Grade Grade, q.Department Department, sum(crp.RegentPass) FROM CredDetails q JOIN CountRegentsPassed crp ON (crp.StudentID = q.StudentID AND crp.Department = q.Department) WHERE crp.StudentID = q.StudentID AND q.Department = crp.Department GROUP BY q.StudentID, q.Department
×
×
  • 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.