Re: php and sql problem with mysql_query and insert

Guess what? add this on top of the file: error_reporting(E_ALL); this will probably tell you these variables are unset :) Why? Register global... wrong logic... etc... What php 4 is exactly installed there? -- Maxim Maletsky maxim@php.net "Sunfire" <rusty_81@msn.com> wrote... : > hi ... > > im having a little problem with mysql_query("insert into members > ('$company', '$name1', '$name2', '$address1', > '$address2', ''$ac1', '$ext2', > '$num1', '$ac2', '$ext2', '$num2', '$city', > '$state', '$zip', '$desc', > '$flags')"); > > for some reason those variables are empty by the time they get into the > table... > im running mysql 3.2.3.x, php 4 used as module in apache, windows me and > apache 1.3.4xxxx the variables come from a form and then posted to a > comfirmation page where all the contents of the variables are printed in a > table before user would click the continue link at the bottum of the > page... after that the link would call a file called addtolist.php which > would add the var list to a table and return either an error message or a > success message.. i havent yet found how to have a php script load a new web > page other than include() or require() and dont know if that is making my > problem or just what it is... i will include the test file called > addtolist.php below...: > <?php > mysql_db_query("wata", "insert into members VALUES('$company', > '$name1', > '$name2', '$address1', '$address2', '$city', > '$state', '$zip', '$ac1', > '$ext1', '$num1', '$ac2', '$ext2', '$num2', > '$desc', '$flags')"); > echo "\n"; > echo mysql_error(); > > echo <<<ENDOF_BLOCK > $post['name1'] > your entry was added!!!! > > go back to the main menu by clicking <a href="main.htm">here</a>. > ENDOF_BLOCK; > ?> > tnx for the help > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >