$result = mysql_db_query($db,"$SQL",$cid) or die (mysql_error());
...should give you and idea.
On Sun, 22 Sep 2002 12:05:19 +0000, Brandon Boyce wrote:
> Below is the code I used to try to insert info into a mysql database, the
> form posts to itself. After I hit the submit button it isn't echoing the
> indication that information has been added, and when I check the database
> there isn't anything there. help please!
>
> <?
> $usr = "username";
> $pwd = "password";
> $db = "dbname";
> $host = "localhost";
>
> # connect to database
> $cid = mysql_connect($host,$usr,$pwd);
> if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
>
> ?>
> <HTML>
> <HEAD>
> <TITLE>Insert Link</TITLE>
>
> </HEAD>
> <BODY BGCOLOR="#FFFFFF">
>
> <P><FONT SIZE=5><B> Add Link </B> </FONT></P>
>
> <?
> if ($REQUEST_METHOD=="POST") {
>
>
> $description = str_replace("'","''",$description);
> $sitename = str_replace("'","''",$sitename);
>
>
> $SQL = " INSERT INTO links ";
> $SQL = $SQL . " (category, sitename, siteurl, description) VALUES ";
> $SQL = $SQL . " ('$category', '$sitename','$siteurl','$description')
> ";
>
>
> $result = mysql_db_query($db,"$SQL",$cid);
>
> if (!$result) { echo("ERROR: " . mysql_error() .
> $SQL\n"); }
>
> echo ("<P><B>New Link Added</B></P>\n");
>
> }
>
> ?>
>
> <FORM NAME="fa" ACTION="insert.php" METHOD="POST">
> <TABLE>
> <TR><TD><B>Category: </B> </TD><TD><INPUT TYPE="text" NAME="category"
> SIZE=40></TD></TR>
> <TR><TD><B>Site Name:</B> </TD><TD><INPUT TYPE="text" NAME="sitename"
> SIZE=40></TD></TR>
> <TR><TD><B>Site URL: </B> </TD><TD><INPUT TYPE="text" NAME="siteurl"
> VALUE="http://"; SIZE=40></TD></TR>
> <TR><TD VALIGN=TOP><B>Description: </B> </TD><TD> <TEXTAREA
> NAME="description" ROWS=5 COLS=40></TEXTAREA></TD></TR>
> <TR><TH COLSPAN=2><P><INPUT TYPE="submit" VALUE="Add Link"></P></TH></TR>
> </TABLE>
> </FORM>
>
>
> <? mysql_close($cid); ?>
> </BODY>
> </HTML>
--
Jason Morehouse (jm[@]netconcepts[.]com)
Netconcepts - http://www.netconcepts.com
Auckland, New Zealand
Linux: Because rebooting is for adding hardware.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
