Re: This query shouldn't be wrong, but mysql says it is???

You cannot use update on two tables. Check the mysql manual on syntax of update. Haifeng - Original Message - From: "Lai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 1:43 PM Subject: This query shouldn't be wrong, but mysql says it is??? > Hi. > > Here

Strange problem on the difference of mysql connection between cgi and shell

Hi, I am coding a cgi program to query the records from the mysql tables. When I execute the sql query (which is a join operation on two tables) in the mysql shell, the results are shown correctly. However, if I use cgi script to execute the same query, the web browser just crashed after a while