Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-28 Thread Martin Zvarík
Thanks Tim, this helped me a lot. Martin Tim Hawkins napsal(a): If you are looking at future expansion then the separate DB per blog is defiantly the way to go. Some notes: 1) Avoid joins like the plague, in fact most operations on a blog application would consist of getting primary reco

[PHP-DB] Re: Could not run query

2008-09-28 Thread Martin Zvarík
Have you tested this SQL query? Insert it into phpmyadmin, does it work? If it does => php error. If it doesn't => mysql error. boclair napsal(a): I need help to track down the cause of the error,"Could not run query" A typical query is $laterrecords = mysql_query("SELECT * FROM messages WH

Re: [PHP-DB] Could not run query

2008-09-28 Thread danaketh
Well, seems to me like a problem with quotes you're using in query... The ` quotes you're using doesn't work, when I tried to use them in PHP called query. Maybe you should try use single quotes and if they works. boclair napsal(a): I need help to track down the cause of the error,"Could not r

Re: [PHP-DB] Could not run query

2008-09-28 Thread Martin Zvarík
The quotes are OK. Tested - works. danaketh napsal(a): Well, seems to me like a problem with quotes you're using in query... The ` quotes you're using doesn't work, when I tried to use them in PHP called query. Maybe you should try use single quotes and if they works. boclair napsal(a): I

[PHP-DB] Re: Could not run query

2008-09-28 Thread Sandy Keathley
> I need help to track down the cause of the error,"Could not run query" > > A typical query is > > $laterrecords = mysql_query("SELECT * FROM messages WHERE `logged` > > $timebegin ORDER BY `logged` DESC" ) or die ("Cannot > select:$queryError: " . mysql_error()); Try putting single quotes

[PHP-DB] СуперПредложение

2008-09-28 Thread Антон
служба доставки электронных писем 8 (985) 195-44-53 [EMAIL PROTECTED]  ПРЕДЛОЖЕНИЕ реклама по юридическим и физическим адресам Москвы 4,63 миллиона писем ВСЕГО

Re: [PHP-DB] query optimization

2008-09-28 Thread Chris
Yves Sucaet wrote: Hi Jack, I'm expecting less than 10 records in the resulting set. The BlockUnit table contains 337,253 records; the InteractionParts table contains 279,953 records. It takes currently 8.3 seconds to execute the query as I have it. Erh, this is embarassing but I'm going to n

Fwd: [PHP-DB] query optimization

2008-09-28 Thread Bastien Koert
On Sun, Sep 28, 2008 at 6:28 PM, Chris <[EMAIL PROTECTED]> wrote: > Yves Sucaet wrote: > >> Hi Jack, >> >> I'm expecting less than 10 records in the resulting set. >> The BlockUnit table contains 337,253 records; the InteractionParts table >> contains 279,953 records. >> >> It takes currently 8.3