Re: Insert MySQL/PHP

Mike, Have you fallen foul of the 'new' super-globals concepts? =dn > Using RH 7.3 PHP 4.2.2 MySQL 3.23.51 MySQL Client 3.23.29 Apache 1.3.26 > > I used the LAMP script to compile and build all and all of the PHP works > except for inserts. > > I can insert from MyCC, phpMyAdmin, command line just fine but when > trying to use a php file that I used to use it will not insert or show > any errors.PS I like MyCC!!! Very nice!! > > I made the file chmod 666 and tried both my root and my normal user > accounts. > > Here's the code.Note: I changed the names to post so one might be > wrong<G> > > > <? > // if form has not been submitted, display form > if (!$submit) > { > ?> > <html> > <head> > <basefont face=Arial> > <h3>Enter the upload sites:</h3> > <form method="POST" action="insert.php"> > <table> > <tr> > <td> > sitename > </td> > <td> > <input name="sitename" length="10" maxlength="50"> > </td> > </tr> > <tr> > <td> > sent link > </td> > <td> > <input name="sent_link" length="30" maxlength="30"> > </td> > </tr> > <tr> > <td> > notes > </td> > <td> > <input name="notes" length="60"> > </td> > <tr> > <td> > asta > </td> > <td> > <input name="home" length="30"> > </td> > </tr> > <tr> > <td> > wireless > </td> > <td> > <input name="wireless" length="30" maxlength="30"> > </td> > </tr> > <tr> > <td> > wired > </td> > <td> > <input name="wired" length="30" maxlength="30"> > </td> > </tr> > <tr> > <td> > day 2001-07-01 > </td> > <td> > <input name="day" length="11" maxlength="11"> > </td> > </tr> > <td colspan="2" align="center"> > <input type="submit" name="submit" value="Submit"> > </td> > </tr> > </table> > </form> > </body> > </html> > <? > } > // or process form input > else > { > ?> > <?php > > // connect to database > $connection = mysql_connect("localhost", "me", "canttellyou") or > die("Invalid > server or user"); > > // select database > mysql_select_db("insert",$connection); > > // formulate and run query > $query = "insert into > skywire(sitename,sent_link,notes,home,wireless,wired,day) > values('$sitename','$sent_link','$notes','$home','$wireless','$wired','$day' )"; > > $result = mysql_query($query,$connection) or die("Error in > query"); > > ?> > > <html> > <head> > <basefont face=Arial> > </head> > <body> > <center> > <P>Success!</43> > <table> > <tr> > <td> > <?php echo $username; ?> uploads have been saved. > </td> > </tr> > <p>Return to the list <a href="home.php">home list</a></p> > </center> > </body> > </html> > > <? > } > ?> > > Cheers > > Mike > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql-thread116319@lists.mysql.com> > To unsubscribe, e-mail <mysql-unsubscribe-PHPml=dande.homechoice.co.uk@lists.mysql.com> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > >