Insert Comma Separated Values into MYSQL + Additional Form Data

Question

I have a form that allows users to tag an image, choose a location from a drop-down, & upload the image. The tagging takes place by allowing multiple values, separated by commas, to be entered into a field.

This code is successfully inputting the comma delimited list to individual rows:

    $categories = $_POST['bib'];
    $categories = explode(",", $categories);
    foreach($categories as $category) {
    $category = trim($category); // Remove possible whitespace
    $sql = "INSERT INTO athletes (bib) VALUES ('%s')";
    $sql = sprintf($sql, mysql_real_escape_string($category));
    mysql_query($sql);
    }

However, it is not adding the additional content (location from drop-down list & image filename). For query purposes I need to be able to use both the 'bib' tag and the 'location' to be attached to images to allow users to search.

Before implementing the comma-separated option, this code was working to insert all of the data:

 mysql_query("INSERT INTO `athletes` VALUES ('$id', '$bib', '$race','$new_file_name')") ;

So, basically I'm trying to merge the functionality of the two.

JohnD · Accepted Answer · 2011-09-18 18:07:18Z

1

You need to use MySQL's UPDATE statement to update data in an existing row.

answered Sep 18, 2011 at 18:07

JohnD

4,0121 gold badge30 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Comma Separated Values into MYSQL + Additional Form Data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related