At 9:44 -0500 5/13/03, Marriner, Bruce W. wrote:
> If you execute the insert query first does it fail? Is the
>problem that it's dieing on a SECOND mysql_query command or is it
>related to the query itself. Have you changed it so you execute two
>selects back to back or just different safe queries like "select
>count(*) from customers" to narrow the problem a bit. Also like
>previously stated use the mysql_error() function to give you more
>detailed information. The insert statement needs a space between the
>word "customers" and "(name)" but I'll assume that's not the problem :).
>Also, The book MySQL by Paul DuBois (Sams) is my official bible. It's
>the best one I've read -- So you might skim over that at your local
>bookstore. It's got a pretty good API section for C.
This particular chapter also happens to be online at the book's
companion web site: http://www.kitebird.com/mysql-book/
It's a PDF document.