Hi.
I want to know what is the right way to make some comparisons with date variables.
I have used only the date() function to get a variable in this format= 01-07-2002
Is there a way to add 20 days in order to have 21-07-2002 or 2 months to have
01-09-2002?
Thanx in advance...
On Mon, 1 Jul 2002, Achilleas Maroulis wrote:
Hi.
I want to know what is the right way to make some comparisons with date variables.
I have used only the date() function to get a variable in this format= 01-07-2002
Is there a way to add 20 days in order to have 21-07-2002 or 2 months to have
I'm trying to write a unified database query function for an application I
have which currently accesses data from both DB2 and Microsoft SQL from a
Linux server. I'm using ODBC functions for DB2, and Sybase functions for
Microsoft SQL.
Here's what I've got for DB2, and a blank area for
Hi,
is there somebody around to tell me how to structure a query to select a
time period from a dBase table using dBase date fields?
I don't know how to convert a date string in PHP so dBase can interpretate
it.
In clipper for instance one may use date-to-string dtos() or string-to-date
stod()
use LOAD DATA (plus parameters) to import excel-files and other
text-files into mysql
chris
Am Sonntag den, 30. Juni 2002, um 01:23, schrieb Manuel Lemos:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
i forgot: LOAD DATA is a mysql-command
http://www.mysql.com/doc/L/o/Loading_tables.html
chris
Am Montag den, 1. Juli 2002, um 14:16, schrieb Christian Rellstab:
use LOAD DATA (plus parameters) to import excel-files and other
text-files into mysql
chris
Am Sonntag den, 30. Juni 2002,
Nice, mature response, Jason. Really smooth! :o)
:chortle:
Martin
[EMAIL PROTECTED] 06/30/02 09:44AM
On Sunday 30 June 2002 09:06, CrossWalkCentral wrote:
As this has nothing to do with DBs it should be posted to the php-general
list.
When using this fucntion listed bellow with the HTML
I figured it out. Here's my completed code for reference:
$db2_conn = @odbc_connect (DB2_ALIAS, DB2_USERNAME, DB2_PASSWORD) or
$db_error .= 'font size=+2bUnable to connect to DB2
Database!!/b/fontbr'.\n.'bfont color=#ccError Message:
/font/b'.$php_errormsg.'br';
$piv_conn =
I agree, it's definitely simpler and quicker to just store them in the file system and
save the file path in the database.
Ryan
-Original Message-
From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 6:21 AM
To: andy
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Hello,
On 07/01/2002 06:46 AM, Casey Allen Shobe wrote:
I'm trying to write a unified database query function for an application I
have which currently accesses data from both DB2 and Microsoft SQL from a
Linux server. I'm using ODBC functions for DB2, and Sybase functions for
Microsoft
On Mon, 01 Jul 2002 14:55:01 -0300
Manuel Lemos [EMAIL PROTECTED] wrote:
Hello,
On 07/01/2002 06:46 AM, Casey Allen Shobe wrote:
I'm trying to write a unified database query function for an application I
have which currently accesses data from both DB2 and Microsoft SQL from a
Linux
Hello,
On 07/01/2002 03:01 PM, Pierre-Alain Joye wrote:
I'm trying to write a unified database query function for an application I
have which currently accesses data from both DB2 and Microsoft SQL from a
Linux server. I'm using ODBC functions for DB2, and Sybase functions for
Microsoft SQL.
On Monday 01 July 2002 01:55 pm, Manuel Lemos wrote:
Why do you re-invent the wheeel and don't you use a database abstraction
package that handles the database differences of you, like for instance
Metabase.
Because I had never heard of it. It doesn't appear to have a sybase module
anyways,
Casy,
try php.weblogs.com ADODB. It is a database abstraction layer that supports
Sybase. (Among other db backends.)
HTH,
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Casey Allen Shobe [mailto:[EMAIL PROTECTED]]
Sent:
Hi there,
I am wondering if anybody has experiance in saving images to blob in mysql.
I do save images with 1 K and 4 KB to blob fields while I used to save them
to file. It seams to me that this is much slower accessing the files. The
images take a bit (really short but absolutly noticable) to
On Mon, 1 Jul 2002 14:17:53 +0200
andy [EMAIL PROTECTED] wrote:
Hi there,
I am wondering if anybody has experiance in saving images to blob in mysql.
I do save images with 1 K and 4 KB to blob fields while I used to save them
to file. It seams to me that this is much slower accessing the
Hello,
On 07/01/2002 05:03 PM, Casey Allen Shobe wrote:
On Monday 01 July 2002 01:55 pm, Manuel Lemos wrote:
Why do you re-invent the wheeel and don't you use a database abstraction
package that handles the database differences of you, like for instance
Metabase.
Because I had never
I have two related tables. The first has about 12 records, each of which is
related to about 12 records in the second table. I want to have two
interconnectedt dropdown list fields. The fist is used to select from the
first table and when the value has been selected, use it to determine the
hi, i'm trying to delete multiple records at once from a mysql db and can't
seem to figure out how to do so.
here's the code i've been trying to troubleshoot with:
$result_insert = mysql_query(delete from $mysql_table where id = '8' AND
where id = '18');
i've tried various things such as
At 22:37 -0400 7/1/02, Matt Nigh wrote:
hi, i'm trying to delete multiple records at once from a mysql db and can't
seem to figure out how to do so.
here's the code i've been trying to troubleshoot with:
$result_insert = mysql_query(delete from $mysql_table where id = '8' AND
where id = '18');
If you want to delete multiple items, you need to use array name condition
in checkbox.
Here's an example:
form action = delete.php method = post
input type = checkbox name = name_array[] value = value1
input type = checkbox name = name_array[] value = value2
!-- more and
is the increase of the network traffic noticable? The query is pretty small
just text. Do u really think this might increase the traffic?
I also noticed that the image is not cached anymore. Is this true for all
blobs, or do I just access them in a wron way?
(I am requesting a php file in the
22 matches
Mail list logo