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
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,
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
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,
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
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
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
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
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
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,
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
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
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
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
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
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
16 matches
Mail list logo