image upload to server directory with reference in mysql column

[admundsen]

Hi,
I am having trouble uploading images to a directory on a server with a corresponding reference in my mysql table column.
Am using the following code to move the file:
####################
if( strlen( $userfile ) > 1 ) {
$hasAnImage = 1;
$imageType = strstr( $_FILES['userfile' ['name'], '.' );
$NicknameImage = $Nickname . $imageType;

move_uploaded_file($HTTP_POST_FILES['userfile']['tmp_name'], $userImageDir .'/'. $NicknameImage);

}
##################
my table column is 'image TINYINT(1)'.

Any suggestions on perhaps a more trivual/different approach would be most welcome.
Cheers.

 

[sleipnir214]

image tinyint?

Don't you want to store the name of the file, which would predicate the use of a varchar or char column?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!