RE: [PHP-DB] PHP && MySQL: temporary table problem

2003-01-24 Thread Damir Dezeljin
Hi. > I would like to know, if there is any change to export/import data from > SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way > please help me. HeHe ... I don't know how this is related to my question, but. To import directly in Excel from MySQL, you can use MyODBC (I s

[PHP-DB] PHP && MySQL: temporary table problem

2003-01-24 Thread Damir Dezeljin
Hi. I got a task to program a search engine for a site which is all around based on sessions and persistent connections to MySQL. The problem is that I first have to select a subset of those data and then I have to join them all around and output results. I'm using temporary tables for this but

[PHP-DB] QUERY question (group by) - please help

2003-01-10 Thread Damir Dezeljin
Hi. Maybe this isn't the correct list for asking the below question (if so sorry ;) ). I want to calculate how many rows my MySQL query which uses 'GROUP BY' returns. The query: SELECT FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible to get nu