Ok here is my problem and where I am at this far, first thing I needed to do
is to read the contents of a directory and place the results into a select
box in a form (accomplished), now where I am stuck is passing the selection
from said select box to another script so it may be put into a mysql
jas,
Ya didn't do what I told you to do. Now, do this:
SELECT NAME=\files\;
$sql = UPDATE $table_name SET file_name=\$files\;
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Stuck on db entry from
I had a typo:
$sql = UPDATE $table_name SET file_name=\$files\;
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:29 PM
To: 'Jas'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Stuck on db entry from select box...
jas,
Ya didn't do what I told
Ok I made the changes you suggested and unfortunately I am getting the same
results... Could not execute query, I manually put entries into the tables
so that the update command would just overwrite the current contents. Here
is my code this far, I think my problem (correct me if I am wrong)
Upon doing a print $sql before the mysql_querie I get this output;
UPDATE cm_index SET ad01_t=$filesCould not execute query. Please try again
later
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I got it to work like this.. I don't know if you didn't want to use INSERT
or something but it sticks the filename in the database table for me..
?php
$dir_name = /home/httpd/html/database/images;
$dir = opendir($dir_name);
$file_list .= pFORM METHOD=\post\ ACTION=\$PHP_SELF\
SELECT
successfully.brbr\n );
echo( a href=\javascript:history.back();\Add another file?/a );
}
?
Later,
Bob
- Original Message -
From: Bob [EMAIL PROTECTED]
To: jas [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 5:43 PM
Subject: RE: [PHP-DB] Stuck on db entry from select
7:44 PM
Subject: Re: [PHP-DB] Stuck on db entry from select box...
Okay, so I figured out why you might want to use UPDATE instead of SELECT.
And I also found that no matter what I tried, UPDATE doesn't seem to be
able
to UPDATE a table if there are no rows in it.. Otherwise it works fine..
So