Jason Pruim wrote:

On Sep 26, 2008, at 11:22 AM, muhsin wrote:

Could you guys share your development setup, like what kinds of software (IDE's/Editors) you are using for developing php scripts? It might sound silly but I am just curios, as I just got started in php programming en i have firefox + kate/bluefish + LAMP built with gentoo. Im mostly thinking that with only firefox and some logs left /var/log or so, its not enough for me..Im looking for something like an IDE which can allow me to debug code in steps in central manner approach (ide), simplicity and efficiency...u know what i mean? :-D

Just kiddin bout simplicity ;-)

this has been discussed quite a bit over the years, but I just thought I'd pipe up since I was in your spot a little over a year ago... What I did then, and still do when I can't figure it out from the error log is just a lot of echo "N"; through the application. That way, when I see it makes it to 5 but not 6 I check the code between 5 and 6 and I can usually spot the problem now.

If nothing else, it'll help you narrow down the problem before asking questions here which most people are more then happy to do :)

Also... If you are dealing with databases (Since this is the DB list :)) I'd recommend to echo out your db statements to make sure you are doing what you think you are doing... Can't tell you how many times that screwed me up...

Just my experience, take it or leave it :)


Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424

Thanks Jason,

Actually its a Db/mysql-5.0.60-r1 issue which makes me wonder about debugging techniques php. Im stuck with this on my early scripts that im experimenting.These are the echo of the SQL part:

INSERT INTO movietype (movietype_id, movietype_label) VALUE (1, 'Sci Fi'), (2, 'Drama'), (3, 'Adventure'), (4, 'Comedy'), (5, 'Horror'), (6, 'Action'), (7, 'Kids')

INSTERT INTO people (people_id, people_fullname, people_isactor, people_isdirector) VALUE (1, 'Jim Carrey', 1, 0), (2, 'Tom Shadyac', 0, 1), (3, 'Lawrence Kasdan', 0,1), (4, 'Kevin Kline', 1, 0), (5, 'Ron Livingston', 1, 0), (6, 'Mike Judge', 0, 1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSTERT INTO people (people_id, people_fullname, people_isactor, people_isdirect' at line 1

Followed by:
Duplicate entry '1' for key 1

And i just can narrow down whats hapenning on that part, which one of my early scripts ...any idea? The error is probably related the 2nd dB statement , but i cant figure out whats making it throwing error :-


Extra details:
OSS:Gentoo Linux-2.6.24
Hardware:x86-64 msi geforce 8600GT asus p5k-se
server(s) owned:

Reply via email to