jeez
it reminds me of my poor ASP days...
John Lim [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
ADOdb is a popular database abstraction library for PHP. It supports
a very large number of databases, including MySQL, PostgreSQL,
Firebird, Interbase, SQLite, Oracle,
It's kinda clear.
What isn't clear is what the problem?
Kenny [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
hi all,
What I am trying to achieve to no avail is the following
I export values from a Mysql db into CSV format for quick updates and
that works fine..
Gary Theisen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all,
I've got:
WinNT
php 4.3.1
phpmyadmin 2.5.6
MySQL 4.0.18-nt
I can connect to my db via my php script using:
[php]
$connection = mysql_connect (localhost, root, )
[/php]
That works no problem.
This
, code optimization etc.) to do such un upgrade,
and what would you sugest as the most stable / reliable database / table format to
suit our needs?
(what we really lack right now is the use of foreign keys and replications).
Kind Regards
Uzi Klein
Web Development
BMBY Ltd
--
PHP Database Mailing
Try to set session.cache_limiter to private
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Hi
My customers would like to save my php outputs in a word document file and so I have
added a meta tag META NAME=ProgID
CONTENT=word.document in my php files. However, my
some input verification is recommended :
http://www.dibcomputers.com/new-dibcomputers/index.php?id=456456456%20%20OR%2012
Dan Bowkley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
got it...rather than return false, mysql_result throws an error if the query
returns nothing. What
Florian Wagner [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I'm a little confused about two mails I got from a service named quik.
It
looks like spam but I wonder how they got to know the headlines of the two
messages I wrote in this mailing list...does anybody know how
Check your class...
Maybe it resets the connection each time you create it.
-Original Message-
From: Mika Porspakka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 12:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Losing MySQL connection with multiple database classes
Hello all.
Try
$result_insert = @mysql_query ($query_insert) or die(mysql_error);
-Original Message-
From: Dan Bowkley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 08:37
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] lamer noob with repeat question
Anyone?
- Original Message -
';;
(notice the wildcard in there-- Access isn't smart enough to realize
that the deletion of any information in a row automatically means
deleting the entire row. I guess the original design must've intended
to use delete for an update columnname = null.)
-Mike Forbes
Uzi Klein wrote:
Match Case
Vern [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I found this code below that allows me to retreive the queries served on
my
server for each day but can't figure out how to actually display the
information using echo. Can some one give me an example using the
following
SQL?
http://pear.php.net/manual/en/package.database.php
-Original Message-
From: pete M [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 14:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Pear - autoExecute()
Am trying the following bit of code usind the PEAR DB.php class
$table =
Did you use $db = new DB; ?
-Original Message-
From: pete M [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 14:31
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Pear - autoExecute()
That's where I copied the code below that does not work ;-(
Uzi Klein wrote:
http
not work ;-(
Uzi Klein wrote:
http://pear.php.net/manual/en/package.database.php
-Original Message-
From: pete M [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 14:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Pear - autoExecute()
Am trying the following bit of code
- Original Message -
From: matthew perry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 5:44 AM
Subject: [PHP-DB] Cursor in text box.
My users complain about everything.
The most common is Why do I have to move the mouse over to this box
every time?
- Original Message -
From: Rachel Rodriguez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 23, 2004 3:55 AM
Subject: [PHP-DB] assigning variables after one-to-many query
Hi!
I have a one-to-many relationship between two tables
(table1 and table3) with a linking table
Try this :
$string = Hello World;
$TableName = Table;
$FieldName = Field;
$Field = CONCAT_WS('', ' ', TRIM($TableName.$FieldName), ' ');
$Op = $Type==All ? AND : OR;
$where = WHERE ($Field LIKE '% .(preg_replace(/[\s]+/, %' $Op $Field
LIKE '% , $string)). %');
$sql = SELECT * FROM Table .
Or even better :
?
// ...
$string = Hello World;
$Fields = Array(Table.Field1, Table.Field2, Table.Field3);
$Op = $Type==All ? AND : OR;
for( $i=0; $icount($Fields); $i++ )
{
$Field = $Fields[$i];
$Field = CONCAT_WS('', ' ', TRIM($Field), ' ');
$where .= \n. ($i==0 ? WHERE : $Op );
$where
Hi.
Any body got an idea how to use hte foreign keys in mysql innodb tables
and how whould the change affect the performance of the server?
lets say i have Items table, Clients table, and Sales table
the Sales table always stores ClientID and ItemID
but not every client/item is there
a sale can
Hi.
Any body got an idea how to use hte foreign keys in mysql innodb tables
and how whould the change affect the performance of the server?
lets say i have Items table, Clients table, and Sales table
the Sales table always stores ClientID and ItemID
but not every client/item is there
a
Use UPDATE statement
UPDATE tbl SET date_field=NOW() where index=your_index
or
UPDATE tbl SET date_field='2004-04-22' where index=your_index
- Original Message -
From: charalambos nicolaou [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 3:35 AM
Subject:
Maybe it is not null but has empty content?
the first statement is correct
try
SELECT * FROM questions WHERE (answer IS NOT NULL OR answer'');
or maybe
SELECT * FROM questions WHERE LENGTH(answer)0;
- Original Message -
From: Pambos Nicolaou [EMAIL PROTECTED]
To: [EMAIL
Hi everyone,
I can not find in my manual a MySQL command which erase permanently a table
and it's content from a MySQL database.
- DROM TABLE 'tbl_name';
Thanks in advance
Charalambos
_
MSN 8 helps eliminate e-mail
23 matches
Mail list logo