My first hand written mySQL /PHP code
Posted: Mon Feb 09, 2004 9:04 am
I have been building this alll day and I am bewildered
I get this error:
Does anybody know why and how I fix it?
Code: Select all
<?php
<?
if($submit)
{
mysql_connect("host","-","-");
mysql_select_db("dbname");
$result=MYSQL_QUERY("INSERT INTO tablename (yrname,email,phone,address,thetitle,description,qty,price)".
"VALUES ('$yrname', '$email', '$phone', '$address', '$thetitle', '$description', '$qty','$price')");
print "This file has the Database";
}
else
{
<form method="post" action="submit.php">
name:
<br>
<INPUT TYPE='TEXT' NAME='yrname' VALUE='your name' size=60>
<br>
e-mail:
<br>
<INPUT TYPE='TEXT' NAME='email' VALUE='your e-mail' size=60>
<br>
phone no:
<br>
<INPUT TYPE='TEXT' NAME='email' VALUE='your phone no.' size=60>
<br>
address:
<br>
<INPUT TYPE='TEXTAREA' VALUE='address' VALUE='your address' rows=10 columns="60"></textarea>
<br><br>
<b>title of item:</b>
<INPUT TYPE='TEXT' NAME='title' VALUE='title' size=60>
<br>
description:<INPUT TYPE='TEXTAREA' VALUE='description' VALUE='description' rows=15 columns="70"></textarea>
<br>
quantity:
<INPUT TYPE='TEXT' NAME='qty' VALUE='1' size=60>
<br>
price:
<br>
<INPUT TYPE='TEXT' NAME='price' VALUE='00.00' size=60>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
}
mysql_close ();
?>
?>Code: Select all
Parse error: parse error in /home/virtual/site28/fst/var/www/html/cpCommerce/submit.php on line 15