[PHP-DB] connecting to a remote db?

Hi there everyone, I have a secure server and another separate servr, both use PHP and MySQL – however, I need to connect to a db off of the secure server, how can I do this? I normally use localhost if it’s on the same machine, but how can I connect the DB to a DB on my other machine as I

RE: [PHP-DB] Executing Queries from a File Using PHP

Thanks. Since it would take me forever to write, and I don't know thing well enough to make sure I have all the possibilities covered, I was hoping there was some source code somewhere I can use. --Bruce -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: [PHP-DB] Executing Queries from a File Using PHP

all you have to do is put one query per line in the file, it may be hard to read, but who cares. and then it is as simple as. $contents = file(sql.txt); //file function reads file into array while (list ($qry)) = each($contents)) { mysql_query($qry); } Just a thought Jeff

[PHP-DB] how is it possible to read data from an excel workbook ?

i need to read data from a sheet in M$ Excel to update some databases in M$ Acess ... but how ??? thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Executing Queries from a File Using PHP

although this goes without saying but in my petty need for completion, i feel i must writethere is obviously SO much more that can be done where i put the mysql_query($qry), whether it be updating, inserting, selecting etc... but that can be a starting point. i feel better, thank you for

RE: RE: [PHP-DB] how is it possible to read data from an excel workbook ?

thanks for your attention the question is that im 'working' on a software to automate a weekly employee task that resumes to import a excel file that comes in zip format from the mother-company with new prices and products, to update an accounting software that uses M$ access db. there are

Re: [PHP-DB] Re: Error Loading File -- Sort of Fixed

Ok, if anyone else is having the same trouble with PHP 4.2.1, David Robley's suggestion (Thank you David!) works. I am not to proud to have missed the obvious :) If you are having trouble loading files (LOAD INFILE...) with PHP into MySQL, just do a chmod($file, 0777), and it works. Not

[PHP-DB] MySQL timestamp field in different time zone

How do I get a MySQL timestamp field to update itself when the server is in a different time zone, i.e., I want it to have the date for my time zone. The field updates itself automatically, of course, without being referenced in the SQL query. I'd like to avoid having to change every query to

RE: [PHP-DB] MySQL timestamp field in different time zone

I had a similar issue where I wanted timestamps to be relative to the user. I didn't find any better way then to create some profile data that contained their timezone and allow them to save that data. Then anytime I displayed a timestamp I added the timezone shift to the stamp. It would be

RE: [PHP-DB] MySQL timestamp field in different time zone

BTW... are you saying that you plan to move the MySQL server around to different time zones? Why would you do that? -Original Message- From: Ryan Jameson (USA) Sent: Thursday, June 13, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone

Re: [PHP-DB] problem with login script

hi adding the ? ?in func.php still returns this. my functions script is -function auuser($login,$passwd) { global $db_server,$http_host,$db,$db_user,$db_pass,$doc_root; if(!( $connect=pg_pconnect(host=$db_server

Re: [PHP-DB] MySQL timestamp field in different time zone

No, it is similar to your situation. Server is in another time zone from the user. I want the timestamp to be relative to the user, not the server. Maybe do something in grenwich time, then interpret all queries from the db . . . ? kind regards, bill Ryan Jameson wrote: BTW... are you

RE: [PHP-DB] MySQL timestamp field in different time zone

Well then, the client needs to do the work since the client is the only side that knows the users timezone. Assuming you have a browser for a client I think you're stuck with the solution I had which was require the user to store (in the db, or in a cookie) their timezone and do the

[PHP-DB] Book about Metabase

Hello, Just thought you would like to know that a new book named PHP and XML was released with a whole chapter dedicated to Metabase. Despite the book is about XML, the Metabase chapter talks about its use of XML to describe schemas to be installed automatically by Metabase and also the

[PHP-DB] Displaying results from JOIN

Hello, With some help from the mysql list, I've been able to get this query working from the command line SELECT * FROM outings as o INNER JOIN pics AS p1 ON o.pic1_id=p1.pic_id INNER JOIN pics AS p2 ON o.pic2_id=p2.pic_id INNER JOIN pics AS p3 ON o.pic3_id=p3.pic_id INNER JOIN pics AS p4 ON

[PHP-DB] auto increment

Hi guys, The auto_increment field of my MySQL table gives me 258, although the higher value at the moment is 241. I deleted the latest records, thinking that also the auto_increment would decrease, but this is not. I would like to know if there is a way to bring the auto_increment back to the

Re: [PHP-DB] how is it possible to read data from an excel workbook ?

Hi, The majority of the problems arise when you try to do something that's not idiomatic to the language or endemic to the environment. MS Excel PHP do not co-exist, and you will have a lot of headaches whenever you try using some M$ product with a non-M$ technology. However that being

Re: [PHP-DB] problem with login script

On Friday 14 June 2002 03:23, suman wrote: hi adding the ? ?in func.php still returns this. my functions script is - You need: ? function auuser($login,$passwd) { ... } ? This ?include 'functions.php'; Should