Query trouble

    Date: 02/02/08 (MySQL Communtiy)    Keywords: php, mysql, sql

    Hi!

    According to my host, this query is blocking the mysql by causing a max_user_connections error, but I can't see the problem in it. Can anyone help me, please?

    (The code is PHP)

    $query = "SELECT $entries_table.fic_title, $entries_table.id, $entries_table.fic_url, $entries_table.wip, $entries_table.notes, $entries_table.date, $entries_table.hits,
    $fic_cats_table.fic_id, $fic_cats_table.cat_id
    FROM $fic_cats_table
    LEFT JOIN $entries_table ON $entries_table.id = $fic_cats_table.fic_id
    WHERE $fic_cats_table.cat_id = $cat AND $entries_table.date = '$date' ";

    Source: http://community.livejournal.com/mysql/125324.html

« multiple categories per entry? || Connecting to online... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home