Jump to content

DBookatay

Members
  • Posts

    334
  • Joined

  • Last visited

About DBookatay

  • Birthday 07/28/1980

Contact Methods

  • Website URL
    http://www.carcityofdanbury.com

Profile Information

  • Gender
    Male
  • Location
    CT

DBookatay's Achievements

Advanced Member

Advanced Member (4/5)

0

Reputation

  1. I am attempting to add a estimated payment on my website, getting stuck on the interest amount. Here's what I'd like to do: (These will vary based on the year of the car, here for demonstration purposes) $asking = 16495; $down = 2474; $doc = 200; $interest = .05; $tax = .0635; $term = 60; Basically what I'm trying to do is: $asking + $doc x $tax - $down x $interest / $term In my finance calculator the payment comes out to $288.37. On my site the payment is over $7000. What am I not seeing?
  2. I'm looking to hire someone to build a new version of an image upload/ resize script for my admin area. I currently have one in place which is about 5 years old and now in need of a refresh. I run a high volume used car dealership and on average add about 5 vehicles into our inventory per day, with 10 - 20 pictures per vehicle. My current script is very very slow, and requires to much user input. I want the script to start once the pictures are dragged into the "area" (page, div, span, however it is coded) and save the proper order of the images when I drag them around. My current script wont start until I click start, throws a lot of errors, and wont save the proper order untill I hit save. I know that these might seem like small things to complain about but when I'm multi tasking and doing my usual 5 things at once and forget to hit "save" after dragging 20 images I get mad. I want to drag the photos and have them resized 3 times, (thumbnail, medium and large,) place them into the corresponding folder, and save the proper order of the image sequence in my dB. (My current script does do all of this, but like I said, it is very slow, and throws a ton of errors.) Facebook, Google Photos (and a ton of others) have good examples of what I'm looking for. Email me, brad@carcityofdanbury.com with and questions or with quotes and time frame needed to complete this project. The most important thing is that my current script must remain usable until the new one is complete. If your work is good I have some other things that I could possible have your help working on.
  3. I have an online credit app with several fields that are month and year selections (time at address, hire date, etc) and want to not only display the results (March, 2011) that the analyst views, but also the length based on when the app was originally submitted. Unfortunately I can not change the structure of the dB, so instead need to change the output of the php, but have been unsuccessful. The rows are: "ap_add8" = Month (January - December full text,) "ap_add9" = Year (2014) and "submitted" = the date the ap was submitted (2014-03-24.) I've tried $Difference = abs(strtotime($row['ap_add9'].'-'.date("m", mktime(0, 0, 0, $row['ad_add8']))) - strtotime(date("Y").'-'.date(m))); $Years = floor($Difference / (365*60*60*24)); $Months = floor(($Difference - $Years * 365*60*60*24) / (30*60*60*24)); if ($Years !="0") {$Years = $Years.' years, ';} else {$Years = NULL;} if ($Months !="0") {$Months = $Months.' months';} else {$Months = NULL;} to get it working based on todays date, but can't even get that working properly, let alone based on when the app was submitted.
  4. I'm using jQuery validation to make sure all my required fields are filled in, however I was getting a lot of bot spam and want to use something like jQuery Real Person as a captcha system . How do I combine the 2, so that submit will fail if the captcha field is not correct? $("#enroll").validate({ invalidHandler: function(e, validator) { var errors = validator.numberOfInvalids(); if (errors) { var message = errors == 1 ? 'You missed 1 required field.' : 'You missed ' + errors + ' required fields'; $("div.Error span").html(message); $("div.Error").show(); } else { $("div.Error").hide(); } }, }); The link, if relevant is here
  5. http://stackoverflow.com/questions/15755418/populating-one-select-box-based-on-another-when-selects-are-arrays
  6. I know how to populate one select box based on the option from another using jquery and ajax, but how do you do it when the select boxes are arrays? By default there are 10 rows on the page, however I also am using .EnableMultiField() to add more lines as I need them... On any given week we add between 10 to 30 vehicles into our inventory. Ajax: $(".make").change(function() { var id=$(this).val(); var dataString = 'id='+ id; $.ajax ({ type: "POST", url: "get_models.php", data: dataString, cache: false, success: function(html) { $(".model").html(html); } }); }); And the php <ul> <li>Year <select name="year[]"><option></option>'.$Year.'</select></li> <li>Make <select name="make[]" class="make"><option></option>'.$Make.'</select></li> <li>Model <select name="model[]" class="model" style="width: 120px"><option></option>'.$Model.'</select></li> <li>Trim <input type="text" size="10" name="trim[]" /></li> <li>VIN <input type="text" name="vin[]"size="20" maxlength="17" onkeyup="return Upper(event,this)" /></li> <li>Mileage <input type="text" name="mileage[]" size="3" maxlength="6" /></li> <li>Color <select name="color[]"><option></option>'.$Color.'</select></li> <li>Cost <input type="text" name="cost[]" size="6" maxlength="6" onchange="currency(this)" /></li> <li>Asking <input type="text" name="asking[]" size="6" maxlength="6" onchange="currency(this)" /></li> </ul>
  7. THANK YOU! This did the trick, now only the students that are signed up for s1_AM in that particular class ($id) are showing up. Much appreciation!
  8. I did a sql export, here is what I got. (I did cut out some rows, just to save space) INSERT INTO `enrollment` (`id`, `student`, `s1_AM`, `s1_PM`, `s2_AM`, `s2_PM`, `balance`, `date`) VALUES (1, 1, 10, 0, 0, 0, 0, '2013-03-04'), (2, 2, 8, 0, 0, 0, 0, '2013-02-27'), (3, 3, 0, 0, 0, 12, 0, '2013-03-02'), (4, 4, 18, 0, 0, 0, 0, '2013-03-02'), (5, 5, 18, 0, 0, 0, 0, '2013-03-02'), (6, 6, 0, 0, 3, 5, 0, '2013-02-27'), (7, 7, 0, 0, 9, 14, 0, '2013-02-27'), (8, 8, 15, 0, 0, 0, 0, '2013-02-26'), (9, 9, 12, 0, 14, 0, 0, '2013-02-26'), (10, 10, 10, 3, 0, 0, 0, '2013-03-04'), (11, 11, 11, 17, 0, 0, 0, '2013-03-04'), (12, 12, 3, 0, 6, 0, 0, '2013-02-19'), (13, 13, 3, 0, 6, 0, 0, '2013-02-19'), (14, 14, 0, 8, 0, 0, 0, '2013-03-03'), (15, 15, 0, 1, 0, 2, 0, '2013-03-03'), (16, 16, 5, 4, 18, 0, 0, '2013-03-01'), (17, 17, 0, 4, 0, 5, 0, '2013-02-26'), (18, 18, 13, 17, 0, 0, 0, '2013-02-25'), (19, 19, 8, 10, 0, 0, 0, '2013-02-25'), (20, 20, 11, 0, 0, 0, 0, '2013-02-27'), (21, 21, 13, 7, 0, 9, 0, '2013-02-27'), (22, 22, 8, 6, 0, 3, 0, '2013-02-27'), (23, 23, 0, 8, 0, 0, 0, '2013-02-27'), (24, 24, 12, 14, 0, 0, 0, '2013-02-27'), (25, 25, 0, 0, 12, 14, 0, '2013-02-28'), (26, 26, 12, 0, 14, 0, 0, '2013-03-01'), (27, 27, 0, 10, 0, 0, 0, '2013-03-01'), (28, 28, 0, 0, 6, 0, 0, '2013-03-14'), (29, 29, 6, 3, 4, 5, 0, '2013-03-14'), (30, 30, 4, 0, 5, 0, 0, '2013-03-15'), (31, 31, 4, 0, 5, 0, 0, '2013-03-15'), (32, 32, 7, 0, 9, 0, 0, '2013-03-15'), (33, 33, 12, 0, 0, 0, 0, '2013-03-15'), (34, 34, 4, 0, 0, 0, 0, '2013-03-15'), (35, 35, 5, 0, 0, 0, 0, '2013-03-16'), (36, 36, 4, 0, 5, 5, 0, '2013-03-16'), (37, 37, 0, 0, 9, 0, 0, '2013-03-17'), (38, 38, 0, 0, 9, 0, 0, '2013-03-17'), (39, 39, 17, 0, 0, 0, 0, '2013-03-17'), (40, 40, 4, 0, 5, 0, 0, '2013-03-18'), (41, 41, 10, 0, 0, 0, 0, '2013-03-18'), (42, 42, 10, 0, 0, 0, 0, '2013-03-18'), (43, 43, 18, 0, 0, 0, 0, '2013-03-18'), (44, 44, 12, 14, 0, 0, 0, '2013-03-18'), (45, 45, 13, 15, 0, 0, 0, '2013-03-18'); INSERT INTO `students` (`id`, `p_id`, `nmF`, `nmL`, `sex`, `dob`, `tshirt`, `school`, `grade`, `teacher`, `notes`, `ped_name`, `ped_city`, `ped_phone`, `ext_care`) VALUES (1, 1, 'Nicholas', 'Titolo', 'M', '2005-01-28', 'YM', 'Huckleberry Hill Ele. School', '3', 'Mrs. Plue', '', '', '', '', ''), (2, 2, 'Dylan', 'Morris', 'M', '2005-05-26', 'YS', 'Hill & Plain Elementary', '3', 'Mrs. Molinaro', '', '', '', '', ''), (3, 3, 'Peter', 'Wirth', 'M', '2003-11-19', 'YL', 'Meeting House Hill School', '5', 'Wilkens', '', '', '', '', ''), (4, 4, 'Chase', 'Dietter', 'M', '2005-01-26', 'YL', 'Huckleberry Hill Elementary', '3', 'Mrs. Prizio', '', '', '', '', ''), (6, 5, 'Brandon', 'Zhang', 'M', '2006-10-10', 'YM', 'John Pettibine School', '2', 'Mrs. Gregory', '', '', '', '', ''), (5, 4, 'Brody', 'Dietter', 'M', '2007-09-05', 'YM', 'Center Elementary School', '1', 'Summerfeld', '', '', '', '', ''), (7, 5, 'Jason', 'Zhang', 'M', '2002-07-19', 'YL', 'Sarah Noble Intermediate', '6', 'Mrs. Klee', '', '', '', '', ''), (8, 6, 'Aidan', 'Johnston', 'M', '2002-04-14', 'AS', 'Pembroke Elementary', '6', 'John Merrill', '', '', '', '', ''), (9, 6, 'Madeline', 'Johnston', 'F', '2003-10-31', 'YL', 'Pembroke Elementary', '5', 'Edwin Pena', '', '', '', '', ''), (10, 7, 'Alexander', 'Rogg', 'M', '2005-05-25', 'YS', 'Hill & Plain Elementary', '3', 'Ms. Molinaro', '', '', '', '', ''), (11, 7, 'Tyler', 'Rogg', 'M', '2003-07-13', 'YM', 'Sarah Noble Intermediate', '5', 'Mrs. Gee', '', '', '', '', ''), (12, 8, 'Madelyn', 'Burgess', 'F', '2006-03-11', 'YM', 'Pembroke Elementary', '2', 'Miss Haynes', '', '', '', '', ''), (13, 9, 'Kaitlyn', 'Salvatore', 'F', '2006-03-21', 'YS', 'Great Plain Elementary School', '2', 'Mrs. Leppla', '', '', '', '', ''), (14, 10, 'Claire', 'Kuntze', 'F', '2004-04-12', 'YM', 'Meeting House Hill School', '4', 'Mrs. Quist', '', '', '', '', ''), (15, 10, 'Benjamin', 'Kuntze', 'M', '2007-04-03', 'YS', 'Consolidated School', '1', 'Mrs. Brown', '', '', '', '', ''), (16, 11, 'Maxwell', 'McCarthy', 'M', '2006-05-22', 'YM', 'AIS Magnet School', '2', 'Mcgettigan', '', '', '', '', ''), (17, 12, 'Gabrielle', 'Pomeroy', 'F', '2006-01-29', 'AS', 'Homeschool', '2', 'N/a', '', '', '', '', ''), (18, 13, 'Stephanie', 'Yee', 'F', '2002-03-01', 'AM', 'Pembroke Elementary', '6', 'Mr. Merrill', '', '', '', '', ''), (19, 13, 'Emily', 'Yee', 'F', '2006-04-01', 'YM', 'Pembroke Elementary', '2', 'Mrs. Gerhardt', '', '', '', '', ''), (20, 14, 'Grace', 'Oconnell', 'F', '2002-10-19', 'AS', 'Reed Intermediate', '6', 'Mr. Myhill', '', '', '', '', ''), (21, 15, 'Kevin', 'Tang', 'M', '2002-04-07', 'AS', 'Wms', '6', 'Mrs. Nanassy', '', '', '', '', ''), (22, 15, 'Rachel', 'Tang', 'F', '2005-10-14', 'YS', 'Hhes', '3', 'Mrs. Naiman', '', '', '', '', ''), (23, 16, 'Julianna', 'Fontanilla', 'F', '2005-10-07', 'YM', 'Hill And Plain School', '3', 'Mrs. Meeker', '', '', '', '', ''), (24, 17, 'Jacob', 'Finch', 'M', '2003-10-27', 'YM', 'Kent Center School', '4', 'Susan Makarewich', '', '', '', '', ''), (25, 18, 'Shruti', 'Kelkar', 'F', '2004-01-23', 'YM', 'Stadley Rough', '4', 'Mr Poliquin', '', '', '', '', ''), (26, 19, 'Sebastian', 'Tseng', 'M', '2003-05-03', 'YL', 'St. Joseph School Brookfield', '5', 'Mrs. Nancy Rubino', '', '', '', '', ''), (27, 20, 'Jake', 'Windas', 'M', '2003-08-08', 'YL', 'Home School', '4', 'N/a', '', '', '', '', ''), (28, 21, 'Mya', 'Cefaloni', 'F', '2006-07-02', 'YS', 'Great Plain', '2', 'Ms Owens', '', '', '', '', ''), (29, 22, 'Siri', 'Reddy', 'F', '2006-04-02', 'YM', 'Brookside ', '2', 'Ms. Bockhaus', '', '', '', '', ''), (30, 23, 'Emily', 'Lang', 'F', '2006-01-31', 'YL', 'Kent Center School', '2', 'Mrs Ackerman ', '', '', '', '', ''), (31, 23, 'Madison', 'Lang', 'F', '2006-01-31', 'YL', 'Kent Center School', '2', 'Mrs Ackerman ', '', '', '', '', ''), (32, 24, 'Patrick', 'Dwyer', 'M', '2002-10-21', 'AL', 'Sherman School', '6', 'Mrs. Rianhard', '', '', '', '', ''), (33, 25, 'Brennan', 'Wilkins', 'M', '2003-11-09', 'YL', 'Kent Center School', '4', 'Mrs. Adrienne Mcbrien', '', '', '', '', ''), (34, 25, 'Ashley', 'Wilkins', 'F', '2006-09-02', 'YM', 'Kent Center School', '2', 'Mrs. Nancy Ackerman', '', '', '', '', ''), (35, 26, 'Declan', 'Hsieh', 'M', '2005-11-16', 'YM', 'Sandy Hook Elementary', '3', 'Ford', '', '', '', '', ''), (36, 27, 'Marra', 'Elsesser', 'F', '2006-03-15', 'YS', 'Kent Center School', '2', 'Mrs. Dasilva', '', '', '', '', ''), (37, 28, 'Brooklynn', 'Carpenter', 'F', '2001-12-21', 'YL', 'Stadley Rough School', '6', 'Mills', '', '', '', '', ''), (38, 28, 'Roy ', 'Carpenter', 'M', '2001-12-21', 'YL', 'Stadley Rough School', '6', 'Henggeler', '', '', '', '', ''), (39, 29, 'David', 'Mercier', 'M', '2000-04-25', 'AS', 'St. Joseph School (brookfield)', '8', 'Kathy Benzing', '', '', '', '', ''), (40, 30, 'Mary', 'LaFond', 'F', '2006-04-09', 'YM', 'Sharon Center School', '2', 'Mrs. Ives', '', '', '', '', ''), (41, 31, 'Ella', 'Behling', 'F', '2005-09-19', 'YS', 'Huckleberry Hill', '3', 'Mrs. Laughlin', '', '', '', '', ''), (42, 32, 'Brayden', 'Tripler', 'M', '2004-05-08', 'YM', 'St Joseph', '4', 'Mrs Thompson ', '', '', '', '', ''), (43, 32, 'Samantha', 'Tripler', 'F', '2007-01-31', 'YM', 'St Joseph', '1', 'Mrs Tomaselli', '', '', '', '', ''), (44, 33, 'Tiffany', 'Chen', 'F', '2004-06-01', 'YM', 'John Pittebone Elementary School', '4', 'Ms. Picco', '', '', '', '', ''), (45, 33, 'Stephen', 'Chen', 'M', '2002-01-16', 'AM', 'Sarah Noble School', '6', 'Ms. Miller', '', '', '', '', ''); Does this help, or do you need the structure as well?
  9. B. No, when I paste the same into phpMyAdmin is also only returns 1 name
  10. Barand: The above it only displaying the first student, even though there are currently 22 enrolled in session 1, am class. Here is what I have: $query = 'SELECT students.nmL, students.nmF FROM students INNER JOIN enrollment ON students.id = enrollment.s1_AM WHERE enrollment.id = '.$id; $result = mysql_query($query); $result = mysql_query($query) or die(mysql_error()); $numrows = mysql_num_rows($result); for($x = 0; $row = mysql_fetch_array($result); $x++) { $s1_AM .= '<p>'.$row['nmF'].' '.$row['nmL'].'</p>'; } If their not enrolled in s1_AM then I don't want them to display, which was the problem with the original query that I posted, all the students (over 100) were being displayed, even though I know only 22 were supposed to.
  11. class id is in the enrollment table in the "id" field.
  12. The enrollment table is: id student s1_AM s1_PM s2_AM s2_PM and the student table id p_id nmF nmL sex dob tshirt school grade teacher notes When a student registers the have 4 time slot options, s1_AM, s1_PM, s2_AM, s2_PM, (s meaning "session,") and their student id gets saved in the time slot that they chose. So to answer your question, s1_AM would contain the student id.
×
×
  • 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.