Try $result_insert = @mysql_query ($query_insert) or die(mysql_error); -----Original Message----- From: Dan Bowkley [mailto:dan@xxxxxxxxxxxxxxxx] Sent: Tuesday, May 04, 2004 08:37 To: php-db@xxxxxxxxxxxxx Subject: Re: lamer noob with repeat question Anyone? ----- Original Message ----- From: "Dan Bowkley" <dan@xxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Sunday, May 02, 2004 1:21 AM Subject: lamer noob with repeat question > Hello everyone, > > I've been working on (read:tearing my hair out over) my mom's website for > some time now. Specifically, I'm trying to get her work order database up > and running. > > The basic idea is this: you start out adding a new record by going to > add.php. It sees that you've not done anything yet and thus presents you > with a form to fill out. That form gets submitted to add.php, which sees > that you're adding something. It checks for a duplicate work order number > (and eventually other errors) and then either adds the stuff you submitted > into the DB, or pops an error and presents the form again. > > Alas, it does nothing. > > When you initially load the page, it works okay, sensing that you've not yet > done anything and displaying the form. But when you submit data, it spits > out naught more than a blank page, and doesn't add anything to the database. > > Damned lazy script. > > > What I've got so far is this: > > <html> > <head><title>The Board Lady - Work Order Database 0.1a</title></head> > <body> > <?php > define ('DB_USER', 'user'); > define ('DB_PASSWORD', '********'); > define ('DB_HOST', 'localhost'); > define ('DB_NAME', 'boardlady'); > $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not > connect to database: ' . mysql_error()); > @mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' . > mysql_error()); > $page_req=$HTTP_GET_VARS['action']; > if ($page_req == "") {$page_req="0";} > if ($page_req == "0") { > echo "SWORD data entry<br>\n"; > echo "<form action=\"add.php\" method=\"get\">"; > echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n"; > echo "Customer Name: <input type=\"text\" name=\"name\"> Phone: <input > type=\"text\" name=\"phone\"><br>\n"; > echo "Email Addy: <input type=\"text\" name=\"email\"> Date In: <input > type=\"text\" name=\"date\"><br>\n"; > echo "Board Type and SN: <input type=\"text\" name=\"board_type\"> Last 3 of > SN: <input type=\"text\" name=\"last_three\"><br>\n"; > echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight Out: <input > type=\"text\" name=\"weight_out\"><br>\n"; > echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n"; > echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT > type=\"reset\"><br>\n"; > } > if ($page_req == "1") { > $wo_num=$HTTP_GET_VARS['wo_num']; > $name=$HTTP_GET_VARS['name']; > $phone=$HTTP_GET_VARS['phone']; > $email=$HTTP_GET_VARS['email']; > $date=$HTTP_GET_VARS['date']; > $board_type=$HTTP_GET_VARS['board_type']; > $last_three=$HTTP_GET_VARS['last_three']; > $weight_in=$HTTP_GET_VARS['weight_in']; > $weight_out=$HTTP_GET_VARS['weight_out']; > $query_testingforadupe = "SELECT job_no FROM boards WHERE job_no == $job_no > ORDER BY job_no ASC"; > $result_testingforadupe = @mysql_query ($query_testingforadupe); > if ($result_testingforadupe) { > echo "That's a duplicate work order number, you ditz. Try again, this time > without screwing it all up.<br><br>\n"; > echo "<form action=\"add.php\" method=\"get\">"; > echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n"; > echo "Customer Name: <input type=\"text\" name=\"name\"> Phone: <input > type=\"text\" name=\"phone\"><br>\n"; > echo "Email Addy: <input type=\"text\" name=\"email\"> Date In: <input > type=\"text\" name=\"date\"><br>\n"; > echo "Board Type and SN: <input type=\"text\" name=\"board_type\"> Last 3 of > SN: <input type=\"text\" name=\"last_three\"><br>\n"; > echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight Out: <input > type=\"text\" name=\"weight_out\"><br>\n"; > echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n"; > echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT > type=\"reset\"><br>\n"; > } > else { > $query_insert = "INSERT INTO boards (wo_num, name, phone, email, date, > board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\', > \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\', > \'$last_three\', \'$weight_in\', \'$weight_out\')"; > $result_insert = @mysql_query ($query_insert); > if ($result_insert == "") { > echo "<input type=\"hidden\" name=\"action\" value=\"0\"\n"; > echo "<INPUT type=\"submit\" value=\"Continue\">\n"; > } > else {echo "OOPS! Your programmer is an idiot!\n";} > }} > mysql_close(); > ?> > </body> > </html> > > > > > > The database looks like this, in case you're curious: > CREATE TABLE boards ( > name varchar(40) default NULL, > phone varchar(12) default NULL, > email varchar(40) default NULL, > purveyor varchar(40) default NULL, > job_no int(5) unsigned NOT NULL default '0', > date varchar(10) NOT NULL default '', > board_type varchar(100) NOT NULL default '', > weight_in decimal(4,2) default NULL, > weight_out decimal(4,2) default NULL, > last_three int(3) unsigned default NULL, > PRIMARY KEY (job_no), > KEY last-three (last_three) > ) TYPE=MyISAM; > > > Can anyone help me to get this thing working? > > TIA > Dan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
