Re: [PHP] Re: SELECTing a row by maximum value

2002-12-30 Thread Elna Moorhouse
YTABLE order by ifield desc limit 1 > > > > Elna Moorhouse wrote: > > >TRY: > >SELECT id,Max(ifield) from MYTABLE. > > > >What I don't understand is why you specify id=$id in the where clause. If > >you already specify the id as let say 1 then

[PHP] Re: fOpen in append mode on a FTP Server

2002-12-30 Thread Elna Moorhouse
To see the error in action go to http://www.moorhouse.co.za/test.php Please help! Thanks "Elna Moorhouse" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... What I want to do is very simple, I have a txt file on a ftp server, that

[PHP] Re: SELECTing a row by maximum value

2002-12-30 Thread Elna Moorhouse
TRY: SELECT id,Max(ifield) from MYTABLE. What I don't understand is why you specify id=$id in the where clause. If you already specify the id as let say 1 then the max for that id will be 100 from your example below. "Richard Fox" <[EMAIL PROTECTED]> wrote in message 003901c2b034$0c563740$0700a

[PHP] fOpen in append mode on a FTP Server

2002-12-28 Thread Elna Moorhouse
  What I want to do is very simple,  I have a txt file on a ftp server, that contains the number of visits to my site.  I manage to open the file with "fopen($filename,"r+"), but the information is not written to the file.  I know that on a ftp server one can only open a file with fopen for