ke
up much space anyway.
I wouldn't worry about optimizing in small databases. But it's always good
practice to create every table in a sensible structure.
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Remco Oosten" <[EMAIL PROTECTED]>;
I don't think you can use text(50),
It should be one of the following tinytext, mediumtext or text
Or you should use char(50).
I would try to avoid using varchar() it fragments the database.
Remco
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mond
Does this help?
select
12*(year(current_date)-year('2001-03-02'))+(month(current_date)-month('2001-
03-15'));
the result is 13.
But it's quite a large query.
- Original Message -
From: "John Hughes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 9:56 AM
Subje
I use a method I'd like to share:
For building queries with many conditions you first create an array like so
$select = "SELECT *";
if (isset($cond)) unset($cond);
if ($desc) $cond[] = desc LIKE '$desc%';
if ($state) $cond[] = state LIKE '$state%';
if ($city) $cond[] = city LIKE '$city%';
if (
If your framecontainer is your top-document perhaps you can use:
top.rightFrame.document.open();
or maybe
top.rightFrame.location='';
Remco
- Original Message -
From: "Josh Trutwin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 4:25
