DB access error

Question

boet 0 Newbie Poster

13 Years Ago

Hi everyone,

This is the error I get for this project. Been through the code all day and no problems found, still I get this error:

DB access error(You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near '21.2',qty='2',other=",total='594.2',courier='175',date='2010-05-04"at line one)

orders.php page:

function page_config ()
	{
		return NULL;
	}
	
	function page_post ()
	{
		if ( !is_admin () ) return "index.php?page=admin/login";
		
		return NULL;
	}
	
	function side_main ()
	{
		echo "<font class=\"pagetitle\">Options</font>";
		echo "<UL>";
			echo "<LI><A href=\"index.php?page=admin/categories&func=add\">Add New Category</A></LI>";
			echo "<LI><A href=\"index.php?page=admin/main\">Return to Administration</A></LI>";
		echo "</UL>";
	}
	
	function page_sidebar ()
	{
		return NULL;
	}
	
	function sub_main ()
	{
		include "panel.php";
		echo "<FONT class=\"pagetitle\">Orders Placed</FONT>";
		
		$order = @mysql_query ( "SELECT * FROM users ORDER BY firstname ASC" );
		if ( $order === false )
		{
			errormsg ();
			return;
		}
		
		if ( mysql_num_rows ( $order ) == 0 )
		{
			echo "<P>Order list is empty.</P>";
			return;
		}
		
		echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">";
			echo "<TR><TD colspan=\"3\">&nbsp;</td></tr>";
			echo "<TR>";
				echo "<TH>Client</TH>";
				echo "<TH>Email</TH>";
				echo "<TH></TH>";
			echo "</TR>";
			
			while ( $orderrow = mysql_fetch_assoc ( $order ) )
			{
					echo "<TR>";
					echo "<TD height=\"25\"><A href=\"index.php?page=admin/orders&func=user&id=" . $orderrow ['id'] . "\">" . $orderrow ['firstname'] . " " . $orderrow ['lastname'] . "</a></TD>";
					echo "<TD><a href=\"mailto:".$orderrow ['email']."\">" . $orderrow ['email'] . "</TD>";
					echo "<TD><A href=\"index.php?page=admin/orders&func=user&id=" . $orderrow ['id'] . "\">Details</a></TD>";
					echo "</TR>";
				
			}
			
			echo "<tr>";
				echo "<td colspan=\"2\">";
				echo "</td>";
				echo "<td>";
				echo "</td>";
			echo "</tr>";
			
		echo "</table>";
	}
	
	function sub_order ()
	{
		include "panel.php";
		$order = @mysql_query ( "SELECT * FROM orders WHERE orderid='".$_GET ['id']."' " );
		$order_other = @mysql_query ( "SELECT * FROM orders WHERE orderid='".$_GET ['id']."' " );
		$orderrow_other = mysql_fetch_assoc ( $order_other );

		echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"3\">";
		
		echo "<TR>";
			echo "<td colspan=\"4\"><strong>Description</strong></td>";
		echo "</TR>";
		echo "<TR>";
			echo "<td colspan=\"4\">".$orderrow_other['other']."</td>";
		echo "</TR>";
		
		echo "<TR>";
			echo "<td width=\"25%\"><strong>Product Number</strong></td>";
			echo "<td><strong>Qty.</strong></td>";
			echo "<td><strong>Name</strong></td>";
			//echo "<td align=\"right\"><strong>Amount</strong></td>";
		echo "</TR>";
		echo "<TR>";
			echo "<td colspan=\"4\"><hr></td>";
		echo "</TR>";
		
		
		while ( $orderrow = mysql_fetch_assoc ( $order ) )
		{
					echo "<tr>";
					echo "<td>".$orderrow['code']."</td>";
					echo "<td>".$orderrow['qty']."</td>";
    				echo "<td>".$orderrow['name']."</td>";
					//echo "<td align=\"right\" width=\"15%\">". float_to_rand ( $orderrow['price'] ) ."</td>";
  					echo "</tr>";
								
					$total += $orderrow['price'] ;
		}		
		
		echo "<tr>";
				echo "<td>&nbsp;</td>";
   			 	echo "<td>&nbsp;</td>";
				echo "<td>&nbsp;</td>";
    			echo "<td></td>";
  		echo "</tr>";
		
		/*echo "<tr>";
   			 	echo "<td colspan=\"3\"><strong>Total</strong></td>";
    			echo "<td align=\"right\"><strong>".float_to_rand ( $total )."</strong></td>";
  		echo "</tr>";
				echo "<tr>";
   			 	echo "<td colspan=\"4\"><strong><hr></strong></td>";
  		echo "</tr>";

		echo "<tr>";
   			 	echo "<td colspan=\"3\"><strong>Total VAT incl. in total price</strong></td>";
				
				$vat = 14;
				$devide = 114;
				$vat_incl = $total;
				
				$tot_vat = $total * $vat;
				$total_cost = $tot_vat / $devide;
				
    			echo "<td align=\"right\"><strong>".float_to_rand ( $total_cost )."</strong></td>";
  		echo "</tr>";*/
				 echo "<tr>";
   			 	echo "<td colspan=\"3\">&nbsp;</td>";
    			echo "<td></td>";
  		echo "</tr>";
			
			echo "<tr>";
				echo "<td colspan=\"4\">";
				title ( "Options" );
				echo "<UL>";
					echo "<LI><A href=\"index.php?page=admin/orders&func=user&id=".$_GET['usid']."\">Return to Order List</A></LI>";
					echo "<LI><A href=\"index.php?page=admin/main\">Return to Administration</A></LI>";
				echo "</UL>";
				echo "</td>";
				
			echo "</tr>";
			
			echo "</table>";
			
	}
	
	function sub_user ()
	{
		include "panel.php";
		$orders = @mysql_query ( "SELECT * FROM number WHERE userid='".$_GET['id']."' ORDER BY orderid DESC" );
		if ( $orders === false )
		{
			errormsg ();
			return;
		}
		if ( mysql_num_rows($orders) == 0)
		{
				echo "<P>No orders have been placed</P>";
		}
		
		echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"3\">";
		
		echo "<TR>";
			echo "<td><strong>Order Number</strong></td>";
			echo "<td><strong>Date</strong></td>";
			echo "<td></td>";
		echo "</TR>";
		echo "<TR>";
			echo "<td colspan=\"4\"><hr></td>";
		echo "</TR>";
		
		while ( $orderrow = mysql_fetch_assoc ( $orders ) )
		{
			$items = @mysql_query ( "SELECT * FROM orders WHERE orderid='".$orderrow ['orderid']."' " );
			$itemsrow = mysql_fetch_assoc ( $items );
			
					echo "<tr>";
    			    echo "<td width=\"20%\"><strong>" . $orderrow ['orderid'] . "</strong></td>";
					echo "<td><a href=\"index.php?page=admin/orders&func=order&id=".$orderrow ['orderid']."&usid=".$_GET['id']."\">" . $itemsrow ['date'] . "</a></td>";
    				echo "<td align=\"right\" width=\"10%\"><a href=\"index.php?page=admin/orders&func=order&id=".$orderrow['orderid']."&usid=".$_GET['id']."\">Details</a></td>";
  					echo "</tr>";
		}		
			echo "<TR>";
				echo "<TD colspan=\"4\"><hr></td>";
			echo "</TR>";
			
			echo "<tr>";
				echo "<td colspan=\"2\">";
				title ( "Options" );
				echo "<UL>";
					echo "<LI><A href=\"index.php?page=admin/orders\">Return to Client List</A></LI>";
					echo "<LI><A href=\"index.php?page=admin/main\">Return to Administration</A></LI>";
				echo "</UL>";
				echo "</td>";
				echo "<td>";
				echo "</td>";
			echo "</tr>";
		
		echo "</table>";
	}
	
	function page_main ()
	{
		switch ( $_GET ['func'] )
		{
		case "order": sub_order ( $config ); break;
		case "user": sub_user ( $config ); break;
		default: sub_main ( $config ); break;
		}
	}

