mySQL?!
| From: | Fredrik Arild Takle | Date: | Fri, 07 Jul 2000 08:57:28 +0000 |
| Subject: | mySQL?! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-928@lists.php.net to get a copy of this message | ||
I am working on a form to insert books in a mySQL database, I belove you can see the source of
do_insert.phtml, i also have a page named insert.phtml w/ forms, the textboxes are named title,
author, publisher.... I don't get any results of my INSERT command...
pwinfo.php contains information about how to connect to mySQL database, common.php is often used
commands!
I can't find the error, what could i do different? Should I include it all in one page? How?
<?
require 'pwinfo.php';
require 'common.php';
$insertquery = "INSERT INTO biblio_main (no, title, author, publisher, year, section, status,
ISBN, date, bokid) VALUES ('$no', '$title', '$author',
'$publisher', '$year', '$section', '$status',
'$isbn', '$date', '$bokid')";
$insertresult = mysql_query ($insertquery);
?>
PS! I have the same problem when updating books that already are registered!
Best Regards
Fredrik Arild Takle
ftakle@online.no
NORWAY