[PHP-DB] HUGE problem here

2002-06-08 Thread César L . Aracena
Hi all, I have a deadline for tomorrow morning (4 more hours) and have one small problem I’ve been working on for 3 hours now. I want the Administrators of a site to be able to delete or create new Admin users from within one admin’s page. >From the “Aministrators page” they will see a list of

Re: [PHP-DB] HUGE problem here

2002-06-08 Thread Camelia Enderby
try this for the delete query: $query = "DELETE FROM auth WHERE name='$deletename'"; See if it helps. Cami - Original Message - From: "César L. Aracena" <[EMAIL PROTECTED]> To: "PHP DB List" <[EMAIL PROTECTED]> Sent: Saturday, June 08, 2002 10:03 AM Subject: [PHP-DB] HUGE problem here

RE: [PHP-DB] HUGE problem here

2002-06-08 Thread Peter Lovatt
"DELETE FROM auth WHERE name=$deletename LIMIT 1"; needs quotes "DELETE FROM auth WHERE name='$deletename' LIMIT 1"; This may be the problem. HTH Peter --- Excellence in internet and open source software --

RE: [PHP-DB] HUGE problem here

2002-06-08 Thread César L . Aracena
Thanks a lot guys. Alter 1/2 litter of black coffee and your help... made it... must be the snooze... César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 > -Mensaje original- > De: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Enviado el: Sábado, 08 de Junio de 2002 06:1

Re: [PHP-DB] HUGE problem here

2002-06-08 Thread Ruprecht Helms
Hi Camelia Enderby, hi others, > try this for the delete query: > $query = "DELETE FROM auth WHERE name='$deletename'"; > See if it helps. how the case there a different names in the table that are equal to the value of deletename. try to identify the recordset you want to delete by his ID and

[PHP-DB] Auto-update database records

2002-06-08 Thread Tony
Here is my code. If you see some variables not defined, assume it is: Error: URL ".$final["url"]." does not exist."; } else { // get rid of html tags while (!feof($fp)) { // do something to get rid of html tags

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 20:35, Tony wrote: > Here is my code. > If you see some variables not defined, assume it is: Hmm, is there a problem with your code? If so could you state what the problem is? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Inte

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Tony
You are being picky on me, huh? I stated my problem 3 emails ago, browser gives me error "attempt to load "MyPage's URL" failed". Could be because of execution timeout. I tried to set the time longer with no luck. If I put the flush() after each data, I get the first output only. But I need to upd

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 20:52, Tony wrote: > You are being picky on me, huh? I'm sorry if you feel offended ... > I stated my problem 3 emails ago, ... but I delete mail from this list as soon as I've finished with them. As you have started a new thread one would naturally assume this is a n

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Tony
I do appreciate your reply. Yes, I've tried to track down the problem. I comment-out the fopen() function and use echo to display the URL. And it displays fine, so I did get the record from MySQL. Then when I put the fopen() back, same problem appears. I think it's probably because I have too much

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 21:34, Tony wrote: > I do appreciate your reply. > Yes, I've tried to track down the problem. > I comment-out the fopen() function and use echo to display the URL. > And it displays fine, so I did get the record from MySQL. > Then when I put the fopen() back, same problem

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-08 Thread Garrett Nelson
I have both the lines in httpd.conf. As I said, PHP is working fine, it's just an issue with MySQL support I believe. On 6/8/02 2:24 AM, "Jason Wong" <[EMAIL PROTECTED]> wrote: > On Saturday 08 June 2002 05:29, Garrett Nelson wrote: >> I now downloaded "php-mysql-4.1.2-1a.ppc.rpm" from rpmfinde

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 23:20, Garrett Nelson wrote: > I have both the lines in httpd.conf. As I said, PHP is working fine, it's > just an issue with MySQL support I believe. Sorry my mistake. Check in php.ini for this line: extension=mysql.so -- Jason Wong -> Gremlins Associates -> www.greml

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-08 Thread Garrett Nelson
On 6/8/02 12:07 PM, "Jason Wong" <[EMAIL PROTECTED]> wrote: > On Saturday 08 June 2002 23:20, Garrett Nelson wrote: >> I have both the lines in httpd.conf. As I said, PHP is working fine, it's >> just an issue with MySQL support I believe. > > Sorry my mistake. Check in php.ini for this line: >

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-08 Thread Jason Wong
On Sunday 09 June 2002 01:28, Garrett Nelson wrote: > > Well, we're getting closer now, maybe. I added the line extension=mysql.so, > and I still get the same error when trying to run the web-based PHP apps, > but in the command line when I type "php" I get back, > > PHP Warning: Unable to load d

[PHP-DB] arranging folders hiearchy

2002-06-08 Thread SP
I am trying to arrange the results by PATH but within each of the same PATH section I want it to be arranged by NAME alphabetically so it looks like the following below. I've tried a bunch of order by's but not getting it to work. Is this possible to do? Or do I have to change my PATH data some

RE: [PHP-DB] arranging folders hiearchy

2002-06-08 Thread SP
Wrong: 10 7 ' 1 3 10' 'Repairs' Correction: 10 3 ' 1 3 10' 'Repairs' -Original Message- From: SP [mailto:[EMAIL PROTECTED]] Sent: June 8, 2002 8:09 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] arranging folders hiearchy I am trying to arrange the