[PHP-DB] Delete from mysql table is there a way to....

2002-04-14 Thread Jennifer Downey
Hi all, I'm not sure if my first post showed up so I am going to post it again and I apologize if it shows up twice. Is there a way to delete a record from a mysql table without fragmenting the db? Here is the query I am using and it does a horrible job. Fragment city. if ($quantity == 0) {

[PHP-DB] Delete from mysql table is there a way to....

2002-04-14 Thread Jennifer Downey
Hi all, Is there a way to delete a record from a mysql table without fragmenting the db? Here is the query I am using and it does a horrible job. Fragment city. if ($quantity == 0) { $gone = mysql_query("D

Re: [PHP-DB] Re: how to notify admin by e-mail only once if mysq

2002-04-14 Thread Ken Thompson
On Sunday 14 April 2002 03:24 pm, Ruprecht Helms wrote: > Hi Lisi, > > > Pardon my ignorance, but what's webmin? > > not a problem. Webmin is a webbased administrationtool > for different things to administrate. It begins from > useraccounting and ends by administration squid, apache, > postfix/qm

Re: [PHP-DB] Re: how to notify admin by e-mail only once if mysq

2002-04-14 Thread Ruprecht Helms
Hi Lisi, > Pardon my ignorance, but what's webmin? not a problem. Webmin is a webbased administrationtool for different things to administrate. It begins from useraccounting and ends by administration squid, apache, postfix/qmail, samba, and others. Regards, Ruprecht --

Re: [PHP-DB] Extracting the essence!

2002-04-14 Thread #Linux
Tanks so far, but if I want don't want to display the 1st and 4th line. - Original Message - From: "Lisi" <[EMAIL PROTECTED]> To: "#Linux" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 14, 2002 10:55 PM Subject: Re: [PHP-DB] Extracting the essence! > > >Try something li

Re: [PHP-DB] Re: how to notify admin by e-mail only once if mysql server is down

2002-04-14 Thread Lisi
Pardon my ignorance, but what's webmin? Thanks, -Lisi At 11:14 AM 4/12/02 -0600, Ray Hunter wrote: >You can use webmin and set up the alert there for mysql. I use it for my >webserver and database servers. It sends out 1 email for me telling me what >is down. > >Ray Hunter > > >"Andy" <[EMAI

Re: [PHP-DB] Extracting the essence!

2002-04-14 Thread Lisi
>Try something like the following to extract the contents of the array by >looping through it: >$test= preg_replace ($search, $replace, $dokument); while (list ($key, $val) = each($test)) { echo $key = $val; } HTH -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubs

[PHP-DB] Extracting the essence!

2002-04-14 Thread #Linux
Hi ppl! I want to strip html sites from the tags, only leaving the data from a entity. The info i would like to insert into a mysql table. Have tried to use the following code with various $dokument variables, but it dont preform as expected. http://localhost/php/index.html";); $search = a

Re: [PHP-DB] MySQL to Email and Line Breaks

2002-04-14 Thread DL Neil
Jeff, Is there something about the evaluation of \n in different types of strings, eg single quotes/double quotes? (I don't know the answer)... FWIW I don't like (perhaps, I don't trust) the \r\n type of short-cuts. Herewith some sample code: ... $LinkText= "Requested data can be foun

RE: [PHP-DB] MySQL to Email and Line Breaks

2002-04-14 Thread Jeff Oien
How do I get it to do that? I tried replacing \n with \r\n but it's not even finding any \n. This is really puzzling me. If I copy the data from the database field using MySQL-Front and paste it into a word processor it will have the line breaks retained. But what is it in the data that shows th

Re: [PHP-DB] Insert select does not insert all rows.

2002-04-14 Thread olinux
The script is probably timimg out. Default timeout is 30 seconds. Stick this in your script set_time_limit(0); set_time_limit() has no effect when PHP is running in safe mode http://www.php.net/manual/en/function.set-time-limit.php olinux --- andy <[EMAIL PROTECTED]> wrote: > Hi there, > >

Re: [PHP-DB] Re: MySQL to Email and Line Breaks

2002-04-14 Thread DL Neil
Sure he could (and it might look a lot nicer if he did...), but: 1 he said he doesn't want to, 2 ASCII text can also be formatted (with line breaks, at least), 3 using HTML encourages email bloat, and 4 some email clients don't render HTML Regards, =dn > Hey, couldn't you just send the text as

[PHP-DB] Re: MySQL to Email and Line Breaks

2002-04-14 Thread phplists
Hey, couldn't you just send the text as HTML and it would retain any formatting? Bob "Jeff Oien" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a form where someone enters the body of an email message > into a part of a form to be sent out to a list.

Re: [PHP-DB] MySQL to Email and Line Breaks

2002-04-14 Thread Jonathan David Edwin Wright
Hiya, If I remember correctly, you much send both \r and \n to terminate a line on an e-mail, regardless of the platform. This should include the header aswell. At 12:00 14/04/2002 +0100, DL Neil wrote: >Jeff, > > > I have a form where someone enters the body of an email message > > into a pa

[PHP-DB] Insert select does not insert all rows.

2002-04-14 Thread andy
Hi there, I am trying to update a table with new rows. The new rows are in another table so thought a insert select would be the right choice. Unfortunatelly it is only inserting about 400 rows, but the table contains more than 700. So I do really not know whats going on. Maybe someone could he

[PHP-DB] Re: how connect a remote data base MSAccess with PHP in Linux system

2002-04-14 Thread John Lim
Hello Silvia, Try using the database abstraction library ADOdb. It supports installing a stub server (written in PHP) on the Windows server, and you can send sql queries from Linux to the Windows machine via http. This is a 100% php solution. See http://php.weblogs.com/adodb_csv "Silvia Mahique

Re: [PHP-DB] MySQL to Email and Line Breaks

2002-04-14 Thread DL Neil
Jeff, > I have a form where someone enters the body of an email message > into a part of a form to be sent out to a list. Then a script > retrieves the body and sends it via email. However I can't get line breaks > to show up (I'm using MS Outlook) even if I enter the \n into the textarea > form