Jump to content

thetylercox

Members
  • Posts

    14
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

thetylercox's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. i am trying to create a checkbox limit based on a value changes! If the value of a checked checked box is different then the previous prompt an alert! Some of the check boxes do have the same value. Not all of them! example: I have the following checkbox! <input name="" type="checkbox" value="here">(if this was checked) <input name="" type="checkbox" value="here">(then this) <input name="" type="checkbox" value="there">(would not allow prompt alert) <input name="" type="checkbox" value="here">(would allow) my problem is in the if statement function setChecks(obj){d=document.getElementByclass(chk) If(d.value!=d.value) {obj.checked=false alert('you may only choose options from the same dist!') } something like this obviously this will not work but its where im at! So How do i store the previous checked checkbox value and compare it to the just checked box!
  2. Thanks a million ahhhhhhhhhh thank you!
  3. I have the folloowing list orderfrom |Name --------------- ClearVision, Oakley, I-Deal Optics | ClearVision ClearVision, Oakley, I-Deal Optics |I-Deal Optics ClearVision, Oakley, I-Deal Optics |Oakley I want a querry that doesnt show these if name is in orderfrom example: orderfrom |Name --------------- ClearVision, Oakley, I-Deal Optics | ClearVision(Would NOT return this record) ClearVision, |I-Deal Optics(Would return this record) ClearVision, , |Oakley(Would return this record) I Tried the following! whats important is the very last part please over luck anything else you see as to its working! SELECT * FROM `dist` JOIN `patientacct` ON `patientacct`.dist LIKE CONCAT('%', `dist`.name ,'%') inner join `treasure` on `treasure`.`id` = `patientacct`.`id` where (status = 'To Order' and This part is where I need help!(( `dist`.name not like CONCAT('%',`patientacct`.orderfrom,'%')) )) order by `name` ASC IN need of help thanks to all! Going to eat will reply when i return if i get a helpful samaritan!
  4. how to get from this to this is the question!
  5. how about an easier question how could i link these tables "relational" when one record can be tied to one or more other records. As above oakley is tied to bob and billy,
  6. as i said im entirely new to the idea of joins. I have not tried any other join than the one i listed. I have been trying to read but its a little difficult to wrap my head around at the moment. How would a left join differ? Whats the querry sintax u would suggest?
  7. I have 2 tables Table name Dist. NAME|Phone|ID ---------------- Oakley|555-555|1 Maui|666-666|2 lux|777-7777|3 Table name Patientacct. Name|prescription|id|dist ------------------------------- bob|20-20|1|oakley billy|15-20|2|Oakley, Maui kim|20-20|3|Lux Im looking for a display like Oakley -------------------- Bob Billy Maui ------------------ Billy Lux -------------- kim Trials so far SELECT * FROM `dist` JOIN `patientacct` ON patientacct.dist LIKE CONCAT('%', `dist`.name ,'%') GROUP BY `dist`.name This showed only 1 dist if i drop the group by example:SELECT * FROM `dist` JOIN `patientacct` ON patientacct.dist LIKE CONCAT('%', `dist`.name ,'%') i get the record twice so what I need is somewhere between the two. Im extremely new to joins so be easy when explaining. Thanks
  8. If this needs to be posted elsewhere please tell me!
  9. I thought this post belonged here because I am not looking for an exact answer rather a general direction to look! I'm trying to fill out a webpage form based on info I have. The form is not mine. To explain I'm trying to place an order from company A @ www.companyA.com/form with info I have in my company B database. I dont want to use any third party Software for this and I don't have access to the info the Company A is using to store the form info. Thanks in advance.
  10. Considering using godaddy & phpMyAdmin vs. having a sever in the places of business and hosting it on site! Pros and cons of both? The most notable to me is dealing with the internet being down could be a hassle but I can work around this issue. Not sure about safety? Any input would be appreciated!
  11. I'm obviously over thinking it lol! Was just curious if anyone had an order they stick to that they somehow find pleasing!
  12. So more of an aesthetics question. Where do you put what when coding or what is the preferred order? example! style html head script php head body Speaking in the case of order does not matter! Yes I get that it does just curious how some of you organize your code.
  13. Perfect! Is that the norm fix for this situation? Another way of asking this? Is there any other way? Thanks for the reply!
  14. The objective: Design a database for a local store in town to keep up with customers and their purchases.Not an online store! The issue i'm having: How to handle the issue of repeat customers. So I have the fields they want to keep up with but on the return trip I don't want to delete the old info instead I want to add to it. So when the record is pulled for this person it will show all there past purchases but only on one record. I had the idea of making another database for purchases and using unique keys I would query the purchased database! Enough with the rambling. I'm just open for ideas I am a bit of a nob when it comes to the designing and would kindly like some advice links something to point me in the right direction! Thanks in advance Tyler Cox
×
×
  • 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.