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

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 05:29, Garrett Nelson wrote: I now downloaded php-mysql-4.1.2-1a.ppc.rpm from rpmfinder, and again I get rpm -ivh php-mysql* Preparing...### [100%] package php-mysql-4.1.2-1a is already installed (Same error

[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 Hi all,

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:14

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 then

[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: ? require_once(fn_web.php); require_once(fn_db.php); set_time_limit(3000); set_header(Auto-Update); $final_result = get_records($_POST[key]); // getting the records from database

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

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 update

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

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

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 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 -

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 dynamic

[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