On Friday 25 January 2002 17:35, Will Hives wrote:
> Sorry for my past ignorance using this news site forum I can only out this
> down to my lack of knowledge.
>
> I have been work on me first script for some time now and have been making
> good progress up until now. I have a script that adds a author to the
> database, ID, Name, Email, Picture Name.
>
> When a author is added it uploads their details plus it uploads and renames
> the image...that is working fine. It all falls down when I try and call the
> new file name to show the picture. It is uploading the original file name
> to the database and not the renamed version.
>
> I would be very grateful for any pointers on how this small problem can be
> solved. I hope this makes more sense than previous threads I have
> submitted.
>
> Cheers
> Will
>
> Here is the script as it stands:
>
> $sql = "INSERT INTO $table_name (id, name, email, picture_name)
> VALUES ('$id', '$name', '$email', '$picture_name') ";
>
> $result = @mysql_query($sql, $connection) or die ("couldn't execute
> query");
>
> if ($picture != "") {
>
> $path = "/home/main/main/php/";
> $datee = date("sdFy");
> move_uploaded_file($picture,$path . $datee . $picture_name);
>
> }
Is this the *full* script? I don't see where you are setting $picture_name?
Also what you are inserting into the database is not the same as what you are
renaming your file to (you're adding a date string to the filename). Do you
have a procedure to resolve the correct filename when retrieving the data
from the db?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
All of life is a blur of Republicans and meat!
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
