Help with adding an id from one table to another

[average american]

i will just start this off with the obvious.  i am new to php and in turn this may be a simple question...

 

I am having a problem taking the id (which is set to auto incroment) and taking that info and putting it into another table to be able to retrieve the row(s) that will be associated with the first table.

 

Making any scence?

 

this is my code now...

 

<?php

 

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)

{

$fileName = $_FILES['userfile']['name'];

$tmpName  = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

 

$fp      = fopen($tmpName, 'r');

$content = fread($fp, filesize($tmpName));

$content = addslashes($content);

fclose($fp);

 

if(!get_magic_quotes_gpc())

{

    $fileName = addslashes($fileName);

}

 

$dbhost = "DELETED FOR SECURITY";

$dbuser = "DELETED FOR SECURITY";

$dbpassword = "DELETED FOR SECURITY";

$dbdatabase = "DELETED FOR SECURITY";

 

$db = mysql_connect($dbhost, $dbuser, $dbpassword);

mysql_select_db($dbdatabase, $db);

 

mysql_query("LOCK TABLES listings, images WRITE");

 

mysql_query("INSERT INTO images (name, size, type, content ) ".

"VALUES ('$fileName', '$fileSize', '$fileType', '$content')");

$result = mysql_query("SELECT MAX(ID) AS LAST_ID FROM listings");

 

$id = mysql_fetch_array($result);

mysql_query("UNLOCK TABLES");

 

echo "Last ID#" . $id[LAST_ID];

 

echo "<br>File $fileName uploaded<br>";

}

?>

<form method="post" enctype="multipart/form-data">

<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">

<tr>

<td width="246">

<input type="hidden" name="MAX_FILE_SIZE" value="2000000">

<input name="userfile" type="file" id="userfile">

</td>

<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>

</tr>

</table>

</form>

 

Just a  little background.  I can upload the info to the database from both forms i just can not seem to figure out why the id from listings will not get inputted into images.listing_id

 

 

all help greatly appreciated

[BlueSkyIS]

change this

 

$id = mysql_fetch_array($result);

 

to this

 

$id = mysql_insert_id();

[average american]

Thanks for the rapid response.

 

I just tried that and it didn't work either :-\

 

is there something i am missing maybe it the input area (where the data is being put into the database)??

 

like i said this is all new to me i am learning as i go.

[BlueSkyIS]

also, $id will not be an array, it will be the numeric id.

 

echo "Last ID#" . $id[LAST_ID];

 

should be

 

echo "Last ID#" . $id;

[corbin]

mysql_query("INSERT INTO images (name, size, type, content ) ".

"VALUES ('$fileName', '$fileSize', '$fileType', '$content')");

$result = mysql_query("SELECT MAX(ID) AS LAST_ID FROM listings");

 

 

You could try:

 

mysql_query("INSERT INTO images (name, size, type, content ) ".

"VALUES ('$fileName', '$fileSize', '$fileType', '$content')");

$result = mysql_insert_id();

 

 

And then result would contain the ID, thus no call such as fetch_array would be necessary.

[average american]

fixed that little spot thanks that was my next question, but the original problem is still there.  I don't have the primary id from the listings table inserted into the listing_id of the images table????

 

any other suggestions(fixes)?

???

[corbin]

You mean how do you insert that value into the other table?

 

mysql_query("INSERT INTO table VALUES ('{$result}')");