RE: [PHP-DB] Convert String to Array

Is it possible for you to store the vehMdlCd array as a serialized field in your database? I'm not sure how your data is structured, but you would serialize() your data on the way into the db then unserialize() it when you select it. When it's unserialized, you'll get it back in the original

[PHP-DB] PHP Forms - upload VS text

Hi, I'm a fairlly experienced developer but there's something that just really gets to me... I can: - Use a form to upload a file or files - Use a form to write text to whaever is needed (DB, e-mail contents, etc...) but I CAN'T - Use the same form to do both. I've tried so many

RE: [PHP-DB] Convert String to Array

Are you sure you even want to be storing it that way? What happens when you delete the following row? Do you have to re-index each column? There's no (trivially) easy way to do that with an update statement as it stands. vehMdlCd[1] LEX You're likely better off storing it simply as

Re: [PHP-DB] Convert String to Array

At 12:22 AM 9/30/2005, Ng Hwee Hwee wrote: Hi guys, this looks like a very simple problem but i really have no idea how to do it.. please help me! thanks! my MySQL database has a table of which 2 fields are as follow T100FieldNmT100Value == = vehMdlCd[0]

RE: [PHP-DB] PHP Forms - upload VS text

form action=?php tpl($_SERVER['REQUEST_URI']) ? method=post enctype=multipart/form-data Beyond that it's just the $_FILES array and $_POST array. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not

Re: [PHP-DB] Connecting to two MySQL databases

Hi Charles, I had this problem a while ago, when you try to create the second connection to the database with the same login credentials, i.e username and password. If mysql / php detect there is a connection already established with those details it will return that specfic resouce and not

Re: [PHP-DB] PHP Forms - upload VS text

Humm.. in the form action you use a function called tpl(); What function is that, I find no reference of it on the php.net function list. - Original Message - From: Norland, Martin [EMAIL PROTECTED] Newsgroups: php.db To: php-db@lists.php.net Sent: Friday, September 30, 2005 3:36

Re: [PHP-DB] joining tables in postgres

On Thu, 2005-09-29 at 19:51 -0300, Miles Thompson wrote: At 04:13 PM 9/29/2005, redhat wrote: anyone know of any good tutorials on simple joining of tables in Postgres using PHP? I did some Googling and didn't find anything satisfactory. thanks, Doug -- PHP Database Mailing List

Re: [PHP-DB] Connecting to two MySQL databases

I had this problem a while ago, when you try to create the second connection to the database with the same login credentials, i.e username and password. If mysql / php detect there is a connection already established with those details it will return that specfic resouce and not create an

[PHP-DB] Trouble with conections between php and postgre

Hi !, first of all: sorry about my english, i'm not from us. I 'm using latest versions of postgre 7.4 with php4 and apache2, on a debian system. I'm working with a really big database, so there are many querys that takes too much time to be executed that blocks the php page that's being loaded.

RE: [PHP-DB] PHP Forms - upload VS text

Ahh, ignore that - our tpl() is an echo() replacement that our codebase has, which can take parameters to do fun things. There's no logical reason to use it in this place, except it's shorter to type than echo, and it's habit. Wiz 'o Oz Pay no attention to the man behind the curtain. :)

[PHP-DB] Email Article, Print Article

Hello, I am running an article-based site, where I would like to add two buttons: print this article and email this article. Does anyone know where I could look to find out how to program this code into my article.php page? Thanks in advance, Eddie Wonder

RE: [PHP-DB] Email Article, Print Article

Sure, not that hard...the usual trick with printing is to add this button input type='button' value='print' onclick='window.print();' To email it, I would add a button that has a link to the article (like the id reference no) and then with the onlclick open a small window with the form to add

Re: [PHP-DB] Email Article, Print Article

No, but it's pretty straightforward, just have each link to another script along with a get variable that defines which article (assuming they're in a database or something) email_article.php?article=$articleID print_article.php?article=$articleID email_article.php: (pseudo code) ?php //

Re: [PHP-DB] Email Article, Print Article

Thank you Bastian and Micah. I had no idea the concept was so straightforward. I guess I was close to making a mountain out of a molehill. Thanks again, E. Wonder

[PHP-DB] More random RAND() in MYSQL

The ORDER BY RAND() function is not incredibly random Is there some way to make RAND() a bit more spontaneous ? $sql = SELECT media.id, artist.name as artist, artist.spanish as bio, artist.purchaseLink, artist.picture,