Databases
in [PHP]
|
"Fatal error: Call to undefined function pq_query()" What the... What is causing this? I can use "pg_connect" without complaint, why does pq_query give this problem? PHP 5.3.1 FWIW. ... 13 Apr 2010 05:07
mySQL date query I am trying to write a mySQL query on my "stats" table. I am trying to determine the number of records (users) during a 7 day period ending yesterday. I always to keep it current ... Yesterday will keep changing. In other words I want to know the number of users who accessed the web site during seven full days. ... 13 Apr 2010 02:57
Postgres - how to skip 'sequence' columns Is it possible to skip column(s) in the target table when using pg_copy_from? When I tried to bulk insert some data from a csv file by way of pg_copy_from I received the error "Warning: pg_copy_from() [function.pg-copy-from]: Copy command failed: ERROR: permission denied for relation xyz", pretty much as I expecte... 13 Apr 2010 02:57
Mysql completing Query fast but mysql->query() takeslong time to return even single selects/updates David Murphy wrote: As you can see PHP claims it took 20 seconds for mysql->query() to return but mysql think is took around 1.0s This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount of d... 11 Apr 2010 20:09
phpmailer/mysql/ timout issues I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop through a while statement to send about 3000 email using phpmailer. It's worked well in the past but after an upgrade it seems to be timing out now after 200-300 emails over 1 minute or two. I've added set_time_limit(30) within the whil... 11 Apr 2010 20:09
Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates As you can see PHP claims it took 20 seconds for mysql->query() to return but mysql think is took around 1.0s This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount of duration took place. Is there any... 12 Apr 2010 11:27
mysql/php time out issue I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop through a while statement to send about 3000 email using phpmailer. It's worked well in the past but after an upgrade it seems to be timing out now after 200-300 emails over 1 minute or two. I've added set_time_limit(30) within the ... 9 Apr 2010 10:02
MySQL vs. Session array Quick question. I have an AJAX component that fires a "like" query for each "key up" event (since it's a like % query there is no indexing or caching possible). While everything works fine, I was contemplaining downloading the ~1500 rows into a session var as array, offloading the (seperate) mysql server an... 7 Apr 2010 19:11
reading PDF file into a DB Hello Guys, I am working on a project, which requires a PDF file to be read page wise into the DB, once it has been uploaded, the contents from the PDF would then appear on a Flash screen. I need help reading the contents of the PDF file into DB retaining the page numbers, does anyone have an idea how this can... 7 Apr 2010 23:38
imagecopyresize??????? Hello List, I am hoping this will be a quick and easy for someone to help me with. I am trying to create an upload form that lets a user upload a product photo to the server. In the process of this upload, I want to take the file they are uploading and create two images to put on the server. Both are specific... 6 Apr 2010 05:19 |