taquitosensei

You can use LIMIT in mysql select rows from table limit 1,21 would return the first 21 results. You'd have to build in some logic to determine which page you're on. Here's an example. https://www.myprogrammingtutorials.com/create-pagination-with-php-and-mysql.html

Either that or switch hosting plans/companies. Find one that doesn't limit the number of queries per hour.

You could still write to your database. But at the same time to write to a json file or some other flat file format so that you know it's changed. Then instead of querying the database to find out if the database has changed look at your file.

$phones = "SELECT extension FROM `extensions` where extension IN(".implode(',',$array).")"; or whatever your field is that matches the values in the array

sorry w3 not w2 taxes on the brain

Your iframe id is different than the id you're using in your jquery to load the data. <script type="text/javascript"> $(document).ready(function() { setInterval(function () { $('#show').load('data.php') }, 1000); }); </script> should probably be <script type="text/javascript"> $(document).ready(function() { setInterval(function () { $('#w2').load('data.php') }, 1000); }); </script>

I would suggest doing some more research. It sounds like you need to learn some basic mysql/pdo, php, and html. Here's a decent reference for PDO. There's a ton of php/html tutorials out there. http://www.dreamincode.net/forums/topic/214733-introduction-to-pdo/

It's not the intentions that count. This is unauthorized use. Without an error message, or anything other than "my script doesn't work" I'm going to assume that it's not working because of something on the IRS end.

I don't think anybody here is going to do the work for you. Do you have anything so far other than the requirements? Break it down one step at a time and then if you have trouble in a single spot post the code you're using and we can help.

Agreed

Isn't that what he asked for? This works if I Just use IN for the customers i want to find that have purchased a particular type of apple but i am trying to search for customers that have never purchased a particular apple or multiple apples from my list. For example if i select just macintosh from the list customer 1 still show up as not purchasing that apple type because they have purchased an apple that is not a macintosh. Can anyone help me figure out how i accomplish this task?

select c.* from customers as c LEFT JOIN type as p on c.customer_id=p.customer_id where p.customer_id not in(select customer_id from type where type in('macintosh')); You'll have to do a nested query to select the ones that match, then select the ones that don't match from that.

You can always pull the info with the calendar and put it in the title attribute of the element. Instead of trying to fetch when they hover. Or am I misunderstanding what you're trying to do?

first...does the counter need to be 1 or 0 on the first time through. You set it to zero. Then immediately ++ I would move the $counter++; to the end of the loop. Then echo $counter; somewhere in the loop to make sure that it's actually incrementing.

you don't have a break after your default case. Not sure if that would cause this though.

You've got a counter if($counter==0) { echo "<div class='email-header'>"; echo "<P>".$subject['subject']."</P>"; echo "</div>"; }

you're missing a couple of quotes around email and city. Not sure if this is the problem or not. <input type='text' name=email value="<?php echo $email; ?>"> <input type='text' name=city value="<?php echo $city; ?>"> Other than that it's hard to tell at this point.

If you see the custname in your (now) text field. Then at the top of process.php the very first line you need to do var_dump($_POST); just to make sure your post data is making it to your process.php page. It sounds like the field(s) in your database can't be NULL and it's receiving a NULL value for at least $custname.

So if you do the var_dump($_POST) as the very first line of process.php your other hidden fields have values, but custname is NULL? But if you view the source of the html page your value is there? What is the value?

Sorry didn't see that. Just skimmed through and didn't see an example.

Just use a join with no on statement. select fields from tableone join tabletwo

What do you have so far? Kind of hard to help when we have no idea what you've already done.

It says right in the error message what to do. date_default_timezone_set("Your timezone here"); Mine is "America/Chicago". You'll have to look yours up.

echo "<div class=\"panel panel-primary\"><div class=\"panel-heading clickable\"><h3 class=\"panel-title\"><b>$title_list</b></h3>"; echo "<small>$sublist</small><span class=\"pull-right\"><i class=\"fa fa-minus\"></i></span></div><div class=\"panel-sarabveer-table\"><table class=\"table\"><thead><tr><th>Time</th><th>Kirtani</th><th>MP3</th><th>Video</th></thead>"; Is inside your database loop. You're creating a panel and table for every single result. If that's not what you're intending to do I would move this and line 97 outside of your database loop.

We kind of need the error to help you. It says Error. Could mean mysql, php or html.