I've written and automated system that does the following:: similar problem
** every evening a cron job executes on LAN linux and spools of prices
into a csv text file
** The file is ftp/uploaded to remote server on web and a database entry
created to show file
** cron job on remote server
oops forgot to mention reson for cron... Timeouts
processing 143mb can take a long time.
also you need to use fgets to read the file one line at a time..
pete
Dave wrote:
we have a number of csv dumps that occasionally have to be used to update tables
in a postgres database...
normally
Hi all,
I posted this on the php-i18n list already, but I thought it might be
relevant here too, so here goes.
I am currently using PHP 4.3.1 with Microsoft Access 2000 in Windows 2000
with IIS web server to store content for a multilingual website.
I am having two different but related
Hi there,
How can I authenticate users against the database using NTLM instead of
Basic Authentication?
Instead of manually logging in, each user's NT account will automatically
allow or deny access.
Is there somewhere in the php.ini file where I have to enable the NTLM
module?
Here's my
I keep getting Spam warnings on this list whenever I post code. Is there anyway
around this? I'm not sure my questions can be answered without showing the code that I
am having trouble with.
If not, then I will have to get my boss to subscribe and post from his ISP account.
Karen
Try this
function send_html_mail($myname, $myemail, $contactname, $contactemail,
$subject, $message) {
$headers = MIME-Version: 1.0\n;
$headers .= Content-type: text/html; charset=iso-8859-1\n;
$headers .= X-Priority: 3\n;
$headers .= X-MSMail-Priority: Normal\n;
$headers .= X-Mailer:
is there any quick way of selecting the 'last' row in a mysql table?? i
could write some messy code but id prefer an elegant solution.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Saturday 27 September 2003 00:04, Karen Resplendo wrote:
I keep getting Spam warnings on this list whenever I post code. Is there
anyway around this? I'm not sure my questions can be answered without
showing the code that I am having trouble with.
You're not doing anything wrong. It's a
On Saturday 27 September 2003 01:04, John Ryan wrote:
is there any quick way of selecting the 'last' row in a mysql table?? i
could write some messy code but id prefer an elegant solution.
mysql_num_rows()
mysql_data_seek()
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source
On Friday 26 September 2003 23:46, Karen Resplendo wrote:
There are 113 rows in my comma delimited text file and the code below only
displays 62 of them. It executes very quickly so I'm not thinking there is
a time out problem. Any ideas?
//here is URL with fgetcsv() explanation:
Does that mean that my length setting has to be exactly the length of the row? I don't
know this because it is a comma delimited file, not a space delimited. The function
description says:
The length parameter must be greater than the longest line to be found in the CSV
file (allowing for
On Saturday 27 September 2003 01:24, Karen Resplendo wrote:
Does that mean that my length setting has to be exactly the length of the
row?
No.
I don't know this because it is a comma delimited file, not a space
delimited. The function description says:
The length parameter must be greater
if you are seeking for the last in autoincrement field, in your select use
this:
select max(field) from table;
if is other, well, i dont remember :D
Regards
Nilson
John Ryan dijo:
is there any quick way of selecting the 'last' row in a mysql table?? i
could write some messy code but id
I have a query that is pulling user comments, supplied by via web
internface and creating a text file out of them. In these comments are all
sorts of carrige returns. I've tried stripping them out with the following
queries, but once imported into excel, the carrige returns are still there.
so
I have a page that when all said and done is super slow. The queries are
running a bunch of JOINs and SORTs and WHEREs. I recently implemented
the my-large.cnf file in hopes it would help out the situation, but the
change appears negligible.
Does anyone have any suggestions for speeding up the
On Friday 26 September 2003 22:58, Matt Babineau wrote:
I have a page that when all said and done is super slow. The queries are
running a bunch of JOINs and SORTs and WHEREs. I recently implemented
the my-large.cnf file in hopes it would help out the situation, but the
change appears
Hello,
I'm novice in php and mysql utilization so...
Here is my problem:
I have a form with some fields (for example, 2: field1 and field2)
My mysql database contains for example 1 table (named for example SQLTABLE)
with 3 fields: ID (auto_increment), AA, BB.
On my form, field1 is represented
If I understand your problem correctly, it sounds like you need to get all
of the values for the two select objects (which you can do with PHP, of
course) then use JavaScript to handle the CLIENT SIDE update process between
the two objects.
If that sounds like what you're looking for, you can
What I am trying to do:
lab uploads txt file
php validates file, row by row, field by field (against database)
I display bad rows and reasons in red and reject file
I've figured out a different way to display the whole row by just printing the array
with , instead of br/n
Just wondering why
Using PHP 4.3.1 MSSQL 7.0
Executing a Stored Procedure through the function mssql_query that returns a
message of:
DELETE statement conflicted with COLUMN REFERENCE constraint...
The statement has been terminated.
causes the link to be unusable in executing function mssql_query again.
Sql
If you are trying to replace the carriage return it needs to be \r
instead of \ n in your query. Also it may not work because in my
experience the replace function under mysql does not replace them in the
db but in the query results. If you are looking to replace them
permanently you will need a
Hello everybody,
I need help in order to get the table name of a field in SQL Server 2000.
In order to get the table name of a specific column in a query, I tried to
use mssql_fetch_field function. But column_source is, in fact, the
column name, not the table name how it was supposed to be.
In a
Matt,
Have you tried an EXPLAIN query yet? Start with this and send the result
of the query back to the list...that would give everyone a better sense
of what is happening.
Cory
On Fri, 2003-09-26 at 09:58, Matt Babineau wrote:
I have a page that when all said and done is super slow. The
Hello,
Beta 3 of plPHP has been released with full trigger support for
PostgreSQL.
PL/PHP - PHP Procedural Language
Copyright 2003 Command Prompt, Inc.
http://www.commandprompt.com/
+1 503 222 2783 [EMAIL PROTECTED]
1. PL/PHP language installation notes
2. PL/PHP
24 matches
Mail list logo