RE: Re[2]: [PHP-DB] Insert into command - PHP

Well first, I don't know if you copied and pasted directly from your file, but you're building your query in the variable $sql AFTER you run the query: mysql_query($sql) or die(msql_error()); $sql = "Insert into table ('$field1','$field2',....,'$field61')"; It should be: $sql = "Insert into table ('$field1','$field2',....,'$field61')"; mysql_query($sql) or die(msql_error()); However, you should also use the coding practice of: $sql = "INSERT INTO table SET NameOfField1='ValueOfField2',Field2='Value',Field3='Value', etc....;" It's a little easier to read and understand. Note that you don't really have to do anything special to be able to separate the query onto multiple lines: $sql = "INSERT INTO table SET field='value', field2='value'; "; mysql_query($sql) or die(msql_error()); ... will work fine. No need for special characters - PHP will recognize values and strings that are on multiple lines AS LONG AS the value starts and ends with quotes (and the semicolon at the end). - Jonathan -----Original Message----- From: Ethan J. Mings [mailto:qualityoffice@consultant.com] Sent: Friday, March 29, 2002 9:11 AM To: Jonathan Hilgeman Subject: Re[2]: [PHP-DB] Insert into command - PHP PHP-DB Mailing List Hello Jonathan, -- Friday, March 29, 2002, 11:53:31 AM, you wrote: > ...after you have run the query. Give us the output and your query and we > can help a bit more. Hi, thanks for the follow up. I included the following command in the line... mysql_query($sql) or die(msql_error()); $sql = "Insert into table ('$field1','$field2',....,'$field61')"; The message returned was, "Query was empty" I am suspect of the 61 fields. The line travels far out to the right. Is there a way to properly code the line so it does not go so far to the right. Otherwise, no other report errors. -- Ethan J. Mings Office E-mail thedesk@ejmings.com