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: Monday,
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]; PHP-DB [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 11:33
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 PM