|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
April 15th, 2004, 07:56 PM
|
|||
|
|||
|
PHP / MySQL INSERT not working
Amigos !!
Hello. I am having trouble with a very simple script. Could someone please look this over and help me out? I do have other script that I wrote more a tutorial that work fine, this one does nothing and writes nothing to the database. This just refreshes the page and writes nothing to the db. I get no errors or stops or anything. Help me Obi wan etc etc thanks, starfruitman using mac os x, apache, php 4.3.4, mysql 3.23, yourSQL === <HTML> <?php error_reporting(E_ERROR | E_WARNING); // $navigate=$_POST[navigate]; $desc=$_POST[desc]; $submit=$_POST[submit]; $update=$_POST[update]; // if($_submit) { $db = mysql_connect("localhost","root","password") or die ( mysql_error() . "n" ); mysql_select_db("learndyn",$db) or die ( mysql_error() . "n" ); $sql = "INSERT INTO dyno (navigate, desc) VALUES ('$navigate','$desc')"; $result = mysql_query($sql) or die ( mysql_error() . "n" ); echo "Thank you! Information entered.n"; } else { ?> <form method="post" action="<?php echo $PHP_SELF?>"> First name:<input type="Text" name="navigate"><br> Last name:<input type="Text" name="desc"><br> <input type="Submit" name="submit" value="Enter information"> </form> <? } ?> </HTML>
|
|
#2
April 15th, 2004, 11:28 PM
|
|||
|
|||
|
RE: PHP / MySQL INSERT not working
FYI - you may get a SYNTAX ERROR in MySQL for using one of their RESERVED words as a variable or table column name. I figured this out the hard way. The word "desc" is one of them.
read on: http://dev.mysql.com/doc/mysql/en/Reserved_words.html
|
|
#3
April 16th, 2004, 03:27 AM
|
|||
|
|||
|
RE: PHP / MySQL INSERT not working
You can use backquotes for tablenames and fieldnames to solve this problem..
$sql = "INSERT INTO `dyno` (`navigate`,`desc`) VALUES ('$navigate','$desc')";
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > PHP / MySQL INSERT not working |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
