Do not forget to use TRIM function as well:
LENGTH(TRIM(fax))
in order to elliminate leading and trailing spaces.
Aurel
- Original Message -
From: "Geoffrey Pitman"
To:
Sent: Friday, March 11, 2011 7:59 PM
Subject: [PHP-DB] RE: SELECT WHERE length of content question
You should b
Hey,
You can also try PEAR module MDB2 to insert an array into a table. The
function is: "executeMultiple". This works for other SQL queries too.
Check this link please:
http://pear.php.net/manual/en/package.database.mdb2.intro-execute.php
Cheers,
-Original Message-
From: Artur Ejsmon
One possibility is to use codes for this filed, such as:
10 for Current;
20 for Completed;
30 for Withdrawn;
40 for Transferred.
a.s.o.
If you will discover other "states" of the field you can "insert" them
apropriatelly (if you want Canceled state to be inserted and to be
displayed last put the
Hi!
I think that "NOT NULL" comes together with "PRIMARY KEY" and not with
"AUTO_INCREMENT".
Follow this link http://dev.mysql.com/doc/mysql/en/create-table.html for
detailed information about creating tables in MySQL.
Have a nice day!
Aurel
On Wed, 2005-10-05 at 12:15 +0200, W Roothman wrote:
Please, take into consideration that in Postgresql you have to quote
table name if there are capitals in the name. Thus, if the table name is
REV then you have to quote it like:
$sqlstring = "INSERT INTO \"REV\" (revision) VALUES ($revision)";
Aurel
On Thu, 2005-05-12 at 11:09 +0300, Mihai Fris
e browser.. this is how PHP works.
>
> Regards,
> Muhammed.
>
>
> - Original Message -
> From: "Constantin Brinzoi" <[EMAIL PROTECTED]>
> To: "Muhammed Mamedov" <[EMAIL PROTECTED]>
> Sent: Monday, December 15, 2003 4:05 PM
> Subject: Re:
blem.
TIA
Constantin Brinzoi
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_AUTH_USER;
and the value is still there.
How can I unregister this variable so that the authentication window
appears again.
I'm using apache 2.0.40, php 4.2.2 compiled as a module, RedHat Linux
9.0. Register globals is On.
TIA
Constantin Brinzoi.
--
PHP Database Mailing List (http://www
I know it is possible to search a database like this:
SELECT * FROM x_table WHERE name="%part_of_name%"
but I don't know for sure the correct command.
Could you tell me the right syntax?
TIA
Aurel.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.p
