I'm using PHP and MySql to create web pages that access databases. I had built a database with two tables populated with data. I had written some php scripts and html that accessed the two tables fine. But I'm having trouble with this third table I've created. I wrote another php script accessing a table called customers and the one the table with problems, called discussion. Within the same script, the customer select query works fine, but the discussion insert query will not work no matter what i do. I'm pretty good at writing scripts, and I've checked and double checked a million times, so I don't think its a mistake in my code. I've also tried doing update and delete queries on the discussion table with no luck, only a select query gets through. Also, somehow, the MySql GUI (Sqlyog) is able to perform an insert query just fine. What could be happening?

DWMX | PHP | MySql

Edited by - mackgyver22 on 25 Nov 2006 19:35:50

Edited by - mackgyver22 on 25 Nov 2006 19:37:10

Edited by - mackgyver22 on 25 Nov 2006 20:32:06

Edited by - mackgyver22 on 25 Nov 2006 20:32:54

I figured out the problem. I didn't assign enough char space for one of my columns. So naturally I kept getting my own coded query did not execute, error message.

DWMX | PHP | MySql