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