hi, I'm having trouble posting multiple form fields in an sql db.
for one field 'name', I use:
$query = "INSERT INTO new_table (`name`) VALUES ('" . $system->cleanvars($_POST['name']) . "')";
$system->check_mysql(mysql_query
($query)
, $query, __LINE__, __FILE__);
now if I have multiple fields (name, email, phone) for new_table, how would I get them all in the same entry?
if I just repeat the above code for each different field, it separates each field individually into a different row...no good.
for one field 'name', I use:
$query = "INSERT INTO new_table (`name`) VALUES ('" . $system->cleanvars($_POST['name']) . "')";
$system->check_mysql(mysql_query
($query)
, $query, __LINE__, __FILE__);
now if I have multiple fields (name, email, phone) for new_table, how would I get them all in the same entry?
if I just repeat the above code for each different field, it separates each field individually into a different row...no good.