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 sc
If you want to delete multiple items, you need to use array name condition
in checkbox.
Here's an example:
Of course you can use a while loop to output the form.
Then in your PHP code that processes this form, you need to run a query for
every one of the data you
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 = '1
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 taki
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
conte
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
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: Mo
Thanks for ur response. I used the approach as below and it worked much
faster and reduced the execution time by 5 times. I concatenated the 3
fields i wanted to compare and used it as the id. But the query still takes
like 3 minutes. Earlier it used to take 12 minutes. Can I optimise it any
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
anyway
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
>>>Mic
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
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
> Microso
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]
I figured it out. Here's my completed code for reference:
$db2_conn = @odbc_connect (DB2_ALIAS, DB2_USERNAME, DB2_PASSWORD) or
$db_error .= 'Unable to connect to DB2
Database!!'."\n".'Error Message:
'.$php_errormsg.'';
$piv_conn = @sybase_connect (PIV_ALIAS, PIV_USERNAME, PIV_PASSWORD
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 th
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 acce
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
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
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
--
"Casey Allen Shobe" <[EMAIL PROTECTED]> ha scritto nel messaggio
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Whoops, had an extra line in there. Should have been as follows:
function db_query ($db_type, $db_conn, $db_query) {
// Uncomment to debug
//echo $db_query.'';
if ($db_type == 'odbc
Whoops, had an extra line in there. Should have been as follows:
function db_query ($db_type, $db_conn, $db_query) {
// Uncomment to debug
//echo $db_query.'';
if ($db_type == 'odbc') {
$result = odbc_exec($db_conn, $db_query);
while(odbc_fe
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()
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 MSSQL
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
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...
25 matches
Mail list logo
