Hey guys,
I have the following code to create a combo box:
<th field="spot" width="10%" align="center" sortable="true" editor="text">Spot #</th>
<th field="fixture_id" width="20%" sortable="true">Fixture ID</th>
<th field="mode_id" width="10%" align="right" editor:{
type:'combobox',
options:{
url:'mode_id_select.php',
valueField:'fixture_id',
required:true
}
}
}, >Mode</th>
<th field="dmx_univ" width="10%" align="right" sortable="true" editor="text">Universe</th>
And the following PHP file:
<?php
require ('../Inx/mysqli_project.php');
$items = array();
$fixture_id = isset($_POST['fixture_id'])
$sql = "SELECT mode_id FROM fixture_details WHERE fixture_id = '$fixture_id'";
$result = $con->query($sql);
if ($result->num_rows > 0)
{
// output data of each row
while($row = $result->fetch_assoc())
array_push($items, $row);
}
echo json_encode($items);
?>
Basically to run the SQL statement I need to use the fixture_id value from the same row. So somehow I need to send that across to the PHP file. Can someone help me with doing this please?
Thanks,
Andy