hi,
I've following system: apache 2.0.36 on a w2k server with PHP/4.2.1 as a
module.
I configured the php.ini in this way:
error_reporting = E_ALL & ~E_NOTICE to avoid php displaying warnings and
notices. ( of course I restartet the apache service ). But I got even so
warnings and notices displaye
Hi all,
I have seen queries of this nature before, but they never seem to get a
thorough answer - and that maybe because the issue isnt explained properly..
okay, so here is the scenario.
I have a database which features the following tables:
hst_category
hst_product
hst_categ
On Friday 14 June 2002 03:23, suman wrote:
> hi
> adding the in func.php still returns this.
>
> my functions script is
> -
You need:
This
> when i run these i get this error
> Parse error: parse error, unexpected ';' in
> /usr
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 said...
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
t
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 o.p
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
datab
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 calculation
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 sa
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 dbname
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
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 nic
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 in
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 sure
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 alr
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 your
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
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
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, Jun
19 matches
Mail list logo
