Re: [PHP] Appending url to file name...

2002-04-08 Thread Erik Price
On Monday, April 8, 2002, at 11:09 AM, Jas wrote: Ok this is an unusual problem, at least to a newbie like myself... I am trying to develop a user form to select an image from a directory by use of a select box that once the item is selected it will put that selection into a db field

Re: [PHP] Appending url to file name...

2002-04-08 Thread Jas
So putting it into an UPDATE statement it would be something like this right? UPDATE CONCAT $table_name SET ('http://localhost/images') ad01=\$ad01\; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Appending url to file name...

2002-04-08 Thread Erik Price
On Monday, April 8, 2002, at 11:35 AM, Jas wrote: So putting it into an UPDATE statement it would be something like this right? UPDATE CONCAT $table_name SET ('http://localhost/images') ad01=\$ad01\; No, like this: The table is named test_table The column you want to add this to is

Re: [PHP] Appending url to file name...

2002-04-08 Thread Jas
Actually, I tried it a different way and I got the results I needed... this is what I did, $file_var = http://www.bignickel.net/full_ad/;; $db_name = db_name; $table_name = table_name; $connection = mysql_connect(localhost, user_name, password) or die (Could not connect to database. Please try

Re: [PHP] Appending url to file name...

2002-04-08 Thread Miguel Cruz
On Mon, 8 Apr 2002, Jas wrote: $sql = UPDATE $table_name SET ad01_t=\$file_var$files\; Is this really what you wanted? It would set ad01_t to the same thing for every single row in your table. If that is what you wanted, then I think your database design is a little weird. miguel -- PHP