RE: [PHP-DB] Re: send email

2003-11-27 Thread Jacob A. van Zanen
Hi This is PHP code and will be parsed by the webserver before being send out to the browser. All that is displayed in the browser is the non PHP stuff. So the email address is in the source code of the php page but when you click 'view source' in your browser you won't see it. Jack

[PHP-DB] Important notice

2003-11-27 Thread [EMAIL PROTECTED]
Important notice We have just charged your credit card for money laundry service in amount of $134.65 (because you are either child pornography webmaster or deal with dirty money, which require us to laundry them and then send to your checking account). If you feel this transaction was made

Re: [PHP-DB] a LITTLE bug with my CSV importer :-)

2003-11-27 Thread David T-G
Chris -- ...and then Chris Payne said... % % Hi there everyone, Hi! % % OK So I kind of have my CSV utility working nicely, except for one thing - if I import the file with PHPMyADMIN it imports over 1000 rows (Which is correct) but with the below code on the same file, it's only importing

[PHP-DB] Updating multilple tables?

2003-11-27 Thread Tristan . Pretty
I have scattered around about 100 tables a block of text... I wasn to serach through ALL my tables, and ALL my rows for this text, adn repalce it with another block of text. I've searched n google for mysql multiple table update But have yet to find an answer.. anyone know an easy way to do

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Miles Thompson
If you are searching in the same field (column) in each table, and the key field has the same name in all tables, build an array of table names and loop through it, executing your update on each iteration. Regards - Miles Thompson PS From your description it sounds as if you have a database

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Ignatius Reilly
One possible reason you did not google back anything is that what you are asking can't be done in SQL. In SQL you can update only one table at a time. Why not write a PHP function that does the job successively on each table? To list tables in MySQL: SHOW TABLES FROM database name HTH Ignatius

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Tristan . Pretty
All good, I've got a loop based on all my tables... (cheers for that) however, I still wanna look within an entry for a smaller entry.. EG: the quick brown frog jumped over the lazy dog I want to find and repace frog with fox but do this happens with text all over my database. I'll get

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Ignatius Reilly
In MySQL: UPDATE mytable SETmycol = REPLACE( mycol, $replacee, $replaceor ) All you have to do is provide the loop some structure so that it can find the column to process eg an array( table = array( column1, ... ) ) or even better another table. Ignatius _ -

[PHP-DB] Receiving a warning... no clue how to resolve it and need help badly :(

2003-11-27 Thread Aaron Wolski
Hi Guys, I need help with this code I am about to paste. It works on a testing server running PHP 4.2.2 but not 4.3.2 Here is the error: Warning: array_merge_recursive(): recursion detected in /services2/webpages/r/i/rinkrake.com/public/test.php on line 26 Here is the code: ?php echo

Re[2]: [PHP-DB] Empty Table command?

2003-11-27 Thread npguy
Hello Kim, beside deleting, dropping any tips to do this very quickly Friday, November 28, 2003, 1:37:20 AM, you wrote: KS As said yes, you just launch your old fashioned delete from statement, KS without KS any where clause, mySQL will interpret this as everything (which is infact KS what KS

[PHP-DB] select inside a while loop

2003-11-27 Thread Mike Baerwolf
Hello, I have two mysql tables songs and artists. They look like this: CREATE TABLE `artists` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(100) default NULL, `artist_img` varchar(50) default NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `artist_name`

[PHP-DB] RE: [PHP] Important notice

2003-11-27 Thread Nigel Jones
Just another reason why I think i'll just send the Un-Subscribe Email _ Nigel Jones [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 6:30 PM To: Php-general Subject: [PHP] Important notice