[PHP-DB] Re - Direct a User after a completed Form

[Ethan J. Mings]

PHP-DB Mailing List
--

I've created a form which loads data to my data table.  Works great.

Is there a way to allow the user to go to a thank you after the form
is completed. Where could I find this is the manual.

Tried Location() with little success.

Suggestions.





--
Ethan J. Mings
mailto:[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Insert into command - PHP

[Ethan J. Mings]

Crafted from The Desk on location in the Quality Lab.
Hello PHP,
--

I'm using the mysql_query() function.
I have 61 fields (e.g, '$fname','$lname'etc) to insert into the data
table.

No matter what I do, the data is not loaded into the table.

I've tried smaller tables with less than 11 fields and the data is
loaded correctly.

Question:
[1] Does PHP have a limit on the number of fields?
[2] How does one stop the line from running to the right. \n does
not appear to work.


Any insights would be extremely helpful. If you can point me to a
direct resource on the web, I'm glad to do the homework.

Thanks.
-- 
Best regards,
Ethan J. Mings
mailto:[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re[4]: [PHP-DB] Insert into command - PHP

[Ethan J. Mings]

PHP-DB Mailing List
Hello Jonathan,
--
Friday, March 29, 2002, 12:16:19 PM, you wrote:


 It should be:

   $sql = Insert into table ('$field1','$field2',,'$field61');
   mysql_query($sql) or die(msql_error());

Thanks that is helpful.


 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());

I re coded as per the suggestion above.  Still, I get a new error
message,

You have an error in your SQL syntax near  at line 55.


Line 55 is R38='$R38',



 ... 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).
   field2='value';
   ;


Any suggestions.

Jerry


-- 
Ethan J. Mings
Office E-mail [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php