mysql5.0 connector for php4.3.4

Hi, I am trying to use php4.3.4 with mysql 5.0.24 in windows. Where can I get the mysql connector for php4.3.4 or How do I connect to mysql in php4.3.4. If I try phpinfo(); it is giving only the mysql client API 3.23.49 version. Can somebody help me?. Thanks, Muthu. -- MySQL General

Logging from mysql only from certain applications

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, we've enabled /var/log/mysql.log on our server (5.0.24a on Debian testing). However I only want to log commands from certain application, or better say, certain users. When I look at some log output, it looks like this: 060919 9:53:38 15945

Re: Query to get count of ages

But you can't get a group by from an alias. That surprises me. I tried putting the calculation of age in a subquery but that didn't work, either. And I've never quite figured out how to create a temporary table for intermediate results. There has _got_ to be a way to do this, even an

Stored Procedure issues

Hi, I have a bit of a weird question. A couple of rows in a table I'm importing with data has WW_D_D_D style row content which is different from the usual WW_DD format data which many millions of rows contain. During the process of normalising the data is there any way to

phpinfo() Client API version 3.23.49

Hi, I am using apache2.0+php4.3.4+mysql 4.1.1 in windows. If I type phpinfo(); , in mysql section it is coming as Client API version 3.23.49 . Is the installation correct?. Will the php connect to the mysql 4.1.1 server?. If i need to see Client API version 4.1.1 in mysql section, what

access to mysql from outside

what I have to do to be able to access to mysql on my web server from other computer? e.g., I want to access to web server using MySQL Administrator? I have root access to web server. As far as I know, mysql server is set up by edfault to be acessed only through localhost and I have to add

Re: access to mysql from outside

You ought to conect on localhost and create a new user with the specific ip in the Host field. [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] what I have to do to be able to access to mysql on my web server from other computer? e.g., I want to access to web server using MySQL

Re: SUM in WHERE

I tried it also with 4.1.21-log and still didn't work ! On 9/19/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote: I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten [EMAIL PROTECTED] wrote: Ahmad Al-Twaijiry wrote: Hi

query question: updating between 2 tables

Hi all, trying to figure out if there is a query I can use for this, or if I have to write a php script to loop tru each row... table1: entryid int(11) itemid int(11) table2: object_id int(11) The situation is: table2.objectid is populated with the values of table1.itemid, but they have

RE: SUM in WHERE

I tried it also with 5.0.24-community-nt and it still didn't work! Randall Price Microsoft Implementation Group Secure Enterprise Computing Initiatives Virginia Tech Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -Original

Re: SUM in WHERE

Actually is this possible with simple SQL command in Mysql ? On 9/19/06, Price, Randall [EMAIL PROTECTED] wrote: I tried it also with 5.0.24-community-nt and it still didn't work! Randall Price Microsoft Implementation Group Secure Enterprise Computing Initiatives Virginia Tech Information

Re: query question: updating between 2 tables

2006/9/19, Peter Van Dijck [EMAIL PROTECTED]: Hi all, trying to figure out if there is a query I can use for this, or if I have to write a php script to loop tru each row... table1: entryid int(11) itemid int(11) table2: object_id int(11) The situation is: table2.objectid is populated

Re: Logging from mysql only from certain applications

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Markus Fischer wrote: Before I re-invent the wheel I'ld like to know if there are tools/helper like this available ... ? Being impatient and in need of this I've written my own version. Maybe it is valuable to others.

how can I access to mysql fro moutside?

hi, I'm trying to access to mysql on dedicated web server (hosted by hosting company) using MySQL Administrator. Right now I'm getting error message 2003 (Can't connect to the server...). On users table I can see in user column 'root' and 'admin' as users and both have for host 'localhost' (root

Re: how can I access to mysql fro moutside?

I don´t think it´s a problem with firewall. The error figured out below seems it´s been a username or password problem. [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] hi, I'm trying to access to mysql on dedicated web server (hosted by hosting company) using MySQL

Re: how can I access to mysql fro moutside?

U can chk firewall by doing a telnet to the remote host on 3306 ( default ) port . Error message looks like username/password might be wrong . [EMAIL PROTECTED] wrote: hi, I'm trying to access to mysql on dedicated web server (hosted by hosting company) using MySQL Administrator. Right now

Re: how can I access to mysql fro moutside?

I can connect using Putty to the server using port 22. When I try to connect to the server using port 3306 and got Connection timed out? Does it mean the port 3306 is blocked? -afan U can chk firewall by doing a telnet to the remote host on 3306 ( default ) port . Error message looks like

Last Inserted ID Using LOAD DATA

I have a group of updates that need to be done using LOAD DATA INFILE. Within this file there are some INSERTS. Is there anyway that after an INSERT happens I can use the auto-increment ID that was just generated in the next statement. Similar to PHP's mysql_insert_id() function. Thanks,

Re: Query to get count of ages

Server version: 5.0.24 This query is working OK for me. I'm using FROM_DAYS() to avoid errors due to leap years. SELECT extract(YEAR FROM from_days(datediff(curdate(), dateofbirth))) AS age, SUM(extract(YEAR FROM from_days(datediff(curdate(), birth_date AS total_age FROM

RE: how can I access to mysql fro moutside?

Does it mean the port 3306 is blocked? Not necessarily - it could mean that MySQL didn't respond as your telnet client expected (which is not surprising!). The Access denied for [EMAIL PROTECTED] message comes from the server, so there will be something wrong with your mysql.user or mysql.db

RE: SUM in WHERE

No, I don't think it is. I think you want to have a query that will return 'n' rows where the sum of Total is = 100 If your table is ID Total 1 10 2 20 3 30 4 40 5 50 it would return 1 10 2 20 3 30 4 40 (sum total = 100) but if your table was ID Total

RE: phpinfo() Client API version 3.23.49

Hi, The 3.23.49 is the version of the client that php is using. This may been what it was compiled with, or what it is getting from an external library. If it is compiled that way, you'll need a new compile of php including the newer client library. If its a runtime load, you may get away

RE: Outputting text in a

If you are running a script from the command line, try mysql -BNe select 'some text to print' -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, 25 August 2006 2:39 a.m. To: Wai-Sun Chia; Dan Buettner Cc: MySQL List Subject: Re: Outputting text in a You still get

How to delete all rows....

Hi All, How do I delete all the rows of all the tables(but not table) in the database at one shot. Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may

Re: how can I access to mysql fro moutside?

Okie there might be a entry in mysql.user table having username and password column as blank . That might result in Access denied when u use password . Try this , use mysql ; select * from user where user=''; if so , Delete those entries . [EMAIL PROTECTED] wrote: I can connect using

Re: How to delete all rows....

[EMAIL PROTECTED] wrote: Hi All, How do I delete all the rows of all the tables(but not table) in the database at one shot. Regards, Ravi K Hi - Please see http://dev.mysql.com/doc/refman/5.0/en/truncate.html Thanks -dant -- MySQL General Mailing List For list archives: