RE: updating records without changing timestamp fields

Add Two Time stamps. Only one will get update. Mat -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:31 PM To: MySQL List Cc: Henning Heil Subject: Re: updating records without changing timestamp fields On 27 Oct 2003 at 21:21, Henning

Re: Using MySQL text column with PHP4

Try this function nl2br() Mat - Original Message - From: Rance Hall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 7:51 AM Subject: Using MySQL text column with PHP4 I need some help formatting a MySQL longtext column for presentation via PHP When I pull the

How to rewrite this statement.

I have this query that works just fine in msacess agains some linked mysql tables, but if I run this statement in php or in mysqlfront it doesn't work. I belive it's because there is two joins in it but i'm not sure. If that is the problem then what is the work around? Here is the statement:

Re: How to rewrite this statement.

= FORUMMSG1.POSTNUMBER)ON USERS' at line 1. Thanks, Mat - Original Message - From: Nathan [EMAIL PROTECTED] To: Mat Murdock [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:03 PM Subject: Re: How to rewrite this statement. Where does mysql say there is a problem? By the by, your WHERE

Can you do something like this in Mysql?

Can you do something like this in Mysql? The following lines are part of a much larger sql query that we use on a MSsql box. ... case ar_open_items.doc_code when 'I' then 'Invoice' when 'C' then 'Credit Memo' when 'D' then 'Debit Memo' when 'F' then 'Finance Chg' when 'O' then case

Re: possible bug in sum() function

Hehehehe. - Original Message - From: Geoff Blake [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 11:37 AM Subject: Re: possible bug in sum() function On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote: the query was: select

Re: PHP and mysql and images

Is there a particular reason why you want the images in a mysql database. It would be faster if you put that path to the images in a table then the actual images. Mat - Original Message - From: Kevin Pratt [EMAIL PROTECTED] To: Mysql List [EMAIL PROTECTED] Sent: Friday, June 15, 2001

Moving Data

We will be moving our MySql databases from a Winnt server to a linux server. Can I just copy the data files from one machine to the other? If not then how should I do it? Mat Murdock Your mouse has moved. Windows must be restarted for the change to take effect. Reboot

Limit

If I understand the manual correctly when I do a "select blah from blah where blah = blah order by blah limit 10" Mysql finds the first 10 matching records and then sorts those records. How do I have it first sort the database and then take the first 10 records? Thanks for your help,

Re: Reg. Synchronization between MySQL DBs

Did you look at doing something with replication? Mat Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ] - Original Message - From: "Aigars Grins" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001

mysqlbinlog

I've looked through the manual and about 9000 posts from multiple mailing lists.. Is there a way to have mysqlbinlog take a log file and dump just the sql statements to a file? Am I using the wrong program to do that? Any help would be most appreciated. Mat

Re: PHP and MySQL in red hat 7.0

I tried RedHat, but had the same problem getting apache and php and mysql to talk to each other. I decided to try Mandrake 7.2 and it did all the work for me. Murdmath - Original Message - From: "Luis" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];