i would like to know if their is a different way of uploading data to a database im using insert into but its not working every time i try to upload something it creates a different row with email is their a way to uploading lots of data in the same row or even combining the data into one row. im creating shirts and the user is going to be able to upload new images for the shirt and giving them a name each time the user creates a shirt i want it to be unlimited shirts
$email=$_POST['email'];
$sql = "SELECT * from register_login WHERE email='$email'";
$result = $mysqli->query($sql);
if (!$result->num_rows == 1) {
echo "<p>Invalid email Address</p>";
} else {
require_once("configur.php");
$query='INSERT INTO shirt_table SET email="'.$_POST[email].'", title="'.$_POST[title].'", keywords="'.$_POST[keywords].'"';
if ($mysqli->query($query) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
$mysqli->close();
}</div>