[SOLVED] php script to perform mysql table insert

[Jago6060]

I'm trying to have my php script insert into 2 tables at once, it's for a picture database.  Is it actually possible to insert into 2 tables at once?  If so what would the sql statement look like.  If not, any suggestions would be a great help. Thanks!

[trq]

Is it actually possible to insert into 2 tables at once?

 

Not from within php. You'll need to execute two seperate queries.

[jaymc]

Of course

 

$querya = "INSERT QUERY HERE FOR TABLE 1";

$queryb = "INSERT QUERY HERE FOR TABLE 2";

 

mysql_query($querya);

mysql_query($queryb);

 

As for the query.. you will need to write that yourself

[Jago6060]

I tried doing two queries but it only executed the first query for some reason.

[trq]

Post your code.

[Jago6060]

$sql = "INSERT INTO feature_images (img_dir)values('$target_path')";
$result=mysql_query($sql);

 

This is the current code without trying to execute two insert statements.  I don't know if it matters but this code is within an upload loop

[trq]

Post the relevent code (that isn't working). We can't help if we can't see what your doing!

[jaymc]

If its in a loop...feature_images  needs to be a variable, it its static, its only ever going to insert to one table

 

Make $tablename dynamic in relation to what ever your loop is pullin out

 

$sql = "INSERT INTO $tablename (img_dir)values('$target_path')";

$result=mysql_query($sql);

[Jago6060]

<?
include 'connect.php';

// Where the file is going to be placed 
$target_path = "./uploads/images/";

/* Add the original filename to our target path.  
Result is "/uploads/images/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 
$_FILES['uploadedfile']['tmp_name'];  

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
    @mysql_select_db($database) or die( "Unable to select database");
    $sql = "INSERT INTO feature_images (img_dir)values('$target_path')";
    $result=mysql_query($sql);
    mysql_close();
    header ('Location: logout.php');
}else{
    echo "There was an error uploading the file, please try again!";
    echo "<a href=upload_feature_form.php>Back</a>";
}
?>

 

heres the full script

[jaymc]

Like I said, turn feature_images  into a variable which will contain your table name

 

Using the loop, it needs to switch from feature_images to your other table name

 

If it looks twice thats 2 seperate inserts into 2 seperate tables providing the table names have been set

[trq]

I don't see anywhere in that code where you attempt to make to consecutive queries. Also, you never actually check your query succeeds or not.

[Jago6060]

$feature = "feature_images";
$images = "crc_images";
$sql = "INSERT INTO $feature (img_dir)values('$target_path'),INSERT INTO $images (img_dir)values('$target_path')";
$result=mysql_query($sql);

 

would something like this work?

[jaymc]

No

 

Just stick with what you have, but copy and paste the query code and change the table name

 

Refer to my first post

 

Cant get much simpler

[Jago6060]

ok, sorry to be a pain but I just wanted to clarify this.  The format I should use is...

 

$feature = "feature_images";
$images = "crc_images";

$sql = "INSERT INTO $feature (img_dir)values('$target_path')";
$sql2 = "INSERT INTO $images (img_dir)values('$target_path')";

$result=mysql_query($sql);
$result=mysql_query($sql2);

 

right?

[jaymc]

Correct, if your not putting them in a loop, no need to even make them variables

 

I only said that because I thought it was in a loop

 

if your just placing it in the script, you can statically assign the table names to the query

 

No big deal though, what you have above will work fine

[Jago6060]

it works, thanks alot