On 15 Jan 2004 at 12:33, Matthew Stuart wrote:
> ASP and VB
>
> I have created a search web page searching a MySQL table with the
> following code:
>
> CREATE TABLE tbl_allarticles (
> fld_ID mediumint(8) unsigned NOT NULL auto_increment,
> fld_category tinyint(2) unsigned NOT NULL default '0'
* Matthew Stuart
[...]
> SELECT *
> FROM tbl_allarticles
> WHERE fld_headline OR fld_summary OR fld_body LIKE '%userinput%' AND
> fld_show = 1
This statement does not do what you probably intended it to... the above is
similar to this:
WHERE
fld_headline+0 != 0 OR
fld_summary+0 != 0 OR
fld_
ASP and VB
I have created a search web page searching a MySQL table with the
following code:
CREATE TABLE tbl_allarticles (
fld_ID mediumint(8) unsigned NOT NULL auto_increment,
fld_category tinyint(2) unsigned NOT NULL default '0',
fld_updateddate timestamp(8) NOT NULL,
fld_createddate timesta
