Thank you for your email support request

o use your e-mail's "Reply" feature to respond to Technical Support e-mails. By doing so, we keep the information from previous messages, which will assist the Technicians in resolving your problem in a timely manner. If this email is concerning WebDemo or WebInteractive you can cal

RE: Unknown column in 'where clause' error

You are using PHP. Well PHP is not ASP :-) clever and you can enclose your variable in single quotes as in: $customer_select="SELECT * FROM customers WHERE Customer_No = '$id'"; Hope this helps. * * Visit http://www.computerstaf

RE: Unknown column in 'where clause' error

Hello, Your field(column) is a CHAR and therefore the parameter to it should be in single quotes: Change your query to: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' * * Visit http://www.computerstaff.net - Compu

MySQL 4 and WINDOWS

Hello, Has anyone managed to compile the BETA version of MySQL 4 for Windows? I have downloaded the source however, it appears to be for LINUX or UNIX. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *

RE: Pound (£) Symbol and MySQL

Hello All, I have tried the settings as suggested in this FORUM like using htmlentities etc... however, my pound sign in the database is displayed as: ú Any more tips help etc... > -Original Message- > From: technical Support [mailto:[EMAIL PROTECTED]] > Sent: 07 June 2001 2

Pound (£) Symbol and MySQL

Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like &8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? *

Oracle 2 MySQL

Hello, Does anyone know of any tool that will take an ORACLE database and port it to mySQL? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * *

RE: Fulltext Strange Results...

; From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] > Sent: 20 May 2001 22:44 > To: technical Support > Subject: Re: Fulltext Strange Results... > > > Hi! > > On May 20, technical Support wrote: > > > > I have just done this: > > select * from indexed_table

Fulltext and phrases

I have just done this: select * from indexed_table where match(indexed_col) against ('"visual basic"') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. ***

RE: Fulltext Strange Results...

* > -Original Message- > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] > Sent: 20 May 2001 20:51 > To: technical Support > Subject: Re: Fulltext Strange Results... > > > Hi! > > On May 20, technical Support wrote: > > Hello, &g

Fulltext Strange Results...

Hello, I did the following query against my indexed table: select * from indexed_table where match(indexed_col) against ('oracle +sybase +london') It returned 16 rows of which only 4 rows included all words. I then did: select * from indexed_table where match(indexed_col) against ('+oracle

Fulltext and 2 to 3 character words...

Hello, I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len = 0. However, my a query like select * from table_name where match(col) against('asp') returns nothing, when a similar like query returns several rows of data. Also a query like select * from table_name where match