Re: mySQL/php query help

2001-02-14 Thread Tobias Talltorp
ok, here is the code that runs after the submit button is clicked. i now suspect that it has something to do with my "if" statements. I havent really been following this from the beginning, but you seem to have forgotten something in the first elseif. $CuisineTemp = 'ALL' should be

Search engine database structure

2001-01-25 Thread Tobias Talltorp
As I understand it, search engines use a "special" type of database structure. They have a special table for common words/phrases and another one with all the data. They link theese together by a third one that contains only the ids from the other two, thus making the search much faster. How do

Re: Connection to remote Mysql Server.

2001-01-24 Thread Tobias Talltorp
How about Putty? It is very simple, but it fulfills most of your needs. http://www.chiark.greenend.org.uk/~sgtatham/putty/ // Tobias - Original Message - From: "Rajesh Prakasan" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 2:03 PM Subject:

Re: Win2K and MySQL

2001-01-23 Thread Tobias Talltorp
Is the error 1067-something? In that case there could be something wrong with the my.cnf file. can you see the extension .cnf in the windows explorer? If you do, remove it, the filename then is actually my.cnf.cnf. The problem I had was when I wanted to update from 3.22 to 3.23, but it could be

Insert-Select problem

2001-01-19 Thread Tobias Talltorp
I am performing a query in two tables and output it into a temporary table for further sorting. The problem is that in one of the tables (TableB), I have an additional id that I want to be added to the temptable. This id is not present in TableA. I get this error message when I run the query for

Searching in different tables

2001-01-17 Thread Tobias Talltorp
I have three tables of different data which I need to make a search in. Every table has a column for date, heading, body and author. I need to be able to search (WHERE column LIKE 'search') in heading, body and/or author in all three tables, ORDER BY the latest date, and LIMIT 20. If I want to

Re: archive of old mails in lists?

2001-01-17 Thread Tobias Talltorp
Or here: http://marc.theaimsgroup.com/?l=mysqlr=1w=2 The difference I saw on the two mailing list searches is that theaimsgroup orders by date and mysllist orders by the most replys... // Tobias - Original Message - From: "Rolf Hopkins" [EMAIL PROTECTED] To: "Richard Ellerbrock" [EMAIL

query executes too slow

2001-01-15 Thread Tobias Talltorp
I have a table with 2 fields which I, every fifteen minutes, load new data into. The data is not formatted by me. It comes from an external source, so when the data is added to the table, the ID doesnt come in the right order. The table looks like this: +-+--+ | ID | headline