[PHP-DB] Date Comparsion

Dear all I had a form which let user to input the leave_from and leave_to date into, the format of the date that user input is -mm-dd. Now i want to compare the leave_from and leave_to date to find out the number of days between! What should i do or any function in php can provide this

[PHP-DB] execute external sql script in php

Hello dear all, i try to execute an external sql-script to the mysql server $query =source /home/mysql/mysql_script ...but allways i get Impossible to execute the query any idea to do a stuff like this? thanks fabrizio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] execute external sql script in php

is this from within the browser? if so, you'd need to open the file, read the contents and execute the script. I don't knwo what 'source' does. but i don't claim to know much either. i may not have heard of this. if you just want to do it from a command line then you use a after your login

Re: [PHP-DB] execute external sql script in php

Jeff, source command in mysql shell is the same like mysql -u user -p /home/mysql/mysql_script. if i'm in the mysql shell i do: mysql source /home/mysql/mysql_script; ...to execute the script. this look to work like a normal query, but in my php script dont work! what's wrong? regards,

[PHP-DB] MySQL Clustering, redundancy

Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support for clustering or some type of redundant failover systems? Thanks! Matt Babineau Freelance Internet Developer - e: mailto:[EMAIL

Re: [PHP-DB] MySQL Clustering, redundancy

Yes,it's called Replication in the MySQL documentation. However, since the info in the manual is kind of sparse so I would hop on google and do a search for specific instructions on how to do it when your ready, but to answer your question, yes, MySQL does do Redundancy/Failover. (Ofcourse you

RE: [PHP-DB] MySQL Clustering, redundancy

Thanks for your response Adam! Do you know if there is any way MySQL can be spread across multiple machines? I am looking at a huge application for a client, that will need to support thousands of simultaneous users. I am wondering if MySQL can handle load like that. That's why I was asking

RE: [PHP-DB] MySQL Clustering, redundancy

I have never actually tried to program against something which talks to multiple DB's, the quickest way would be in your DB connection code to have something that will either: A. Try the first DB and connect to the second if it's down. B. Randomly choose a SQL server. The most fluid solution I

[PHP-DB] [php][odbc_connect]

Hi everyone, what this message means: Fatal error: Call to undefined function: odbc_connect() in /path/to/file.php thx for helping Regards from Switzerland, Michel Buchmann *** This e-mail message is

RE: [PHP-DB] MS Access DB Open as file ?

Hi Ivan, Check out the ODBC chapter in Professional PHP4 (Wrox Press) and also read the PHP HOWTO at www.iodbc.org for an explanation of ODBC in PHP - the short answer to your question can I connect to Access is maybe. A lot of it depends on your platform and available drivers. Best regards,

RE: [PHP-DB] [php][odbc_connect]

Michel, It means that ODBC support is not enabled in your PHP instance. Check the output of phpinfo(); for ODBC. If this is *nix, you need to link in an ODBC Driver Manager (such as iODBC, see the PHP HOWTO at www.iodbc.org) and install an ODBC Driver. If this is Windows, you need to uncomment

[PHP-DB] Re: Date Comparsion

Jack == Jack [EMAIL PROTECTED] writes: Jack Dear all I had a form which let user to input the leave_from Jack and leave_to date into, the format of the date that user Jack input is -mm-dd. Now i want to compare the leave_from Jack and leave_to date to find out the number

Re: [PHP-DB] Get the ts of the last change???

On 6/17/02 5:18 AM, Alex Elderson [EMAIL PROTECTED] pressed the keys forming the message: Hi, Is it possible to get the time of the last change of a mysql table?? in php? Sure. Try this: $info = mysql_fetch_array(mysql_query(show table status from dbname like 'tablename')); echo Last

Re: [PHP-DB] MySQL Clustering, redundancy

On 6/18/02 9:19 AM, Adam Voigt [EMAIL PROTECTED] pressed the keys forming the message: I have never actually tried to program against something which talks to multiple DB's, the quickest way would be in your DB connection code to have something that will either: A. Try the first DB and

[PHP-DB] is it possible to upload (binary) files to a mysql database?

Hello, Is it possible to upload binary files to a mysql database? I can't figure it out. This is what I did: I made a form like this: FORM ENCTYPE=multipart/form-data ACTION=upload.php METHOD=POST INPUT TYPE=hidden name=MAX_FILE_SIZE value=20 Send this file: INPUT NAME=attachment TYPE=file

[PHP-DB] SQL guru needed: Is this query possible ?

I've been racking my brain for too long trying to figure out how to do this query, I don't think it should be too hard, but I just can't get it right. I've searched and read about every type of join I could find to figure out a way of doing this, but I think I'm either overlooking something