i am try to run 2 query
`if (isset($_POST[‘updateEvent’])) {
# code…
$evetname = vlaidate($_POST[‘evetname’]);
$eventday = vlaidate($_POST[‘eventday’]);
$eventmonth = vlaidate($_POST[‘eventmonth’]);
$eventyear = vlaidate($_POST[‘eventyear’]);
$eventtime = vlaidate($_POST[‘eventtime’]);
$city = vlaidate($_POST[‘city’]);
$region = vlaidate($_POST[‘region’]);
$hotelevent = vlaidate($_POST[‘hotelevent’]);
$price = vlaidate($_POST[‘price’]);
$status = vlaidate($_POST[‘status’]);
$eventId = vlaidate($_POST[‘eventId’]);
$event= getById('tickets',$eventId);
if ($event['status' != 200]) {
# code...
redirect('events_edit.php?id='.$eventId,'No such id found');
}
if($evetname != '' || $eventday != '' ||$eventmonth != '' || $eventyear != '' || $eventtime != '' || $city != '' || $region != '' || $hotelevent != '' || $price != '' || $status != '' ){
$qury= "UPDATE tickets SET
ticketname='$evetname',
day='$eventday',
month='$eventmonth',
year='$eventyear',
time='$eventtime',
city='$city',
region='$region',
hotel='$hotelevent',
price='$price',
tickestats='$status' WHERE ticketid='$eventId'";
$result = mysqli_query($con,$qury);
$query2= "UPDATE ticketbooked t1 INNER JOIN tickets t2 ON t1.ticketid = t2.ticketid SET t1.ticketstats = t2.tickestats;";
$result2 = mysqli_multi_query($con,$qury2);
if ($result) {
redirect('events.php','User Updated successfully');
} else {
redirectwrong('user-create.php','Something is wrong');
}
}else{
redirectwrong('user-create.php','Please fill all the input fields');
}
}`
Mohamed Awny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1