Re: spam>[PHP-DB] Remove
Yes, just send an e-mail to "php-db+unsubscr...@lists.php.net" I imagine it will ask for confirmation. From: Kevin McColl Sent: March 12, 2024 10:53 AM To: php-db@lists.php.net Subject: spam>[PHP-DB] Remove Is there a way to stop or remove receiving these emails?
[PHP-DB] Remove
Is there a way to stop or remove receiving these emails?
RE: [PHP-DB] Remove newlines from field
-Original Message- From: Ludvig Ericson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 5:54 PM To: Giff Hammar Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Remove newlines from field Mind you Pearl programmers, what would that do? [snip] It changes the end of line delimiter to match the platform that you're on (\r\n for Windows, \r for Mac and \n for Unix/Linux). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remove newlines from field
-Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 6:17 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Remove newlines from field tops snipped At 04:00 PM 3/20/2006, you wrote: I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ http://www.certifiedparts.com/ http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 Giff, Are you inserting back into the FoxPro table? I had to use the following to clean up text, cut and pasted from WPfor Windows 5.2, into a textarea. Immediately before the INSERT I also used PHP's addslashes(). The database is MySQL. // have to clean up the extraneous CR/LF combos $trupara= .\r\n; // period+CR+LF $dblquotpara= ''.\r\n; // double quote+CR+LF $sglquotpara= '.\r\n; // single quote+CR+LF $questnpara = ?\r\n; // question+CR+LF $exclampara = !\r\n; // exclamation+CR+LF $colonpara = :\r\n; // exclamation+CR+LF $dudspc = . \r\n; // period+spc+CR+LF $flspara= \r\n; //CR+LF $truflag= ***; //something unique $txtBody = str_replace ( $trupara, $truflag, $txtBody); $txtBody = str_replace ( $dblquotpara, $$$, $txtBody); $txtBody = str_replace ( $sglquotpara, %%%, $txtBody); $txtBody = str_replace ( $questnpara, +++, $txtBody); $txtBody = str_replace ( $exclampara, !!!, $txtBody); $txtBody = str_replace ( $colonpara, :::, $txtBody); $txtBody = str_replace ( $dudspc, ###, $txtBody); $txtBody = str_replace ( $flspara, , $txtBody); $txtBody = str_replace ( $truflag, .\n\n, $txtBody); ///double quote $txtBody = str_replace ( $$$, '\n', $txtBody); ///single quote $txtBody = str_replace ( %%%, '\n, $txtBody); ///question mark $txtBody = str_replace ( +++, '?\n', $txtBody); ///exclamation mark $txtBody = str_replace ( !!!, '!\n', $txtBody); ///colon $txtBody = str_replace ( :::, ':\n', $txtBody); ///dudspace $txtBody = str_replace ( ###, '.\n\n', $txtBody); $txtBody = str_replace ( \n , \n, $txtBody); Hope this is helpful - Miles PS Policy on this list is to bottom post. Thanks for the help! A combination of this and the nl2br finally solved the problem and allowed me to process the update to the database. Now it's on the figuring out why VFP doesn't accept \ to escape special characters Giff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Remove newlines from field
I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163
RE: [PHP-DB] Remove newlines from field
see the nl2br function in the manual (www.php.net/nl2br) bastien From: Giff Hammar [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Remove newlines from field Date: Mon, 20 Mar 2006 17:00:49 -0500 I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remove newlines from field
Thanks, Jeremy and Bastien. I just tried nl2br and it has the unfortunate side effect of losing everything except the most recently added data when I update the database. I think I need something like the 'local $/ = \r\n' construct in perl... Giff _ From: Jeremy Peterson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 5:14 PM To: Giff Hammar Subject: Re: [PHP-DB] Remove newlines from field Try nl2br. http://php.net/nl2br At 04:00 PM 3/20/2006, you wrote: I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ http://www.certifiedparts.com/ http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 Jeremy Peterson, MACS Automation Systems Administrator Crowell Library Moody Bible Institute 820 N. LaSalle Drive Chicago, IL, 60610 Email:[EMAIL PROTECTED] Phone: 312.329.8081 Fax: 312.329.8959
Re: [PHP-DB] Remove newlines from field
Mind you Pearl programmers, what would that do? On 3/20/06, Giff Hammar [EMAIL PROTECTED] wrote: Thanks, Jeremy and Bastien. I just tried nl2br and it has the unfortunate side effect of losing everything except the most recently added data when I update the database. I think I need something like the 'local $/ = \r\n' construct in perl... Giff _ From: Jeremy Peterson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 5:14 PM To: Giff Hammar Subject: Re: [PHP-DB] Remove newlines from field Try nl2br. http://php.net/nl2br At 04:00 PM 3/20/2006, you wrote: I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ http://www.certifiedparts.com/ http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 Jeremy Peterson, MACS Automation Systems Administrator Crowell Library Moody Bible Institute 820 N. LaSalle Drive Chicago, IL, 60610 Email:[EMAIL PROTECTED] Phone: 312.329.8081 Fax: 312.329.8959 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remove newlines from field
tops snipped At 04:00 PM 3/20/2006, you wrote: I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an unrecognized command because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com http://www.certifiedparts.com/ http://www.certifiedparts.com/ http://www.certifiedparts.com/ mailto: [EMAIL PROTECTED] V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 Giff, Are you inserting back into the FoxPro table? I had to use the following to clean up text, cut and pasted from WPfor Windows 5.2, into a textarea. Immediately before the INSERT I also used PHP's addslashes(). The database is MySQL. // have to clean up the extraneous CR/LF combos $trupara= .\r\n; // period+CR+LF $dblquotpara= ''.\r\n; // double quote+CR+LF $sglquotpara= '.\r\n; // single quote+CR+LF $questnpara = ?\r\n; // question+CR+LF $exclampara = !\r\n; // exclamation+CR+LF $colonpara = :\r\n; // exclamation+CR+LF $dudspc = . \r\n; // period+spc+CR+LF $flspara= \r\n; //CR+LF $truflag= ***; //something unique $txtBody = str_replace ( $trupara, $truflag, $txtBody); $txtBody = str_replace ( $dblquotpara, $$$, $txtBody); $txtBody = str_replace ( $sglquotpara, %%%, $txtBody); $txtBody = str_replace ( $questnpara, +++, $txtBody); $txtBody = str_replace ( $exclampara, !!!, $txtBody); $txtBody = str_replace ( $colonpara, :::, $txtBody); $txtBody = str_replace ( $dudspc, ###, $txtBody); $txtBody = str_replace ( $flspara, , $txtBody); $txtBody = str_replace ( $truflag, .\n\n, $txtBody); ///double quote $txtBody = str_replace ( $$$, '\n', $txtBody); ///single quote $txtBody = str_replace ( %%%, '\n, $txtBody); ///question mark $txtBody = str_replace ( +++, '?\n', $txtBody); ///exclamation mark $txtBody = str_replace ( !!!, '!\n', $txtBody); ///colon $txtBody = str_replace ( :::, ':\n', $txtBody); ///dudspace $txtBody = str_replace ( ###, '.\n\n', $txtBody); $txtBody = str_replace ( \n , \n, $txtBody); Hope this is helpful - Miles PS Policy on this list is to bottom post. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remove newlines from field
At 07:17 PM 3/20/2006, Miles Thompson wrote: tops snipped Forgot to add that the writers work in WP 5.2 for Windows, because it has an excellent indexing function which enables them to locate back stories v. quickly. That text is cut and pasted into an HTML textarea, which is saved to a MySQL database. nl2br() is also applied to the text before saving. The idea is to get straight HTML into the database. For display the text is fetched, stripslash()'d and fed as an XML stream to an HTMLText control in a Flash movie. Quirks in how the movie displayed the text, resulted in some of the constructs that had to be detected and removed. Same thing, occasionally, in the textarea. So this may not be the ideal solution, but it works for us. Cheers - Miles -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove MySQL Server
1. Run Regedit or regedt32. 2. Find the registry entry: |HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services| 3. Find the service there and delete it. 4. reboot W Roothman wrote: Dear All, Anyone knows how to remove the MySQL server from XP under 'Services'? No option to delete or uninstall. R's, Will __ NOD32 1.1262 (20051020) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove MySQL Server
You can also run this, that is if you haven't manually removed your mysql installation directory c:\mysqld --remove service name ,where service name is usually MySQL Unnawut Leepaisalsuwanna wrote: 1. Run Regedit or regedt32. 2. Find the registry entry: |HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services| 3. Find the service there and delete it. 4. reboot W Roothman wrote: Dear All, Anyone knows how to remove the MySQL server from XP under 'Services'? No option to delete or uninstall. R's, Will __ NOD32 1.1262 (20051020) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Remove MySQL Server
Dear All, Anyone knows how to remove the MySQL server from XP under 'Services'? No option to delete or uninstall. R's, Will
[PHP-DB] Remove white space?
I am pulling data from a MySQL DB and I need to remove the whitespace on
the variable and turn it to lowercase.
! Code Snippet
$get_items = select * from PFS_items;
$get_items_res = mysql_query($get_items) or die(mysql_error());
while ($items = mysql_fetch_array($get_items_res))
{
$item_id = $items[id];
$item_num = $items[item_num];
! End Code Snippet
Overtime I need to rewrite my DB loading script to handle this for me,
but right now I need to band-aid it so that I can auto-generate pages
and get them loaded into a catalog.
Thanks!
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remove white space?
Robert,
ltrim() or rtrim() to get rid of the whitespace if it's at the beginning or
end of the data.
strtolower() to turn the string into all lowercase characters.
Rich
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 10:51 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Remove white space?
I am pulling data from a MySQL DB and I need to remove the
whitespace on
the variable and turn it to lowercase.
! Code Snippet
$get_items = select * from PFS_items;
$get_items_res = mysql_query($get_items) or die(mysql_error());
while ($items = mysql_fetch_array($get_items_res))
{
$item_id = $items[id];
$item_num = $items[item_num];
! End Code Snippet
Overtime I need to rewrite my DB loading script to handle this for me,
but right now I need to band-aid it so that I can auto-generate pages
and get them loaded into a catalog.
Thanks!
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove white space?
1. Don't cross-post!
2. Read the string functions in the php manual. You probably don't want to
remove all white space, just trim. Have a look at
http://ca3.php.net/manual/en/function.trim.php
3. You will find a function to do exactly what you want.
Regards - Miles Thompson
At 10:51 AM 4/22/2004 -0400, Robert Sossomon wrote:
I am pulling data from a MySQL DB and I need to remove the whitespace on
the variable and turn it to lowercase.
! Code Snippet
$get_items = select * from PFS_items;
$get_items_res = mysql_query($get_items) or die(mysql_error());
while ($items = mysql_fetch_array($get_items_res))
{
$item_id = $items[id];
$item_num = $items[item_num];
! End Code Snippet
Overtime I need to rewrite my DB loading script to handle this for me,
but right now I need to band-aid it so that I can auto-generate pages
and get them loaded into a catalog.
Thanks!
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Remove log files in Postgres
Hi all, does any one know a configuration parameter or command line that automatically remove in a period of time the log files in postresql database? Thanks a lot. Norma Ramirez
Re: [PHP-DB] Remove all instances of a character....
Tried that but I got an error when using PHPMyAdmin... UPDATE risk_corpdatacapture email = REPLACE(email,';','') just don't work??? Wll confused now, cuase that's what I tried before I posted to the list... and you guys say it should work too... Any other ideas? = Error SQL-query : UPDATE risk_corpdatacapture email = REPLACE ( email, ';', '' ) MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '= REPLACE ( email, ';', '' )' at line 1 == CPT John W. Holmes [EMAIL PROTECTED] 24/12/2003 13:27 Please respond to CPT John W. Holmes [EMAIL PROTECTED] To [EMAIL PROTECTED], [EMAIL PROTECTED] cc Subject Re: [PHP-DB] Remove all instances of a character From: [EMAIL PROTECTED] I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. UPDATE TABLE SET column = REPLACE(column,' ; ','') Reminder: This is a PHP list... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. ***
RE: [PHP-DB] Remove all instances of a character....
Does the ; need a backslash? UPDATE risk_corpdatacapture email = REPLACE(email,'\;','') Not sure but might be worth a try (back it up first!!) Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 December 2003 10:17 To: CPT John W. Holmes Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Remove all instances of a character Tried that but I got an error when using PHPMyAdmin... UPDATE risk_corpdatacapture email = REPLACE(email,';','') just don't work??? Wll confused now, cuase that's what I tried before I posted to the list... and you guys say it should work too... Any other ideas? = Error SQL-query : UPDATE risk_corpdatacapture email = REPLACE ( email, ';', '' ) MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '= REPLACE ( email, ';', '' )' at line 1 == CPT John W. Holmes [EMAIL PROTECTED] 24/12/2003 13:27 Please respond to CPT John W. Holmes [EMAIL PROTECTED] To [EMAIL PROTECTED], [EMAIL PROTECTED] cc Subject Re: [PHP-DB] Remove all instances of a character From: [EMAIL PROTECTED] I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. UPDATE TABLE SET column = REPLACE(column,' ; ','') Reminder: This is a PHP list... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove all instances of a character....
[EMAIL PROTECTED] wrote: Tried that but I got an error when using PHPMyAdmin... UPDATE risk_corpdatacapture email = REPLACE(email,';','') just don't work??? You're missing SET... UPDATE risk_corpdatacapture SET email = REPLACE(email,';',''); -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove all instances of a character....
THAT'S IT!!! Sweet... Xmas hangover be damned... got there in the end..! Cheers everyone, happy new year!!! John W. Holmes [EMAIL PROTECTED] 29/12/2003 13:11 Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: [PHP-DB] Remove all instances of a character [EMAIL PROTECTED] wrote: Tried that but I got an error when using PHPMyAdmin... UPDATE risk_corpdatacapture email = REPLACE(email,';','') just don't work??? You're missing SET... UPDATE risk_corpdatacapture SET email = REPLACE(email,';',''); -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. ***
[PHP-DB] Remove all instances of a character....
I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. I'll run along to google now, and mysql.org, but it's xmas eve, and I'm feeling lazy.. ;-) Cheers, Tris... * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. ***
Re: [PHP-DB] Remove all instances of a character....
Try this : mysql_query(DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'); Saygilarla, Muhammed Mamedov - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 1:12 PM Subject: [PHP-DB] Remove all instances of a character I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. I'll run along to google now, and mysql.org, but it's xmas eve, and I'm feeling lazy.. ;-) Cheers, Tris... * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove all instances of a character....
From: [EMAIL PROTECTED] I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. UPDATE TABLE SET column = REPLACE(column,' ; ','') Reminder: This is a PHP list... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] REMOVE ME
Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL table on server A from server B? 30898 by: ramki 30900 by: Cesar Schneider My SQL update one table, using reference from another... 30899 by: Tristan.Pretty.risk.sungard.com Re: support to palm db 30901 by: Cesar Schneider mysql_error() returning nothing 30902 by: Ben Edwards 30904 by: Ben Edwards PHP APACHE Database 30903 by: Paul Ciba Problem with uploadscript 30905 by: Ruprecht Helms 30906 by: George Patterson Php433 running on RedHat73 with support to OCI8 30907 by: Adriano Rocha Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] REMOVE ME
go to news.php.net and subscribe your self. On 9 Oct 2003 at 15:47, Muzzamil wrote: Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL table on server A from server B? 30898 by: ramki 30900 by: Cesar Schneider My SQL update one table, using reference from another... 30899 by: Tristan.Pretty.risk.sungard.com Re: support to palm db 30901 by: Cesar Schneider mysql_error() returning nothing 30902 by: Ben Edwards 30904 by: Ben Edwards PHP APACHE Database 30903 by: Paul Ciba Problem with uploadscript 30905 by: Ruprecht Helms 30906 by: George Patterson Php433 running on RedHat73 with support to OCI8 30907 by: Adriano Rocha Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] REMOVE ME
http://www.php.net/mailing-lists.php even On 9 Oct 2003 at 15:47, Muzzamil wrote: Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL table on server A from server B? 30898 by: ramki 30900 by: Cesar Schneider My SQL update one table, using reference from another... 30899 by: Tristan.Pretty.risk.sungard.com Re: support to palm db 30901 by: Cesar Schneider mysql_error() returning nothing 30902 by: Ben Edwards 30904 by: Ben Edwards PHP APACHE Database 30903 by: Paul Ciba Problem with uploadscript 30905 by: Ruprecht Helms 30906 by: George Patterson Php433 running on RedHat73 with support to OCI8 30907 by: Adriano Rocha Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] remove from db renumbering
Hi there everyone, I have my id field auto incrementing (Of course) and I have a utility that allows me to remove items from it, the problem is when I remove something the items after it keep their IDs leaving a gap in the ID. For example, say I have 1-10 in the ID field and I remove number 8, Ill have 1-7 and then 9-10, what I need is for 9-10 to go down to 8-9, how can I do this? Its really important as I have an ad-rotator system which gets the total number of fields from the DB and if there is an empty ID it causes there to be an invalid image appear (Of course). So all I need is to renumber the ID field after a delete I guess, but how? Any help would be extremely grateful :-) Thanks Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002
Re: [PHP-DB] remove from db renumbering
On Sun, 30 Jun 2002 20:21:18 -0400 Chris Payne Chris Payne [EMAIL PROTECTED] wrote: Hi there everyone, I have my id field auto incrementing (Of course) and I have a utility that allows me to remove items from it, the problem is when I remove something the items after it keep their IDs leaving a gap in the ID. For example, say I have 1-10 in the ID field and I remove number 8, Ill have 1-7 and then 9-10, what I need is for 9-10 to go down to 8-9, how can I do this? Its really important as I have an ad-rotator system which gets the total number of fields from the DB and if there is an empty ID it causes there to be an invalid image appear (Of course). So all I need is to renumber the ID field after a delete I guess, but how? Any help would be extremely grateful :-) Thanks Chris If all you want to do is to get a record count, why not SELECT COUNT(*) AS recs FROM datatable -- Raquel Above all things, never be afraid. The enemy who forces you to retreat is himself afraid of you at that very moment. --Andre Maurois -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
