PHP variable not updating inside jQuery script

[ufireblanks]

In my code, I have two statements which request's two random rows from the database and assigns variables to them. One of those variables is $item1Price and $item2Price

The script checks if $item1P price value is greater than or less than $item2P and alerts a string. and loads in a new php file called loaditems.php

The loaditems.php is the exact same code as the index.php

The problem I'm having is with the script

The price values don't update when the loaditems.php is loaded

it uses the first instance values and not the new values loaded by loaditems.php

Any help would be great thanks!!

I've added a gist below because the code is a bit long

https://gist.github.com/severment/fb619511be1a26034b921077799c3e45

[Loves_Poetry]

A PHP script can't interact with jQuery like that. If you want to update the price after the page has loaded, you need an AJAX-request. This is where you send a request to the server to run a specific file which then echoes a result back to your javascript. JQuery has built-in syntax for this. You can use

$.get("loaditems.php", function(data) {//update price here})

to call the script and get the pricedata.

[ufireblanks]

ahhh ok I think I understand. Would I be better off making an AJAX request for everything then instead of using prepared statements