INSERT Question

seco

Im not entirely sure how to go about this, so here goes.

We will say this is a image uploading script.

I want the ability to add multiple image names to one field seperated by a comma.

But whenever i decide to add a new img it will insert a comma then another image name. like so

i add a image.

1.jpg

i come back another time and add another image, it inserts it into the same field and does this

1.jpg, 2.jpg

ect..

what would this be called or can anyone point me in the right direction. thanks in advance.

coldwerturkey

$row = mysql_fetch_array(mysql_query("SELECT * FROM table WHERE ... LIMIT 1"));

$new = mysql_real_escape_string($row['value'] . ", " . $_POST['value']);

mysql_query("UPDATE table SET value = '{$new}' WHERE ... ");

djjjozsi

lets create an images table, you store the location to the file, and store the type, size,

image table:
image_id (Primary Key)

file_name this is the physically name of your file.
file_type
file_size

Lets create another table, called, image_names

It will have: image_names table
name_id (Primary Key)
image_id (Foreign Key, this is the relation to the images table)
Name

How you populate the multiple names? Lets create the field for the file upload, and use a Names textfield to get the names using a comma separator.

Then insert the file location to the image table, you will have the image_id then,
lets explode the File_Name field (search on the syntax explode on php.net)

Then insert the image_id And the exploded Names into new rows to the image_names table.

When you list the images, use a link (INNER JOIN) to the image_names table:

SELECT * FROM   image INNER JOIN image_names ON image_names.image_id=image.image_id;

Hello, jjozsi.

bradgrafelman

djjjozsi's suggestion is the best one in this situation; storing multiple values in a single column is often a very large warning sign that your database design is poor/unoptimized/harder to work with.

coldwerturkey

bradgrafelman;10902298 wrote:
djjjozsi's suggestion is the best one in this situation; storing multiple values in a single column is often a very large warning sign that your database design is poor/unoptimized/harder to work with.

for the record: I agree 100%,

bradgrafelman

Didn't mean to put you down or anything coldwerturkey; you indeed answered the OP's original question (although it might be optimized to one line of code:

mysql_query("UPDATE table SET value = CONCAT(value, ', " . mysql_real_escape_string($_POST['value']) . "') WHERE ... ");

); sometimes, however, the answer to a question is a different question (e.g. how to go about it a different way). :p

coldwerturkey

once again, I took the long root to solve a rather simple problem. That's what I love about this forum though, you learn so much just from viewing the solutions to other peoples questions.

seco

bradgrafelman;10902298 wrote:
djjjozsi's suggestion is the best one in this situation; storing multiple values in a single column is often a very large warning sign that your database design is poor/unoptimized/harder to work with.

I dont think its a poor design, im just trying somthing new.
Thanks everyone thats helping, im trying everything suggested, ill see what works.

bradgrafelman

I only labeled it as poor since some may view it as such since it violates even the first normal form.

seco

i completly understand. its just an idea though. instead of grabbing the names from 10 rows it just strips the names from 1 row. kinda like tags

djjjozsi

seco;10902372 wrote:
kinda like tags

A tag engine works the same 🙂

seco

djjjozsi;10902413 wrote:
A tag engine works the same 🙂

ill have to look into that.