sql query for orders table:

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `itemid` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `orderid` int(11) NOT NULL default '0',
  `delivery_country` varchar(255) NOT NULL default '',
  `delivery_address1` varchar(250) NOT NULL default '',
  `delivery_address2` varchar(250) NOT NULL default '',
  `delivery_city` varchar(250) NOT NULL default '',
  `delivery_postalcode` varchar(250) NOT NULL default '',
  `delivery_province` varchar(250) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `price` float NOT NULL default '0',
  `total` float NOT NULL default '0',
  `qty` int(11) NOT NULL default '0',
  `courier` float NOT NULL default '0',
  `other` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=161 ;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `userid`, `itemid`, `date`, `orderid`, `delivery_country`, `delivery_address1`, `delivery_address2`, `delivery_city`, `delivery_postalcode`, `delivery_province`, `name`, `price`, `total`, `qty`, `courier`, `other`) VALUES
(3, 365, 448383, '2008-09-02', 2, 'South Africa, Rand', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Star Tree Chardonnay', 1, 7, 6, 1, 'Test Transaction - Web Studio'),
(18, 12, 448377, '2008-09-16', 3, 'BELGIUM', 'ddsf', 'fsdfdf', 'weerr', '88000', 'dsere', 'Full Cream Sherry', 29.64, 6029.52, 6, 5496, ''),
(19, 12, 448378, '2008-09-16', 3, 'BELGIUM', 'ddsf', 'fsdfdf', 'weerr', '88000', 'dsere', 'Old Brown Sherry', 29.64, 6029.52, 6, 5496, ''),
(17, 12, 448377, '2008-09-16', 3, 'BELGIUM', 'ddsf', 'fsdfdf', 'weerr', '88000', 'dsere', 'Full Cream Sherry', 29.64, 6029.52, 6, 5496, ''),
(28, 405, 448361, '2008-10-24', 4, 'SOUTH AFRICA', '36 Petunia Crescent', '36 Petunia Crescent', 'Upington', '8801', 'Northern Cape', 'Rosé', 18.92, 1715.22, 18, 0, 'Goeie Dag,\r\nMy naam is Tanya en Bly in California.So kan nie wyn optel nie.Kan u asb. met my sister in kontak tree en dan kan sy die wyn by U optel.Sy woon in Upington. Haar naam is Lindi Nel cell.0835214076, huisnr. 054-3390008.Ek koop wyn vir my ma se v'),
(27, 405, 448358, '2008-10-24', 4, 'SOUTH AFRICA', '36 Petunia Crescent', '36 Petunia Crescent', 'Upington', '8801', 'Northern Cape', 'Nouveau Blanc', 18.92, 1715.22, 18, 0, 'Goeie Dag,\r\nMy naam is Tanya en Bly in California.So kan nie wyn optel nie.Kan u asb. met my sister in kontak tree en dan kan sy die wyn by U optel.Sy woon in Upington. Haar naam is Lindi Nel cell.0835214076, huisnr. 054-3390008.Ek koop wyn vir my ma se v'),
(29, 405, 448363, '2008-10-24', 4, 'SOUTH AFRICA', '36 Petunia Crescent', '36 Petunia Crescent', 'Upington', '8801', 'Northern Cape', 'Brut Sparkling Wine', 29.75, 1715.22, 18, 0, 'Goeie Dag,\r\nMy naam is Tanya en Bly in California.So kan nie wyn optel nie.Kan u asb. met my sister in kontak tree en dan kan sy die wyn by U optel.Sy woon in Upington. Haar naam is Lindi Nel cell.0835214076, huisnr. 054-3390008.Ek koop wyn vir my ma se v'),
(30, 405, 448379, '2008-10-24', 4, 'SOUTH AFRICA', '36 Petunia Crescent', '36 Petunia Crescent', 'Upington', '8801', 'Northern Cape', 'Grape Juice Sparkling Red', 13.85, 1715.22, 18, 0, 'Goeie Dag,\r\nMy naam is Tanya en Bly in California.So kan nie wyn optel nie.Kan u asb. met my sister in kontak tree en dan kan sy die wyn by U optel.Sy woon in Upington. Haar naam is Lindi Nel cell.0835214076, huisnr. 054-3390008.Ek koop wyn vir my ma se v'),
(31, 405, 448381, '2008-10-24', 4, 'SOUTH AFRICA', '36 Petunia Crescent', '36 Petunia Crescent', 'Upington', '8801', 'Northern Cape', 'Grape Juice Sparkling White', 13.85, 1715.22, 18, 0, 'Goeie Dag,\r\nMy naam is Tanya en Bly in California.So kan nie wyn optel nie.Kan u asb. met my sister in kontak tree en dan kan sy die wyn by U optel.Sy woon in Upington. Haar naam is Lindi Nel cell.0835214076, huisnr. 054-3390008.Ek koop wyn vir my ma se v'),
(33, 365, 448373, '2008-10-31', 5, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Red Muscadel', 29.64, 2383.38, 18, 0, ''),
(34, 365, 448376, '2008-10-31', 5, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Medium Cream Sherry', 29.64, 2383.38, 18, 0, ''),
(35, 365, 448377, '2008-10-31', 5, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Full Cream Sherry', 29.64, 2383.38, 18, 0, ''),
(36, 365, 448377, '2008-10-31', 5, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Full Cream Sherry', 29.64, 2383.38, 18, 0, ''),
(37, 365, 448379, '2008-10-31', 5, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Grape Juice Sparkling Red', 13.85, 2383.38, 18, 0, ''),
(38, 365, 448375, '2008-11-03', 6, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Red Port', 29.64, 1778.4, 30, 0, ''),
(39, 365, 448378, '2008-11-03', 6, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Old Brown Sherry', 29.64, 1778.4, 30, 0, ''),
(40, 365, 448375, '2008-11-03', 7, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Red Port', 29.64, 1778.4, 30, 0, ''),
(41, 365, 448378, '2008-11-03', 7, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'Old Brown Sherry', 29.64, 1778.4, 30, 0, ''),
(49, 365, 448373, '2008-11-04', 8, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Red Muscadel', 29.64, 889.2, 30, 0, ''),
(50, 365, 448373, '2008-11-04', 9, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Red Muscadel', 29.64, 889.2, 30, 0, 'Test'),
(51, 365, 448370, '2008-11-04', 10, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'White Jerepigo', 29.64, 1956.24, 66, 0, ''),
(52, 365, 448372, '2008-11-04', 11, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Soet Hanepoot', 28.15, 1857.9, 66, 0, ''),
(53, 365, 448367, '2008-11-04', 12, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Ruby Cabernet', 24.28, 1748.16, 72, 0, ''),
(54, 365, 448370, '2008-11-04', 13, 'SOUTH AFRICA', 'Swartmodderweg 28', '', 'Upington', '8800', 'Northern Cape', 'White Jerepigo', 29.64, 1119.2, 30, 230, ''),
(56, 405, 448358, '2008-11-04', 14, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Nouveau', 18.92, 1715.22, 18, 0, ''),
(57, 405, 448361, '2008-11-04', 14, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Rosé', 18.92, 1715.22, 18, 0, ''),
(58, 405, 448364, '2008-11-04', 14, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Doux Sparkling Wine', 29.75, 1715.22, 18, 0, ''),
(59, 405, 448379, '2008-11-04', 14, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Grape Juice Sparkling Red', 13.85, 1715.22, 18, 0, ''),
(60, 405, 448381, '2008-11-04', 14, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Grape Juice Sparkling White', 13.85, 1715.22, 18, 0, ''),
(63, 12, 448354, '2008-11-14', 15, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '', 'Gauteng', 'Chardonnay', 21.43, 1142.04, 12, 270, ''),
(64, 12, 448361, '2008-11-14', 15, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '', 'Gauteng', 'Rosé', 18.92, 1142.04, 6, 270, ''),
(65, 12, 448365, '2008-11-14', 15, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '', 'Gauteng', 'Pinotage', 24.28, 1142.04, 6, 270, ''),
(66, 12, 448368, '2008-11-14', 15, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '', 'Gauteng', 'Shiraz', 29.64, 1142.04, 6, 270, ''),
(67, 12, 448376, '2008-11-14', 15, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '', 'Gauteng', 'Medium Cream Sherry', 29.64, 1142.04, 6, 270, ''),
(107, 411, 448381, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Grape Juice Sparkling White', 13.85, 2710.5, 24, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(106, 411, 448377, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Full Cream Sherry', 29.64, 2710.5, 12, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(104, 411, 448374, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'White Muscadel', 29.64, 2710.5, 6, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(105, 411, 448375, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Red Port', 29.64, 2710.5, 6, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(103, 411, 448369, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Cabernet Sauvignon', 24.28, 2710.5, 12, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(102, 411, 448368, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Shiraz', 29.64, 2710.5, 12, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(101, 411, 448364, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Doux Sparkling Wine', 29.75, 2710.5, 18, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(100, 411, 448359, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Late Harvest', 18.92, 2710.5, 6, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(99, 411, 448354, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Chardonnay', 21.43, 2710.5, 12, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(98, 411, 448351, '2008-11-17', 16, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Blanc de Blanc', 18.92, 2710.5, 6, 0, 'Karlien,\r\n\r\nAfhaal by Bloemfontein depot teen 28 November asb.'),
(117, 12, 448376, '2008-11-17', 17, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '2021', 'Gauteng', 'Medium Cream Sherry', 29.64, 1142.04, 6, 270, ''),
(116, 12, 448368, '2008-11-17', 17, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '2021', 'Gauteng', 'Shiraz', 29.64, 1142.04, 6, 270, ''),
(115, 12, 448365, '2008-11-17', 17, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '2021', 'Gauteng', 'Pinotage', 24.28, 1142.04, 6, 270, ''),
(114, 12, 448361, '2008-11-17', 17, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '2021', 'Gauteng', 'Rosé', 18.92, 1142.04, 6, 270, ''),
(113, 12, 448354, '2008-11-17', 17, 'SOUTH AFRICA', '87A Culross Road', '', 'Brayanston, Sandton', '2021', 'Gauteng', 'Chardonnay', 21.43, 1142.04, 12, 270, ''),
(126, 416, 448358, '2008-12-01', 21, 'SOUTH AFRICA', 'c/o Virginia Flight School Virginia Airport', '220 fairway drive', 'durban', '4600', 'natal', 'Nouveau', 18.92, 332.04, 12, 105, ''),
(125, 413, 448368, '2008-11-20', 20, 'SOUTH AFRICA', 'PO Box 52000', '', 'Wierdapark', '0149', 'Gauteng', 'Shiraz', 24.28, 396.36, 12, 105, ''),
(124, 413, 448368, '2008-11-19', 19, 'SOUTH AFRICA', 'PO Box 52000', '', 'Wierdapark', '0149', 'Gauteng', 'Shiraz', 24.28, 396.36, 12, 105, ''),
(123, 413, 448368, '2008-11-19', 18, 'SOUTH AFRICA', 'PO Box 52000', '', 'Wierdapark', '0149', 'Gauteng', 'Shiraz', 24.28, 396.36, 12, 105, ''),
(127, 418, 448361, '2009-02-09', 22, 'SOUTH AFRICA', '57 eva st', 'Fairleads', 'benoni', '1501', 'Gauteng', 'Rosé', 18.92, 332.04, 12, 105, ''),
(128, 416, 448358, '2009-05-19', 23, 'SOUTH AFRICA', 'c/o Virginia Flight School Virginia Airport', '220 fairway drive', 'durban', '4600', 'natal', 'Nouveau', 20.2, 347.4, 12, 105, ''),
(132, 462, 448365, '2009-07-17', 24, 'SOUTH AFRICA', 'Jan van Riebeeck Drive', 'Dal Josafat', 'Paarl', '7646', 'Western Cape', 'Pinotage', 25.1, 267, 3, 110, ''),
(131, 462, 448356, '2009-07-17', 24, 'SOUTH AFRICA', 'Jan van Riebeeck Drive', 'Dal Josafat', 'Paarl', '7646', 'Western Cape', 'Chenin Blanc', 20.2, 267, 1, 110, ''),
(133, 462, 448373, '2009-07-17', 24, 'SOUTH AFRICA', 'Jan van Riebeeck Drive', 'Dal Josafat', 'Paarl', '7646', 'Western Cape', 'Red Muscadel', 30.75, 267, 2, 110, ''),
(134, 12, 448354, '2009-08-20', 25, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Chardonnay', 22.3, 2496.6, 24, 0, '20% afskag, goedgekeur deur Koos Visser.'),
(135, 12, 448355, '2009-08-20', 25, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Colombard', 20.2, 2496.6, 24, 0, '20% afskag, goedgekeur deur Koos Visser.'),
(136, 12, 448361, '2009-08-20', 25, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Rosé', 20.2, 2496.6, 6, 0, '20% afskag, goedgekeur deur Koos Visser.'),
(137, 12, 448365, '2009-08-20', 25, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Pinotage', 25.1, 2496.6, 24, 0, '20% afskag, goedgekeur deur Koos Visser.'),
(138, 12, 448368, '2009-08-20', 25, 'South Africa', 'Industria Road 32', '-', 'Upington', '8800', 'Northern Cape', 'Shiraz', 25.1, 2496.6, 30, 0, '20% afskag, goedgekeur deur Koos Visser.'),
(139, 418, 448361, '2009-08-24', 26, 'SOUTH AFRICA', '36 Ednam Rd', 'Newlands', 'Cape Town', '7700', 'Western Cape', 'Rosé', 20.2, 231.2, 6, 110, ''),
(140, 418, 448361, '2009-08-24', 27, 'SOUTH AFRICA', '36 Ednam Rd', 'Newlands', 'Cape Town', '7700', 'Western Cape', 'Rosé', 20.2, 231.2, 6, 110, ''),
(152, 479, 448373, '2009-09-10', 29, 'SOUTH AFRICA', 'Border Country Inn', '', 'Komatipoort', '1340', 'Mpumalanga', 'Red Muscadel', 30.75, 1881, 12, 405, ''),
(150, 479, 448370, '2009-09-10', 29, 'SOUTH AFRICA', 'Border Country Inn', '', 'Komatipoort', '1340', 'Mpumalanga', 'White Jerepigo', 30.75, 1881, 12, 405, ''),
(151, 479, 448371, '2009-09-10', 29, 'SOUTH AFRICA', 'Border Country Inn', '', 'Komatipoort', '1340', 'Mpumalanga', 'Red Jerepigo', 30.75, 1881, 12, 405, ''),
(148, 476, 448386, '2009-09-05', 28, 'SOUTH AFRICA', '6 Herons Walk. 11 Plane Crescent', '', 'Howick', '3290', 'KZN', 'Blanc de Noir', 20.2, 1717, 60, 505, ''),
(153, 479, 448374, '2009-09-10', 29, 'SOUTH AFRICA', 'Border Country Inn', '', 'Komatipoort', '1340', 'Mpumalanga', 'White Muscadel', 30.75, 1881, 12, 405, ''),
(154, 489, 448355, '2009-09-28', 30, 'SOUTH AFRICA', '6  May Crescent, Duynefontein', 'Melkbosstrand', 'Cape Town', '7441', 'Western Cape', 'Colombard', 20.2, 1101, 12, 315, ''),
(155, 489, 448356, '2009-09-28', 30, 'SOUTH AFRICA', '6  May Crescent, Duynefontein', 'Melkbosstrand', 'Cape Town', '7441', 'Western Cape', 'Chenin Blanc', 20.2, 1101, 12, 315, ''),
(156, 489, 448365, '2009-09-28', 30, 'SOUTH AFRICA', '6  May Crescent, Duynefontein', 'Melkbosstrand', 'Cape Town', '7441', 'Western Cape', 'Pinotage', 25.1, 1101, 6, 315, ''),
(157, 489, 448368, '2009-09-28', 30, 'SOUTH AFRICA', '6  May Crescent, Duynefontein', 'Melkbosstrand', 'Cape Town', '7441', 'Western Cape', 'Shiraz', 25.1, 1101, 6, 315, ''),
(158, 493, 448354, '2009-10-02', 31, 'SOUTH AFRICA', '54 Nottingham Rd', 'Kensington', 'Johannesburg', '2094', 'Gauteng', 'Chardonnay', 22.3, 580.6, 6, 175, ''),
(159, 493, 448356, '2009-10-02', 31, 'SOUTH AFRICA', '54 Nottingham Rd', 'Kensington', 'Johannesburg', '2094', 'Gauteng', 'Chenin Blanc', 20.2, 580.6, 6, 175, ''),
(160, 493, 448365, '2009-10-02', 31, 'SOUTH AFRICA', '54 Nottingham Rd', 'Kensington', 'Johannesburg', '2094', 'Gauteng', 'Pinotage', 25.1, 580.6, 6, 175, '');

Please help!!!

Thanks in advance

php

Edited 13 Years Ago by nav33n because: Use the snippet textbox to post your working and fully tested code snippet.

3 Contributors
10 Replies
103 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by JRM

All 10 Replies

nonshatter 26 Posting Whiz

13 Years Ago

`courier` float NOT NULL default '0',

Needs to be:

`courier` float(4,2) NOT NULL default '0',

Or however many digits you want each side of the decimal point. E.g. Float (2,2) is a number like 23.96 or Float(4,7) gives a number like 1234.1234567

Or it could be that you don't need to have a Float data type at all. It depends what data needs to go in that field!

Edited 13 Years Ago by nonshatter because: n/a

nonshatter 26 Posting Whiz

13 Years Ago

Yes, you will need to do the same for all fields that are of FLOAT type. Make sure you compare the field with the data that's being inserted into the table.
From what I can see, all the data being entered into the courier field is of integer type. Whereas the price and total fields are float.

JRM 107 Practically a Master Poster

13 Years Ago

Generally speaking, if you are getting a blank page after submitting to a PHP file, it means that you have a syntax error or some other fatal error in the file .
If you are testing this on a localhost machine, then set PHP errors_all to on and display errors to on. so that the errors will show rather than a blank page.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

boet 0 Newbie Poster · Answer 1 · 2010-05-05T19:31:07+00:00

Thanks for the reply.

Do I only do that for the 'courier' field, or do I do the same for the rest of the float fields?
I really don't know who created this project, but I'm supposed to fix it.

boet 0 Newbie Poster · Answer 2 · 2010-05-05T20:26:12+00:00

Thanks, I hope it works. I'm actually new to the programming world, and my job is to fix websites not working properly. I got another piece of code from another website project, but this one doesn't throw an error, it only returns a blank page. Think you can help me with that please? Because I'm at super beginner mode for this programming, although I know my basics very well.

The database coding:

CREATE TABLE IF NOT EXISTS `preke` (
`id` int(11) NOT NULL auto_increment,
`naam` varchar(100) NOT NULL,
`datum` date NOT NULL,
`preek` longtext NOT NULL,
`title` varchar(100) default NULL,
`vers` varchar(200) NOT NULL,
`tema` varchar(170) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;

--
-- Dumping data for table `preke`
--

INSERT INTO `preke` (`id`, `naam`, `datum`, `preek`, `title`, `vers`, `tema`) VALUES
(6, 'Dr. Jan Ras', '2009-02-01', 'Luk 13 v 9', 'preek.mp3', 'Luk 13:9', ''),
(7, 'Matt 2', '2009-01-11', '', '11 Jan 2009 Matt2 mp3.mp3', '', ''),
(9, 'Dr Jan Ras', '2009-01-11', '', '11 Jan 2009 Matt2 mp3.mp3', 'Matt 2', ''),
(10, 'Dr Jan Ras', '2009-03-01', '', '1 Maart 2009 1 Petrus 2.mp3', '2 Petus 2', ''),
(12, 'Feesrede Dr Dick Steyn', '2009-03-06', '', 'Ds Dick.mp3', 'Ps 1', ''),
(13, 'Kerkgeskiedenis Dr JL Ras', '2009-03-06', '', 'Kerkgeskiedenis.mp3', '', ''),
(14, 'Groeteboodskap Upt Oos', '2009-03-06', '', 'Groeteboodskap Upt Oos.aup .mp3', '', ''),
(15, 'Groeteboodskap Klasis Griekwaland wes', '2009-03-07', '', 'Groete Ds Steve vd Walt.mp3', '', ''),
(16, 'Groeteboodskap Karasburg', '2009-03-06', '', 'Groeteboodskap Karasburg.mp3', '', ''),
(17, 'Orrelspel by fees', '2009-03-06', '', 'Orreluitvoerings.mp3', '', ''),
(24, 'Voorbereiding', '2009-03-07', '', 'Voorbereiding Dr Frans vd Walt.mp3', 'Ps 95', '');
INSERT INTO `preke` (`id`, `naam`, `datum`, `preek`, `title`, `vers`, `tema`) VALUES
(19, 'Nagmaal Ds Koos Saayman', '2009-03-08', 'Tema: Jesus roep jou om te volhard!\r\nDit word vertel dat tydens ‘n Olimpiese spele in die stad Olimpia in Griekeland ter ere van die god Jupiter, dat ’n atleet wat in die marathon, die langafstand wedloop, laaste gekom het, dat hy meer toegejuig is, as die een wat eerste gekom het.\r\n \r\n70,000 mense het hom glo van die pawiljoene af toegejuig –  want hy het die wedloop voltooi.\r\n \r\nSo het die leuse ontstaan naamlik dat dit nie in die eerste plek daaroor gaan dat jy moet \r\nwen nie – maar dat jy aan die wedloop deelneem – en die marathon voltooi.\r\n \r\nDie Bybel leer ons vanoggend opnuut– jou en my lewe is ’n wedloop wat ons elkeen met volharding moet hardloop en voltooi.\r\n \r\nEn nie elkeen wat die wedloop begin kry die prys nie – alleen hulle wat die wedloop voltooi.\r\nEn baie belangrik, soos wat daar by die OS duisende mense is wat van die pawiljoene af die \r\natlete toejuig en aanmoedig – so het ons as gelowiges in ons elkeen se eie wedloop ook mense - mense wat vir ons bywyse van spreke uit die hemel uit aanmoedig om aan te hou en uit te hou en te volhard en nie in ons eie wedloop uit te \r\nsak nie.\r\n \r\nWie is die geloofskare waarvan Hebreër -skrywer praat?\r\nU weet mos - Dis almal mense wat toe hulle op aarde geleef het self volhard het en elkeen sy eie geloofswedloop voltooi het.\r\n \r\nHoe moedig hulle ons aan?\r\nDeur die voorbeeld wat hulle op aarde gestel het.\r\nDeur hulle eie manier van lewe – maw dit waarvan hulle leefwyse getuig het in beproewings; in vervolging; versoekings.\r\n \r\nHulle verhouding met God –\r\nDat hulle op die ou end gelowig aan God vasgehou het,  in lief en leed,  en dus end uit volgehou het in hulle lewenswedloop.\r\n \r\nDaar is baie voorbeelde wat vir ons gegee word in \r\nHebrs.11: \r\nNoag; Abraham; Isak; Jakob; Josef; Moses; \r\nRagab; Dawid en die profete.\r\n \r\nDie Griekse woord vir wedloop – “agon” – daarvan \r\nis die Engelse woord “agony” afgelei.\r\nDit sê dat hierdie wedloop nie ’n grap is nie.\r\nDit vra baie van jou. \r\nDis ’n pad wat God vir elkeen van ons uitgelê het wat net met stamina van Bo voltooi kan word.\r\nMaw God weet hoeveel genade elkeen van ons nodig het.\r\n \r\nJa, elkeen se wedloop-roete is deur God vir hom uitgewerk.\r\n \r\n= Noag – kry die byna belaglike opdrag van God \r\nom die ark te bou.\r\nMaar hy het God geglo en vertrou en gehoorsaam.\r\nHy het alles gedoen presies soos God hom beveel het.\r\nOns weet waarop sy volharding uitgeloop het.\r\nHy het ’n erfgenaam geword van die vryspraak wat deur die geloof kom.\r\n \r\n= Abraham was bereid om toe God hom roep te trek sonder om te weet waar hy sou uitkom. \r\nOok om sy enigste seun te slag en te offer as God dit van hom vra.\r\n \r\n= Ragab ’n prostituut in Jerigo het ogv wat sy van die God van die Israeliete gehoor het geglo en die verspieders vriendelik ontvang en weggsteek. \r\nMet die verowering van die stad is sy en haar familie gered. \r\nHaar naam is later in die geslagsregister van Jesus opgeneem. \r\n \r\n=Dawid. Wat sal ons van Hom sê? \r\nHy wat met voorbedagte rade owerspel en moord pleeg?\r\nWas hy so ’n voorbeeld van ’n atleet wat volhard op sy geloofswedloop?\r\nNee – maar sy berou en bekering, sy verhouding met God verder in sy veelbewoë lewe \r\nwas ’n bewys dat hy kon opstaan en sy wedloop voltooi.\r\n \r\nHy en die ander geloofgetuies wat hul wedloop voltooi het praat met ons.\r\nHulle motiveer ons en moedig ons aan: “Dit kan gedoen word!\r\nJy kan dit ook doen”.\r\n \r\nIn die fliek – “Dead poets society” – wys ’n onderwyser geraamde fotos van oudskoliere in die \r\nskoolportaal aan ’n groep seuns.\r\nBaie van die oudskoliere is baie oud of reeds oorlede en hy vra dan vir hulle – wat sê die gesigte op die vergeelde fotos vir julle? \r\nWat is hulle boodskap vandag aan julle?  \r\nEn die boodskap is: “Carpe diem!”\r\nHou aan! Koop die tyd uit! Maak die beste gebruik van elke geleentheid!\r\nVolhard! \r\n \r\nJa, hulle en al die mense wie se geskiedenis opgeskryf is in die Bybel – al die gelowiges deur\r\ndie eeue - hulle wag op ons elkeen, tot op die laaste een van ons om ons wedloop te voltooi.\r\nDan sal die skare geloofsgetuienis voltallig wees.\r\nEn sal hulle en ons almal saam die kroon van die ewige lewe ontvang.\r\n \r\nDaarom moet ons volhard.\r\n \r\nBy bykans elkeen sê die Hebreër-skrywer...omdat \r\nhy/sy geglo het...het hulle in hul wedloop kon volhard.\r\n \r\nLuister wat sê Jakobus oor die profete:\r\n“Neem die profete wat in die Naam van die Here gepraat het as voorbeeld van lyding en geduld. \r\nOns noem hulle geseënd omdat hulle volhard het”. \r\nEn dan hy verwys ook spesifiek na Job se volharding:\r\n \r\nJob 2:3: “Die Here het vir die satan gevra: Het jy ag gegee op my kneg Job?.\r\n Hy volhard in sy vroomheid, alhoewel jy My teen hom opgehits het om hom te vernietig sonder oorsaak”.\r\n \r\nJob se volharding kry dan ook ’n ander dimensie.\r\nWant luister hoe hy sy vrou antwoord as sy hom vra in al sy elende:\r\n” Volhard jy nog in jou vroomheid? \r\nVervloek God en sterf!”\r\nMaar hy weier.\r\nHy antwoord eerder: “As ons die goeie van God wil ontvang – waarom nie ook die slegte\r\nnie?”\r\n \r\nJakobus sê dan ook van Job: “Julle het gehoor van die volharding van Job en julle het gesien waarop die Here dit laat uitloop het”. 5:10,11 \r\n \r\nWaarop het dit uitgeloop?\r\n \r\nLees gerus weer die aangrypende deel in die einde van die boek Job 42:12 - 17: \r\n“Die Here het die laaste deel van Job se lewe voorspoediger gemaak as die eerste”.\r\n \r\nSo wat beteken die begrip “volharding” volgens die \r\nBybel en hoe kom dit te pas in jou lewe?\r\n \r\nDis om aan te hou om die regte ding te doen.\r\nOm uithouvermoë te toon onder alle omstandighede, ook omstandighede wat die lewe vir jou bitter moeilik en ondraaglik maak, maar dat jy steeds blymoedig bly.         \r\n \r\ns dit nie ’n mondvol nie?\r\n \r\nOm aan te hou glo in die goedheid van God en om Hom te vertrou.\r\n \r\nOm gedetermineerd en vasberade te wees in die praktiese uitlewing van jou godsdiens. \r\n \r\nIs u so ’n mens?\r\n \r\nKen u sulke mense, al het hulle te oud en afgeleef geraak, om vandag geloofsgesprekke met jou te hê, maar wie se leefwyse van vroeër, 20 ,30, 50  jaar gelede vandag steeds vir jou tot aansporing dien om te volhard?\r\nOnthou u sulke mense wat al heengegaan het wie se nagedagtenis vir jou ‘n getuienis is van hul volharding?\r\n \r\nAlmal mense wat jou ook bywyse van spreke vanuit die hemel aanmoedig.\r\n \r\nAlmal mense wat toe hulle geleef het enduit uitgehou het en met deursettingsvermoe en \r\ntoewyding aangehou het om te doen wat reg is?\r\nMense wat geduldig volhard en steeds bly glo in die goedheid van die Here?\r\n \r\nGod het deur my kontak met ons swart lidmate by die Diepsloot plakkerskamp ’n verdiepende perspektief in my geloofslewe ingebring.\r\n \r\n- Hulle spontane blymoedigheid en vriendelikheid.\r\n \r\n- Hulle vergenoegdheid al het hulle nie werk nie en min lewensmiddele.\r\n \r\n- Hulle vrygewigheid en mededeelsaamheid.\r\n \r\n- Hulle tevredenheid om in bouvallige een vertrek- geboutjies te bly dikwels sonder lopende water of elektrisiteit.\r\n- Hulle aanpasbaarheid, opofferings en bereidheid om somer en winter ver te loop om by die kerk uit te kom.\r\n \r\nDis kinders van die Here met uithouvermoë tmv dinge wat die lewe vir hulle baie moeilik maak.\r\nMense wat steeds onwrikbaar glo in die liefde van die Here vir hulle.\r\nDis volharding geinspireer deur hoop en vertroue in God.\r\nSoos iemand sê:  Hebrs. 12:1 is ‘n trompetgeskal of geweerskoot om ons te waarsku dat die laaste rondtes begin het om ons lewens te sien as ‘n wedloop wat met passie, ywer, toewyding, energie en dissipline gehardloop moet word.\r\nEn as die Hebreërsskrywer sê: “Gooi elke las af.\r\nOok  die sonde wat jou so maklik verstrik” – dan bedoel hy: “Neem die wedloop ernstig op!”\r\n \r\nIn ons wedloop....sê die Hebr. skrywer...moet ons:\r\nElke las oftewel gewig van ons afgooi. \r\nDie Griekse woord hier impliseer menslike oorgewig.\r\n \r\nVan hierdie oor-gewig, die las, die hindernis moet jy ontslae raak deur die regte geloofsoefening. \r\n \r\nSoos ’n swaar kleed wat om jou skouers hang, wat jou belemmer in jou wedloop, moet dit weggewerp word.\r\n \r\nMaw alles wat jou geestelike groei en vordering belemmer.\r\n \r\nEn as die skrywer praat van sondes wat ons so maklik verstrik – verwys hy na dit wat die satan deur sy versoekings aan jou wil doen.\r\n \r\nSoos seekatarms moet hierdie versoekings ’n al hoe groter houvas op jou leefwyse kry en jou moed en wil breek om te volhard in jou wedloop.\r\nSatan wil jou verstrik en pooitjie sodat jy val en bly lê. \r\nJou oog op Christus moet vervaag sodat jy nie jou einddoel bereik nie.\r\n \r\nHierdie versoekings moet jy ontvlug en agterlaat en na Jesus toe hardloop.\r\n \r\nDws – \r\nOm jou gebedslewe lewendig en aktief te hou.\r\nOm jou gees voortdurend te voed met die waarhede uit God se Woord.\r\nOm bywyse van spreke die oog wat verleiding soek uit te pluk.\r\nOm die hand wat uitreik na verkeerde begeertes af te kap.\r\nOm so die satan te weerstaan.\r\nOm elke gedagte wat in jou kop opkom gevange te neem en aan Jesus gehoorsaam te maak.\r\n \r\nSo – wat behels my wedloop?\r\nWat is die laste wat ek  moet afgooi?\r\nWat is die sondes wat die satan voor my voete gooi?\r\n \r\nWaarin moet ek volhard? \r\n \r\nEk vra dit terwyl ons weet:\r\n \r\n‘n Christen is nie iemand wie se lewe van A-Z in watte toegedraai is wat hom teen die satan en die sondegebrokenheid van die lewe beskerm nie.\r\n \r\nHy kan ook steeds verlei word en sonde doen.\r\nHy kan ook aan drank of dwelms of watookal verslaaf raak.\r\nHy kan Hy ook troosteloos ineen stort as gevolg van aanhoudende beproewings.\r\nHy kan ook dikwels totaal moedeloos en kragteloos voel.\r\nHy kan ook depressief raak en moeg word vir die lewe.\r\nHy kan ook eensaamheid ervaar.\r\nHy kan ook ook soms verstote voel.\r\nHy kan ook onder die die tonge van onsimpatieke  en onvergewingsgesinde mense deurloop.\r\nHy kan ook deur ander verontreg word.\r\nSy geloofslewe kan ook slordig word en sy gebedslewe taan.\r\nSy verhouding en omgang met God kan ook oppervlakkig word.\r\n \r\n’n Christen se lewe – U en my lewe vra volharding.\r\nGod vra volharding.\r\nGod skenk ook volharding!\r\n \r\nVolharding om al die dinge wat op jou pad kom in jou wedloop te kan hanteer – met Goddelike hulp en bystand.\r\n \r\nJa, ons moet in hierdie land as Christene volhard om elke dag tmv allerlei gevare voort te gaan met ons lewens – om jou beroep te getrou te beoefen; om jou gesin te versorg.\r\nOm te volhard om daarin om die Goue reël van Jesus toe te pas, naamlik – om die goeie en mooi dinge wat jy wil hê dat ander aan jou moet doen, om \r\ndit eerste aan hulle te gaan doen.\r\nVolharding in die dra van die vrugte van die Gees.\r\nOm te volhard in jou geloof in en jou vertroue op God – dat Hy jou sal beskerm en lei. \r\nOm te volhard in jou geloof dat Hy jou liefhet en dat Hy oorvloedige genade vir jou het deur Jesus Christus.\r\nOm te volhard in jou soeke na God se wil.\r\nOm te volhard in jou stryd teen satan, en voortdurend jou sondes te bely en daaruit op te \r\nstaan....\r\n \r\nGod het die prostituut Ragab gered.\r\nHy het Dawid sy ontrou vergewe en gedra in sy geloofsworsteling.\r\nGod het hulle ondersteun in hul en geloofswedloop.\r\nHoekom nie ook vir jou en my nie?\r\n \r\nKyk na Paulus se lewe:\r\n \r\nSy lewe was een lang tydperk van ontberings.\r\nOp sy lewenswedloop het hy met baie teestand en vyandigheid te doen gekry.\r\nHy het dit fisies aan sy lyf gevoel.\r\nTog volgehou en volhard om sy goddelike roeping uit te voer....\r\nIn Filip. 4: 13: skryf hy: “Ek is tot alles in staat deur Hom wat my krag gee”. \r\n \r\nEn in Filip. 3: 12-15 (14,15) skryf hy:  “Ek span my in om by die wenstreep te kom...sodat ek die hemelse prys kan behaal”.\r\n \r\nJa, VOLHARDING tsv doring in sy vlees.\r\n \r\nLuister na sy raad aan Timotheus: \r\n“In die goeie wedloop van die geloof moet jy al jou kragte inspan en die ewige lewe as prys behaal”.1 Tim.6:11,14.\r\n \r\nIn 2 Tim.4:7 skryf hy: “Ek het die goeie wedloop afgelê; ek het die wenstreep bereik; ek het gelowig enduit volgehou.\r\n Nou wag die oorwinnaarskroon vir my, die lewe by God. \r\nOp die dag dat Hy weer kom, sal die Here dit vir vir my gee, en nie net vir my nie, maar ook vir almal wat met verlange uitsien na sy koms”.\r\n \r\nJa, volharding is om wat ookal met jou gebeur te omskep in nog ’n stap vorentoe. \r\n \r\nTov ons wedloop sê die Hebr. skrywer:12: 1 – 3\r\n \r\n“Hou jou oog gevestig op op Jesus Christus die Begin en die Voleinder van die geloof.\r\nHou Hom voor oë , dan sal julle nie geestelik moeg word en uitsak nie”.\r\n \r\nHou jou oog op Jesus.\r\nHy het Sy Wedloop, maw die pad wat God vir Hom uitgelê het, perfek geloop, tsv hindernisse.\r\nHy was die volmaakte voorbeeld.\r\nHy is ons voorloper.\r\n \r\nOp sy lewenspad het Hy geen sonde gedoen nie – \r\nmaar is gestraf vir sondaars.\r\nHy het ook nie vir die skande van die kruis teruggediens nie.\r\n \r\nAlles ter wille van jou en my.\r\n \r\nHy het die grootste offer gebring ter wille van ons verlossing, naamlik Homself.\r\n \r\nWaarop het Christus se volharding uitgeloop?\r\nSy wedloop het deur die skande en pyn van die kruisdood geloop tot by die Triomfantlike einde, waar Hy aan die Regterstoel van God sit.\r\n \r\nDaarom dat Hy aan die kruis kon sê: “Dit is Volbring”!\r\nOns moet ons oë op Hom gefokus hou.\r\nHoekom?\r\nSodat ons nie mismoedig word, geestelik moeg word en uitsak nie.\r\nAs ek wil uitval en wil moed opgee – moet ek na Hom kyk, na dit wat dit Hom gekos het om my te red.\r\nAs Hoë Priester sit Hy nou aan die regterkant van die troon van God.\r\n \r\nEn omdat Hy die pad met die hindernisse ken wat \r\nGod vir ons elkeen uitgewerk het - bid Hy nou om ons onthalwe dat God aan ons alles sal gee wat ons nodig het om klaar te maak.  \r\n \r\n- Hy is met een jou metgesel en die een wat vir jou wag.\r\nJy is nie alleen in jou wedloop nie.\r\n- Hy is die een wat jou aanmoedig en ondersteun om nie uit te sak nie;  \r\n \r\n- Wat jou in jou wedloop krag gee en uithou en aanhouvermoë; moed en hoop.\r\n \r\n- Hy is die een na wie jy moet kyk.\r\n \r\nHy is die enigste rede waarom ons die wedloop voltooi.\r\n \r\n= Wanneer jy jou oog op Hom gevestig, ja, genael hou, is Hy soos ’n magneet wat jou na Hom trek!\r\n \r\nHy wink en roep jou en my – “Kom! \r\nHardloop na My toe!”\r\n \r\nHy wag om vir jou en my te kroon! \r\n \r\nAmen.\r\n ', 'Nagmaal Ds Koos Saayman.mp3', 'Heb 12', ''),
(25, 'Die beste kom nog Dr JL Ras', '2009-03-15', '', '15 Maart 2009 Joh 5.mp3', 'Joh 5 Sondag 22', ''),
(21, 'Nabetragting Ds Koos du Plooy', '2009-03-08', '', 'Nabetragting Ds Koos du Plooy.mp3', 'Mat 18', ''),
(22, 'Bedankings', '2009-03-08', '', 'Bedankings Dr Frans en oudl Peet.mp3', '', '');
INSERT INTO `preke` (`id`, `naam`, `datum`, `preek`, `title`, `vers`, `tema`) VALUES
(34, 'Oul Lemmie vd Linde', '2009-03-22', '‘n Diakonale Toevalligheid.\r\n(Ds. Petrus Venter )\r\nLeespreek 22 Maart 2009 – Upington Geref. Kerk.\r\n \r\nSkriflesing:     Rut 2\r\nTeks:   Rut 2: 2 – 4; 12, 20.\r\nSing:   Ps. 147: 1, 5.             Ps. 119: 60                Ps. 119: 44                Ps. 65: 7, 9.\r\n \r\nRut 2 is ‘n Pinksterverhaal, want dit is alleen Pinkster, die Heilige Gees wat dinge so kan laat gebeur soos wat ons dit gelees het. Alles lyk na so ‘n groot toevalligheid in Rut se lewe. Toevallig het sy na die regte land, Boas se grond beweeg. Toevallig toe sy daar is, toe het Boas ook daar aangekom.  Hoe groot is die toeval by Rut wat daikonaal gehelp moet word. Teen die skynbaar toevallighede in wat alles met Rut gebeur, sien ons dat in wat vir ons toeval is, is die Here eintlik besig  om alles haarfyn te lei. Alles is vir ons haarfyn uitgewerk.\r\n \r\nEn gelukkig, of bygeval (wat direk beteken toevallig) , het Rut by ‘n stuk land uitgekom wat behoort het aan Boas uit die geslag van Elimeleg.\r\n \r\nEn in vers 4 lees ons in die Hebreeus dieselfde woord, wat die Afrikaans vertaal het met die woordjie JUIS. . . \r\n \r\nEn Boas het juis van Bethelehem afgekom . . . \r\n &

boet 0 Newbie Poster · Answer 3 · 2010-05-05T21:17:57+00:00

Hi everyone

I have a little problem I don't know how to fix.
When I add data into the 'Preke' fields and click the submit button, it takes me to a blank page.
It's suppose to take me to the 'Preke' page where the new info that's added, is displayed at the
top of the page, with the rest of the old info underneath.

I tried everything I know, but no results.

Please help!

Thanks!!

--
-- Table structure for table `preke`
--

CREATE TABLE IF NOT EXISTS `preke` (
`id` int(11) NOT NULL auto_increment,
`naam` varchar(100) NOT NULL,
`datum` date NOT NULL,
`preek` longtext NOT NULL,
`title` varchar(100) default NULL,
`vers` varchar(200) NOT NULL,
`tema` varchar(170) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;

INSERT INTO `preke` (`id`, `naam`, `datum`, `preek`, `title`, `vers`, `tema`) VALUES
(6, 'Dr. Jan Ras', '2009-02-01', 'Luk 13 v 9', 'preek.mp3', 'Luk 13:9', ''),
(7, 'Matt 2', '2009-01-11', '', '11 Jan 2009 Matt2 mp3.mp3', '', '');

Website coding:
---------------
Preke.php page:
---------------

<?php
		if ( $_GET['func'] == "addpost" )
		{
		
			
			include "mp3_upload.php";
			
			
			$query = "INSERT INTO preke SET ";
			if( $_FILES ['file']['name'] != "" )$query .= "title='" . $_FILES 

['file']['name'] . "', ";
			$query .= "naam='" . $_POST ['naam'] . "', ";
			$query .= "datum='" . $_POST ['datum'] . "', ";
			$query .= "vers='" . $_POST ['vers'] . "', ";
			$query .= "tema='" . $_POST ['tema'] . "', ";
			$query .= "preek='" . $_POST ['description'] . "'";
		
			mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" 

);
			
			header( "Location: index.php?page=preke");
		}
		
		if ( $_GET['func'] == "editpost" )
		{
			$preke = @mysql_query ( "SELECT * FROM preke WHERE id='" . $_POST ['id'] . 

"' LIMIT 1" );
			$row = mysql_fetch_assoc ( $preke );
			
			if( $_FILES ['file']['name'] != "" )$filename = "uploads/".$_FILES 

['file']['name']."";
			
			if (file_exists($filename)) {
			   unlink($filename);
			} 
			
			include "mp3_upload.php";
			
			
			$query = "UPDATE preke SET ";
			if( $_FILES ['file']['name'] != "" )$query .= "title='" . $_FILES 

['file']['name'] . "', ";
			$query .= "naam='" . $_POST ['naam'] . "', ";
			$query .= "datum='" . $_POST ['datum'] . "', ";
			$query .= "vers='" . $_POST ['vers'] . "', ";
			$query .= "tema='" . $_POST ['tema'] . "', ";
			$query .= "preek='" . $_POST ['description'] . "', ";
			$query .= "WHERE id='" . $_POST ['id'] . "'";
			
			mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" 

);
			header( "Location: index.php?page=preke");
		}
			
?>

Type_post.php page:
-------------------

<?php

	function page_config ()
	{
		return NULL;
	}
	
	function page_post ()
	{
		if ( !is_admin () ) return "index.php?page=login";
		
		$vacancies = @mysql_query ( "SELECT * FROM preke WHERE id='" . $_POST ['id'] . "' 

LIMIT 1" );
		$row = mysql_fetch_assoc( $vacancies );
		
		if ( $_GET ['func'] == "deletepost" )
		{
			$filename = "pages/admin/uploads/".$row['title']."";
									
			if (file_exists($filename)) {
			   unlink($filename);
			}

			$query = "DELETE FROM preke WHERE id='" . $_POST ['id'] . "'";
			mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" 

);

			return "index.php?page=preke";
		}
		
		return NULL;
	}
			
	function side_main ()
	{
		//$maincat = @mysql_query ( "SELECT * FROM cat_4 WHERE 

cat_3_id=".$_GET['cat_3_id']." LIMIT 1" );
		
		echo "<UL>";
			echo "<LI><A href=\"index.php?page=preke&func=add\">Voeg nuwe 

preek</A></LI>";
			echo "<LI><A href=\"index.php?page=main\">Administrasie</A></LI>";
			echo "<LI><A href=\"logout.php?func=logout\">Uitteken</A></LI>";
		echo "</UL>";
	}		
			
	function sub_main ()
	{		
echo "<table>";
	echo "<tr>";
	echo "<td>";
		echo "<h2>Preke</h2><br>";
		$list = @mysql_query ( "SELECT * FROM preke ORDER BY datum DESC" );

		if ( $list === false )
		{
			errormsg ();
			return;
		}
		if ( mysql_num_rows ( $list ) == 0 )
		{
			echo "<p>Geen Preke gevind nie</p>";
		}
		else
		{
		echo "<table width=\"100%\" border=\"0\" cellspacing=\"6\" cellpadding=\"2\">";
				echo "<tr>";
				$i = 0;
				while ( $listrow = mysql_fetch_assoc ( $list ) )
				{
						echo "<tr>";
						echo "<TD><A 

href=\"index.php?page=preke&func=edit&id=" . $listrow ['id'] . "\"><IMG 

src=\"../../images/admin/edit.png\" border=\"0\"></A></td>";
						echo "<td><A 

href=\"index.php?page=preke&func=delete&id=" . $listrow ['id'] ."\"><IMG 

src=\"../../images/admin/delete.png\" border=\"0\"></A></TD>";
						echo "<td width=\"90%\">". $listrow ['naam'] . 

"</td>";
						echo "</tr>";
					
				}
				echo "</tr>";
				echo "</table>";
			
		}
		echo "</td>";
	echo "</tr>";
		echo "</table>";
	}
	
	function sub_add ()
	{
		echo "<h2>Preke</h2>";
		
		echo "<P><img src=\"../../images/admin/info.gif\"> Sleutel in die volgende 

informasie en kliek op '<B>Aanvaar</B>' om aan te gaan.</P>";
		//lllllllllll
		echo "<FORM method=\"post\" enctype=\"multipart/form-data\" 

action=\"index.php?page=type_post&func=addpost\">";
		echo "<input type=\"hidden\" id=\"DPC_TODAY_TEXT\" value=\"today\">";
		echo "<input type=\"hidden\" id=\"DPC_BUTTON_TITLE\" value=\"Open calendar...\">";
		echo "<input type=\"hidden\" id=\"DPC_MONTH_NAMES\" value=\"['January', 

'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 

'December']\">";
		echo "<input type=\"hidden\" id=\"DPC_DAY_NAMES\" value=\"['Sun', 'Mon', 'Tue', 

'Wed', 'Thu', 'Fri', 'Sat']\">";
		
		layout_opentable ();
			
			echo "<TR>";
				echo "<TD>Naam</TD>";
				echo "<TD><INPUT type=\"text\" name=\"naam\" size=\"40\" 

maxlength=\"50\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Datum</TD>";
				echo "<TD><INPUT type=\"text\" name=\"datum\" 

id=\"DPC_calendar1b_YYYY-MM-DD\" size=\"40\" maxlength=\"50\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Vers</TD>";
				echo "<TD><INPUT type=\"text\" name=\"vers\" size=\"40\" 

maxlength=\"50\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Tema</TD>";
				echo "<TD><textarea name=\"tema\" cols=\"40\" rows=\"6\" 

></textarea></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Preek</TD>";
				echo "<TD><textarea name=\"description\" cols=\"80\" 

rows=\"20\"></textarea></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Preek Oplaai</TD>";
				echo "<TD><input type=\"file\" name=\"file\" size=\"60\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>&nbsp;</TD>";
				echo "<TD>";
					 
					echo "<INPUT type=\"submit\" name value=\"Aanvaar\">";
					echo "<INPUT type=\"button\" value=\"Kanseleer\" 

onclick=\"javascript:window.location.replace('index.php?page=preke');\">";
				echo "</TD>";
			echo "</TR>";
			
		layout_closetable ();
		echo "</FORM>";
		
	}
	
	function sub_delete ()
	{
		
		echo "<h2>Aanvaar</h2>";
		
		$qres = @mysql_query ( "SELECT * FROM preke WHERE id='" . $_GET ['id'] . "' LIMIT 

1" );
		if ( $qres === false )
		{
			errormsg ();
			return;
		}
		
		if ( @mysql_num_rows ( $qres ) === 0 )
		{
			errormsg ( "Preek nie gevind nie" );
			return;
		}

		$row = mysql_fetch_assoc ( $qres );
		
		echo "<FORM method=\"post\" action=\"index.php?page=preke&func=deletepost\">";
		echo "<INPUT type=\"hidden\" name=\"id\" value=\"" . $row ['id'] . "\">";
		echo "<P>Is u seker u wil '<B>" . $row ['naam'] . "</B>' afhaal?</P>";
		echo "<P>";
			echo "<INPUT type=\"submit\" value=\"Ja\">";
			echo "<INPUT type=\"button\" value=\"Kanseleer\" 

onclick=\"javascript:window.location.replace('index.php?page=preke');\">";
		echo "</P>";
		echo "</FORM>";
	}

	function sub_edit ()
	{
		echo "<h2>Preek</h2>";
		
		echo "<P><img src=\"../../images/admin/info.gif\"> Sleutel in die volgende 

informasie en kliek op '<B>Aanvaar</B>' om aan te gaan.</P>";
		
		$preke = @mysql_query ( "SELECT * FROM preke WHERE id='" . $_GET ['id'] . "' LIMIT 

1" );
		if ( $course === false )
		{
			errormsg ();
			return;
		}
		
		$row = mysql_fetch_assoc ( $preke );
		
		echo "<FORM method=\"post\" enctype=\"multipart/form-data\" 

action=\"index.php?page=type_post&func=editpost\">";
		echo "<input name=\"id\" type=\"hidden\" value=\"".$row['id']."\" />";
		echo "<input type=\"hidden\" id=\"DPC_TODAY_TEXT\" value=\"today\">";
		echo "<input type=\"hidden\" id=\"DPC_BUTTON_TITLE\" value=\"Open calendar...\">";
		echo "<input type=\"hidden\" id=\"DPC_MONTH_NAMES\" value=\"['January', 

'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 

'December']\">";
		echo "<input type=\"hidden\" id=\"DPC_DAY_NAMES\" value=\"['Sun', 'Mon', 'Tue', 

'Wed', 'Thu', 'Fri', 'Sat']\">";
		layout_opentable ();
			
			echo "<TR>";
				echo "<TD>Naam</TD>";
				echo "<TD><INPUT type=\"text\" name=\"naam\" size=\"40\" 

maxlength=\"50\" value=\"".$row['naam']."\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Datum</TD>";
				echo "<TD><INPUT type=\"text\" name=\"datum\" size=\"40\" 

id=\"DPC_calendar1b_YYYY-MM-DD\" maxlength=\"50\" value=\"".$row['datum']."\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Vers</TD>";
				echo "<TD><INPUT type=\"text\" name=\"vers\" size=\"40\" 

maxlength=\"50\" value=\"".$row['vers']."\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Tema</TD>";
				echo "<TD><textarea name=\"tema\" cols=\"40\" rows=\"6\" 

>".$row['tema']."</textarea></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Preek</TD>";
				echo "<TD><textarea name=\"description\" cols=\"80\" rows=\"20\" 

>".$row['preek']."</textarea></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>&nbsp;</TD>";
				echo "<TD>(Los leeg as daar nike opgelaai moet word nie)</TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>Preek Oplaai</TD>";
				echo "<TD><input type=\"file\" name=\"file\" value=\"\" 

size=\"60\"></TD>";
			echo "</TR>";
			echo "<TR>";
				echo "<TD>&nbsp;</TD>";
				echo "<TD>";
					echo "<INPUT type=\"submit\" value=\"Aanvaar\">";
					echo "<INPUT type=\"button\" value=\"Kanseleer\" 

onclick=\"javascript:window.location.replace('index.php?page=preke');\">";
				echo "</TD>";
			echo "</TR>";
			
		layout_closetable ();
		echo "</FORM>";
		
	}
	
	function page_main ()
	{
		switch ( $_GET ['func'] )
		{
		case "add"			: sub_add (); break;
		case "delete"		: sub_delete (); break;
		case "edit"			: sub_edit (); break;
		default				: sub_main (); break;
		}
	}

?>

-----------------------------------------------------------

boet 0 Newbie Poster · Answer 4 · 2010-05-06T14:51:16+00:00

Thanks for the advice on the one JRM. It worked perfectly and I also found and solved the problem. Thanks again.

boet 0 Newbie Poster · Answer 5 · 2010-05-06T17:19:31+00:00

Hi guys and girls,

Thanks for all the help, really appreciate it.
Can anyone help me with another problem? I have a query that I'm trying to execute, but it throws an error that goes as follow:
SQL Error: You have an error in your sql syntax: check the manual that corresponds to your MYSQL server version for the right syntax to use near 'Comic Sans MS\"\">Crystal Spring Minerals affiliate

Table Script:

REPLACE INTO "jos_acajoom_mailings" ("id", "list_id", "list_type", "issue_nb", "subject", "fromname", "fromemail", "frombounce", "htmlcontent", "textonly", "attachments", "images", "send_date", "delay", "visible", "html", "published", "createdate", "acc_level", "author_id", "params")

Could it be an error in the database coding or in the website coding?
If it's in the database coding, is it most likely to be in the Table script, or in the Insert script where you add the values

Please help!
Thank you!

nonshatter 26 Posting Whiz · Answer 6 · 2010-05-06T23:45:42+00:00

Dude,

You cannot post pages of code and expect us to solve it for you. If it's your 'job' to fix websites you should at least know how to troubleshoot a mysql error. I'm no expert, but the mysql error you posted literally tells you where the problem is occuring. Does "near 'Comic Sans MS\"\">Crystal Spring Minerals affiliate" not give you a hint?

JRM 107 Practically a Master Poster · Answer 7 · 2010-05-07T02:39:55+00:00

Thanks for the advice on the one JRM. It worked perfectly and I also found and solved the problem. Thanks again.

Please mark this thread as solved and start a new one if you have a different question.

As nonshatter says, avoid posting pages of code. Narrow it down to the to the trouble area(s).

DB access error

Recommended Answers Collapse Answers

All 10 Replies

Recommended Answers