Reload a php query that is included in html page when select option is pressed.

I have a index.php page that that uses this in the body.
<div id="live-area">
                            <?php include ('assets/php/multibox.php');?>
                                </div>

Open in new window


In that multibox.php i have a div id container that loads my highcharts.
On that same multibox.php i have a query to load the table data.

I have a select option box that is filled by a mysql query on same page.

here is what the options look like
echo "<option value=index.php?id=$row[activity]/$row[app_name]>$row[app_name]</option>";

Open in new window


So when they are clicked they reload the index.php (same page they are included on) and pass id.

I then have this on the multibox.php to check the id
if ($_GET['id'] == '')

So i can change the query based on that id so when the page loads it shows the chart with data for the selected.

SO... my question.

How can i just refresh that php with data for graph?

I did the following but it reloads the entire page into the live-area div.

echo "<select name=category value='' onchange=\"runthis(this)\"></option>";

Open in new window


 <script type="text/javascript">

        function runthis(sel) {
            var page = sel.value;
        $.ajax({
            url: page,
            success: function (response) {
                $('#live-area').html(response);
            }
        });
        }
    </script>

Open in new window

LVL 2
bignadadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GaryCommented:
You need to create a page that is called by the ajax function that only contains the data (HTML) for the graph and nothing else
0
bignadadAuthor Commented:
i figured it out.

function runthis(sel) {
        var page = sel.value;
        $('#live-area').load('assets/php/multibox.php?id=' + page);
    }

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bignadadAuthor Commented:
Firgured out the answer myself
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.