[SOLVED] Add image to row

[l17wnj]

I am using mysql4.0

 

I am trying to create a gallery section for a website where users can create a new database and upload pictures. I have created the tables and the php script to create the new row and to edit existing rows. However i want the users to be able to insert up to fifty images in each row and uploading this on a single page would be impractical (timeout etc.). Is it possible to upload the images in smaller groups and assign them to the first available field.

 

Thanks

[corbin]

Why would you store 50 images in one row?  That doesn't make much sense.

 

 

What is your table schema?

[l17wnj]

This is for my local football club and they want anyone to be able to add their own images to the site so there may be thousands of images in the gallery eventually. I am trying create something similar to the galleries in social networking sites and i thought it would be easier to do it this way than creating a new table each time.

 

id (primary key)(auto increment)

date

name

image1

...

image50

description1

...

description50

[corbin]

Oh...  Errr...  Database normalization is your friend.  Google it.

 

 

A better way to do it would be like:

 

CREATE TABLE users (

  user_id int AUTO_INCREMENT PRIMARY KEY,

  --other fields

);

 

CREATE TABLE user_images (

    image_id int AUTO_INCREMENT PRIMARY_KEY,

    user_id int NOT NULL,

    image_path varchar(255) NOT NULL,

    description text

);

 

 

Then, users could have any number of images in user_images mapped back to their user by user_id.  (A 1 to many relationship.)

[l17wnj]

there won't be any user profiles on this site it is open to everyone so they can upload their own pictures of club events for all to see.

[l17wnj]

I have taken the recomendation to create a new table for each new gallery but i can't get a form to create a new table

 

if($_GET['mode'] == "add")

{

 

//////////////////////////////////add gallery to DB//////////////////////////////////////////

$sqldate = date("Ymd");

$name = $_POST['name'];

$sql3 = mysql_query("

CREATE TABLE $name (

  `pk` int(11) NOT NULL auto_increment,

  dateentered varchar(255) NOT NULL default '00000000',

  description text NOT NULL,

  image varchar(255) NOT NULL default 'noimage.gif',

  PRIMARY KEY  (`pk`)

) ") or die ( mysql_error() );

 

$sql2 = "INSERT INTO gallery VALUES ( '', '$sqldate', '$name'";

if ( @mysql_query($sql2) )

{

$msg = "Your have succesfully Created your new Gallery";

}else

{

$msg = mysql_error();

}

 

}?>

 

[fenway]

Why is your form making the table?