Re: [PHP-DB] Table optimization ideas needed

From a quick perusal of the article Chris mentions, I'd generally agree with that view about table optimization -- I'm not an expert on Postgres, but the recommendations generally seem to apply to MySQL as well. My basic view is that, if you are routinely doing a select on millions of rows, y

[PHP-DB] HTML & CSS (Off Subject) 911 Help! :-)

Hey guys, I know this is a php-database forum. I have tried other forums, and no one seems to be able to help. I need some help on formatting issues. I am trying to create a table that will fit with in my template. I do not want the table width to push the template. I need to have three

Re: [PHP-DB] curl image into mysql.

richard lee wrote: hi, i got a problem insert a image that downloaded into mysql database, because when i echo $sqlCmd, it output $data in binary file, please help thanks http://www.phpbuilder.com/columns/florian19991014.php3 -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP

Re: [PHP-DB] Prevent global usage of last MySQL-Connection?!

I recognized the problem is: if no specific resource is given in mysql_connect() the function uses automatically the last connection. SO MY QUESTION IS NOW: HOW TO PREVENT THIS? You can't unless you want to modify the php source code (written in C) and then you're stuck running a modifie

Re: [PHP-DB] Query Across DBMS Boundaries (Linked Database Servers?)

Dee Ayy wrote: Is there something which can perform a query across different database systems? It would extend the database.table.field notation to maybe dbms.database.table.field and allow queries across MySQL and MSSQL I don't think so. Both mysql and mssql would need to know how to parse t

Re: [PHP-DB] Table optimization ideas needed

Shelley wrote: Hi all, I made a post a week ago to ask for the idea of the fastest way to get table records. Fyi, http://phparch.cn/index.php/mysql/35-MySQL-programming/126-fastest-way-to-get-total-records-from-a-table Look at the time even a 'count(1)' took. Then you can imagine how much

[PHP-DB] Table optimization ideas needed

Hi all, I made a post a week ago to ask for the idea of the fastest way to get table records. Fyi, http://phparch.cn/index.php/mysql/35-MySQL-programming/126-fastest-way-to-get-total-records-from-a-table Look at the time even a 'count(1)' took. Then you can imagine how much time sql such as "s

[PHP-DB] Table optimization ideas needed

Hi all, I made a post a week ago to ask for the idea of the fastest way to get table records. Fyi, http://phparch.cn/index.php/mysql/35-MySQL-programming/126-fastest-way-to-get-total-records-from-a-table Look at the time even a 'count(1)' taken. Then you can imagine how much time sql such as "

[PHP-DB] Only 3 days left for PostgreSQL Conference

Online registration ends for PostgreSQL Conference East on March 26th at 5:00pm PST. PostgreSQL Conference: East is being held at the Univerisity of Maryland, College Park in the CSIC building. The conference series is designed to be a geographically strategic series of conferences that allow con

[PHP-DB] Re: [PDO] Cannot execute queries while other unbuffered queries are active

Have you tried using closeCursor() after your query is finished? -Roberto Fabian Golle wrote: > Hey, > > I'm using a PDO-MySQL in a class of my Accounting-Framework. The problem: if > I call my function query(), see below, multiple times, I get the error: > > > > Array ( [0] => HY000 [1] =>