Jason Dulberg wrote:
> I need to stick a little expiration date into a part of my site but can't
> seem to get it going properly.
Your logic is ok -- DATE_ADD() is the function to work with. You don't give any
details about the actual problem you're having, but from the e-mail it seems
you're go
I need to stick a little expiration date into a part of my site but can't
seem to get it going properly.
Basically, what I need to do is add 2 months to the number of results for a
particular member. So if someone has 6 entries in the db, they will all
expire in 8 months.
I have my $dateadded my
Yeap. That's what it was. In the PHP.INI file the directive mssql.textlimit
and mssql.textsize were set to 4096 bytes. I just set them to maximum of
2147483647 and it works like a charm.
Thanks for the tip.
Niko Spyridonos
Director of E-Business Services
Chamerlik/CompuLogic
http://www.designt
What the heck are you talking about?
>-Original Message-
>From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, December 26, 2001 7:50 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
>[EMAIL PROTECTED]
>Subject: Re: [PHP-WIN] MSSQL connect
>
>
>I don't know who's a moro
I don't know who's a moron that can;t even see straight
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
27E647E5629ED211BF78009027289C6302157DAB@mail1">news:27E647E5629ED211BF78009027289C6302157DAB@mail1...
> You must be an extremely intelligent person, almost literary quoting my
> answer,
Oracle DATEs are retrieved (by ora_fetch_into($cursor, $row,
ORA_FETCHINTO_NULLS), for example) as plain dates (e.g., '26-DEC-01'),
losing the time of day (as in '26-DEC-01 12:34:56'). Is this a bug? Is
there a workaround that doesn't involve rewriting the query? (My
application is an SQL query
You could always categorize parts of the data and split it into separate
tables. For instance, if you have a LOT of United States countries, you can
duplicate the table, but keep only the U.S. country-records in the second
table, and everything else in the first table. Then, before querying the
da
hi
sorry for double posting
but i just remebered one thing
if you don't have ssh access you could create a .sh file with the dump commands,
upload it along with your db file and call exec (.sh file) from a php page
(setting it as a background process), hmm. i think it should work; haven't test
Hello,
Andy wrote:
>
> this is my sql statement:
>
>$stmt= "
> SELECT *
> from $geo_T3
> WHERE country_code = '$country' AND province = '$province'
> order by city ASC
>";
You can do two things to speed up the query:
- Never use * for selecting columns in production c
You must be an extremely intelligent person, almost literary quoting my
answer, and then pinpointing down things I already pointed out! Moron...
>From: Thomas "omega" Henning
>Sent: Wednesday, December 26, 2001 8:50 AM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
>[EMAIL PROTECTED]
>Subject: Re: [P
Hello All,
I'v writen a program in PHP4.0.6+MySQL and its working on a linux machine.
I'm trying to print from Crystal Report through MyODBC. Where i have to
install MyODBC on my linux machine or windows machine?
Thanks for all help
Thomas "omega" Henning
--
PHP Database Mailing List (http:/
Here is the problem $sql != $sql_temp
so the $result = NULL; because mssql_query(" ") has no query to send to the
MsSQL server.
This should work try it out!!!
Thomas "omega" Henning
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Andy,
That's a rather large file. It looks like execution time is under the
control of your ISP, so you don't have the option of increasing it. So
chunk your table. Assuming it is stored locally at present, break it into
into chunks, and move and each chunk, eliminating the table creation code
Is this the same question posted about 10 days ago regarding countries and
provinces?
Is the query any faster if you run it at the MySQL console?
Does the query work if you remove the single quotes surrounding $province,
assuming the province filed corresponds to "field3" in your original mes
Hi guys,
I have a table with over 2million entries. In order to upload this table to
my providers db I use mysqladmin to export this table as txt file.
Unfortunatelly I get following errormsg:
Fatal error: Maximum execution time of 300 seconds exceeded in
e:\projects\globosapiens\07_production
this is my sql statement:
$stmt= "
SELECT *
from $geo_T3
WHERE country_code = '$country' AND province = '$province'
order by city ASC
";
cheers Andy
"Miles Thompson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> To help with
How can i use PHP to run Oracle Form under iPlanet Web Server? Oracle Form
will check the userid in the oracle db and generate the page depends on the
user profile.
Can anyone help me. Thank you.
Regards,
Mohd Nizar Abdul Najib.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
17 matches
Mail list logo
