Code: Select all
document.getElementById('text').innerHTML += + fields +":<input name='extra_id[]' class='test' type='text' value='' /><br /><br />";Code: Select all
if(isset($_POST['save_changes'])) {
$bet_name = $_POST['bet_name'];
$time_date = $_POST['time_date'];
$bet_sp = $_POST['bet_sp'];
$event_url = $_POST['event_url'];
$sqlAddContent = "INSERT INTO bets (`id`, `bet_name`, `time_date`, `bet_sp`, `bookmaker_id`, `event_url`) VALUES ('$currentuser', '$bet_name', '$time_date', '$bet_sp', '$currentusername', '$event_url')";
mysql_query($sqlAddContent) or die (mysql_error());
header("Location: index.php");
} EDIT
I have just tried the following code, however I am getting an unexpected '}' error, just before the FIRST insert statement?
Code: Select all
if(isset($_POST['save_changes'])) {
foreach($_POST['extra_id'] as $value)
{
$insert="INSERT INTO bets (`extra_id`) VALUES ('$value')";
mysql_query($insert) OR die(mysql_error())
}
$bet_name = $_POST['bet_name'];
$time_date = $_POST['time_date'];
$bet_sp = $_POST['bet_sp'];
$event_url = $_POST['event_url'];
$sqlAddContent = "INSERT INTO bets (`id`, `bet_name`, `time_date`, `bet_sp`, `bookmaker_id`, `event_url`) VALUES ('$currentuser', '$bet_name', '$time_date', '$bet_sp', '$currentusername', '$event_url')";
mysql_query($sqlAddContent) or die (mysql_error());
header("Location: index.php");
} Thanks in advance!!!
Peter