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 haven´t really been following this from the beginning, but you seem to have forgotten something in the first elseif. $CuisineTemp = 'ALL' should be $Cui

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 id´s from the other two, thus making the search much faster. How do t

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: Connec

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 th

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 T

Re: archive of old mails in lists?

2001-01-17 Thread Tobias Talltorp
Or here: http://marc.theaimsgroup.com/?l=mysql&r=1&w=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" <[E

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 m

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 doesn´t come in the right order. The table looks like this: +-+--+ | ID | headline