I tried using error_log() but never got any emails... error_log("This is query2 inserting $ctrl_no $category $contact_no $organization_name $address $telephone $fax $email", 1, "elijah@xxxxxxxxxxxxxxxx"); looks like it never went in the for loop, somethings wrong... Thanks for the advice, Elijah On Sat, 2004-07-10 at 03:08, brew@xxxxxxxxxxx wrote: > Elijah..... > > > There are no errors whatsoever, must be something wrong with the logic > > somewhere... > > What I do when I can't find errors is break down the code into > smaller steps and add error checking. > > Make the connection and check the return value. > > Put together the sql statement and print it. > > Query the database and check the return value. > > and so forth..... > > Check php.net to see some examples of error checking. > > On another note, if I'm only working with only one db I just connect once > near the start of the script and then use that connection for the > subsequent calls. > > brew > > ========================================================================== > Strange Brew (brew@xxxxxxxxxxx) > Check out my Musician's Online Database Exchange (The MODE Pages) > http://www.TheMode.com > ========================================================================== > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match