Erwin007

I celebrated too fast.... what exactly is "reps r", "sales s" and r.reps_id" in:? FROM reps r JOIN sales s ON r.rep_id = sales_rep_id

Yes! Works like a charm. Thank you so much, learning a lot in 2 days. 😀👍

Table reps: - rep_id - rep_name - rep_touroperatorid Tablse sales: - sales_id - sales_repid - sales_ticketnr Hope this helps

$query = "SELECT * FROM `sales` WHERE rep_id = $query = "SELECT * FROM `reps` WHERE rep_touroperatorid = '5' I have difficulty explaining it but will try: I need to select all sales where all the reps have the rep_touroperatorid 5 How to "join" or "insert into" or ?? If somebody can help, would be great. Thanks

Wow, it works!! Great! Thanks

Ok, that doesn't solve my problem unfortunately, still no clue how to get this done.

Hi, in my code I have this: <div class="col col-md-2 offset-md-7"> <label>Total Sales US$:</label> <input type="text" style="text-align:right;" name="total_am" value="<?php echo $total_am?>" class="form-control total"> </div> When $total_am is greater than 0 it has to hide the button tried this: <div class="col col-md-2 offset-md-7"> <label>Total Sales US$:</label> <input type="text" style="text-align:right;" name="total_am" value="<?php echo $total_am?>" class="form-control total"> <?php onoff(total_am); ?> </div> <script> function onoff(value) { if(value==="0") { document.getElementById('DeleteButton').hidden = true; } else { document.getElementById('DeleteButton').hidden = false; } } </script> But execution of the rest stops after getting to onoff(total_am) Trying for hours but can't get it to work Thanks