Category Archives: mysql

Error installing apache,php on windows vista

Posted on March 26, 2009 by dreamluverz

ShareI’ve done this before, I’ve installed it several times but how come this time it’s not working with the same settings that needed to be changed… a moment of confusion, annoyance and craziness flashed on my eyes. I’ve exerted every … Continue reading →

Posted in apache, linux, mysql, php | 1 Comment

Installing apache 2.2, php 5.2 and mysql 5 in windows vista

Posted on March 26, 2009 by dreamluverz

ShareHere’s a quick guide for installing apache 2.2, php 5.2 and mysql 5 in windows vista. Download needed files: 1. Apache – msi file 2. PHP – better choose the zip file than the msi installer 3. MYSQL – msi … Continue reading →

Posted in apache, mysql, php | Tagged , , , , , | Leave a comment

SET SQL_BIG_SELECTS=1

Posted on February 26, 2009 by dreamluverz

ShareI encountered this error on my query. I had the same query on my local computer, running without any problem but uploading it on the live site I got this error below: The SELECT would examine more than MAX_JOIN_SIZE rows; … Continue reading →

Posted in mysql | Tagged , , | Leave a comment

mysql_data_seek to reset mysql recordset in php

Posted on February 13, 2009 by dreamluverz

ShareI’ve been into this situation where I need to reset the recordset for mysql and one way to do this is by using mysql_data_seek(). Sample below from mysql site: Description bool mysql_data_seek ( resource result, int row_number ) mysql_data_seek() moves … Continue reading →

Posted in mysql, php | Tagged , | Leave a comment

Data truncated for column

Posted on January 21, 2009 by dreamluverz

ShareFirst time I got this error Data truncated for column. I’m using mysql version 5 and I got a simple query like this: $val1= 1; $val2 = 3; INSERT INTO TBL(‘val1′, ‘val2′) VALUES ($val1, $vall2); Notice the variable name for … Continue reading →

Posted in mysql | Tagged , , , | Leave a comment