s" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 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
sql_query($sql, $connection);
$error = mysql_error();
if( eregi( "uplicate", $error ) ) echo( "Sorry, $files is already in the
database.\n" );
else echo( "$files added to database successfully.\n" );
echo( "Add another file?" );
}
?>
Later,
Bob
- Original Message
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..
$file_name";
while ($file_name = readdir($dir)) {
if (($file_name != ".") && ($file_name !="..")) {
$file_list .= "$file_name";
}
}
$file_lis
Upon doing a print $sql before the mysql_querie I get this output;
UPDATE cm_index SET ad01_t=$files"Could not execute query. Please try again
later
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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) lies
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 you to do. Now, do this:
";
$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
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
d