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

`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!

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.

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.

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', '<p>Luk 13 v 9</p>', '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', '<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Tema: Jesus roep jou om te volhard!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dit word vertel dat tydens &lsquo;n Olimpiese spele in die stad Olimpia in Griekeland ter ere van die god Jupiter, dat &rsquo;n atleet wat in die marathon, die langafstand wedloop, laaste gekom het, dat hy meer toegejuig is, as die een wat eerste gekom het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">70,000 mense het hom glo van die pawiljoene af toegejuig &ndash;&nbsp; want hy het die wedloop voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">So het die leuse ontstaan naamlik dat dit nie in die eerste plek daaroor gaan dat jy moet </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">wen nie &ndash; maar dat jy aan die wedloop deelneem &ndash; en die marathon voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Die Bybel leer ons vanoggend opnuut&ndash; jou en my lewe is &rsquo;n wedloop wat ons elkeen met volharding moet hardloop en voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En nie elkeen wat die wedloop begin kry die prys nie &ndash; alleen hulle wat die wedloop voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En baie belangrik, soos wat daar by die OS duisende mense is wat van die pawiljoene af die </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">atlete toejuig en aanmoedig &ndash; 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 </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">sak nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Wie is die geloofskare waarvan Hebre</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;">r -skrywer praat?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">U weet mos - Dis almal mense wat toe hulle op aarde geleef het self volhard het en elkeen sy eie geloofswedloop voltooi het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hoe moedig hulle ons aan?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Deur die voorbeeld wat hulle op aarde gestel het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Deur hulle eie manier van lewe &ndash; maw dit waarvan hulle leefwyse getuig het in beproewings; in vervolging; versoekings.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hulle verhouding met God &ndash;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dat hulle op die ou end gelowig aan God vasgehou het, &nbsp;in lief en leed, &nbsp;en dus end uit volgehou het in hulle lewenswedloop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Daar is baie voorbeelde wat vir ons gegee word in </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hebrs.11: </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Noag; Abraham; Isak; Jakob; Josef; Moses; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ragab; Dawid en die profete.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Die Griekse woord vir wedloop &ndash; &ldquo;agon&rdquo; &ndash; daarvan </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">is die Engelse woord &ldquo;agony&rdquo; afgelei.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dit s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> dat hierdie wedloop nie &rsquo;n grap is nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dit vra baie van jou. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dis &rsquo;n pad wat God vir elkeen van ons uitgel</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> het wat net met stamina van Bo voltooi kan word.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Maw God weet hoeveel genade elkeen van ons nodig het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ja, elkeen se wedloop-roete is deur God vir hom uitgewerk.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">= Noag &ndash; kry die byna belaglike opdrag van God </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">om die ark te bou.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Maar hy het God geglo en vertrou en gehoorsaam.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het alles gedoen presies soos God hom beveel het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ons weet waarop sy volharding uitgeloop het.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het &rsquo;n erfgenaam geword van die vryspraak wat deur die geloof kom.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">= Abraham was bereid om toe God hom roep te trek sonder om te weet waar hy sou uitkom. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ook om sy enigste seun te slag en te offer as God dit van hom vra.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">= Ragab &rsquo;n prostituut in Jerigo het ogv wat sy van die God van die Israeliete gehoor het geglo en die verspieders vriendelik ontvang en weggsteek. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Met die verowering van die stad is sy en haar familie gered. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Haar naam is later in die geslagsregister van Jesus opgeneem. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">=Dawid. Wat sal ons van Hom s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;? </span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy wat met voorbedagte rade owerspel en moord pleeg?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Was hy so &rsquo;n voorbeeld van &rsquo;n atleet wat volhard op sy geloofswedloop?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Nee &ndash; maar sy berou en bekering, sy verhouding met God verder in sy veelbewo</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;"> lewe </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">was &rsquo;n bewys dat hy kon opstaan en sy wedloop voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy en die ander geloofgetuies wat hul wedloop voltooi het praat met ons.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hulle motiveer ons en moedig ons aan: &ldquo;Dit kan gedoen word!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Jy kan dit ook doen&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">In die fliek &ndash; &ldquo;Dead poets society&rdquo; &ndash; wys &rsquo;n onderwyser geraamde fotos van oudskoliere in die </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">skoolportaal aan &rsquo;n groep seuns.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Baie van die oudskoliere is baie oud of reeds oorlede en hy vra dan vir hulle &ndash; wat s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> die gesigte op die vergeelde fotos vir julle? </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Wat is hulle boodskap vandag aan julle?&nbsp; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En die boodskap is: &ldquo;Carpe diem!&rdquo;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hou aan! Koop die tyd uit! Maak die beste gebruik van elke geleentheid!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Volhard! </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ja, hulle en al die mense wie se geskiedenis opgeskryf is in die Bybel &ndash; al die gelowiges deur</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">die eeue - hulle wag op ons elkeen, tot op die laaste een van ons om ons wedloop te voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dan sal die skare geloofsgetuienis voltallig wees.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En sal hulle en ons almal saam die kroon van die ewige lewe ontvang.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Daarom moet ons volhard.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Helvetica; color: #404040;">&nbsp;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">By bykans elkeen s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc; </span></span><span style="font-size: 10pt; font-family: Gautami;">die Hebre</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;">r-skrywer...omdat </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">hy/sy geglo het...het hulle in hul wedloop kon volhard.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Luister wat s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> Jakobus oor die profete:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&ldquo;Neem die profete wat in die Naam van die Here gepraat het as voorbeeld van lyding en geduld. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ons noem hulle gese</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;">nd omdat hulle volhard het&rdquo;. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En dan hy verwys ook spesifiek na Job se volharding:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Job 2:3: &ldquo;Die Here het vir die satan gevra: Het jy ag gegee op my kneg Job?.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&nbsp;Hy volhard in sy vroomheid, alhoewel jy My teen hom opgehits het om hom te vernietig sonder oorsaak&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Job se volharding kry dan ook &rsquo;n ander dimensie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Want luister hoe hy sy vrou antwoord as sy hom vra in al sy elende:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&rdquo; Volhard jy nog in jou vroomheid? </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Vervloek God en sterf!&rdquo;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Maar hy weier.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy antwoord eerder: &ldquo;As ons die goeie van God wil ontvang &ndash; waarom nie ook die slegte</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">nie?&rdquo;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Jakobus s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> dan ook van Job: &ldquo;Julle het gehoor van die volharding van Job en julle het gesien waarop die Here dit laat uitloop het&rdquo;. 5:10,11 </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Waarop het dit uitgeloop?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Lees gerus weer die aangrypende deel in die einde van die boek Job 42:12 - 17: </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&ldquo;Die Here het die laaste deel van Job se lewe voorspoediger gemaak as die eerste&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">So wat beteken die begrip &ldquo;volharding&rdquo; volgens die </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Bybel en hoe kom dit te pas in jou lewe?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dis om aan te hou om die regte ding te doen.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om uithouvermo</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;"> te toon onder alle omstandighede, ook omstandighede wat die lewe vir jou bitter moeilik en ondraaglik maak, maar dat jy steeds blymoedig bly.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&nbsp;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">s dit nie &rsquo;n mondvol nie?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om aan te hou glo in die goedheid van God en om Hom te vertrou.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om gedetermineerd en vasberade te wees in die praktiese uitlewing van jou godsdiens. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Is u so &rsquo;n mens?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ken u sulke mense, al het hulle te oud en afgeleef geraak, om vandag geloofsgesprekke met jou te h</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;">, maar wie se leefwyse van vroe</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;r, 20 ,30, 50&nbsp; jaar </span></span><span style="font-size: 10pt; font-family: Gautami;">gelede vandag steeds vir jou tot aansporing dien om te volhard?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Onthou u sulke mense wat al heengegaan het wie se nagedagtenis vir jou &lsquo;n getuienis is van hul volharding?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Almal mense wat jou ook bywyse van spreke vanuit die hemel aanmoedig.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Almal mense wat toe hulle geleef het enduit uitgehou het en met deursettingsvermoe en </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">toewyding aangehou het om te doen wat reg is?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Mense wat geduldig volhard en steeds bly glo in die goedheid van die Here?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God het deur my kontak met ons swart lidmate by die Diepsloot plakkerskamp &rsquo;n verdiepende perspektief in my geloofslewe ingebring.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hulle spontane blymoedigheid en vriendelikheid.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hulle vergenoegdheid al het hulle nie werk nie en min lewensmiddele.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hulle vrygewigheid en mededeelsaamheid.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hulle tevredenheid om in bouvallige een vertrek- geboutjies te bly dikwels sonder lopende water of elektrisiteit.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hulle aanpasbaarheid, opofferings en bereidheid om somer en winter ver te loop om by die kerk uit te kom.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dis kinders van die Here met uithouvermo&euml; tmv dinge wat die lewe vir hulle baie moeilik maak.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Mense wat steeds onwrikbaar glo in die liefde van die Here vir hulle.</span></p>\r\n<p class="MsoNormal" style="margin: 6pt 0cm; line-height: 16.8pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Dis volharding geinspireer deur hoop en vertroue in <span style="color: black;">God.</span></span></p>\r\n<p class="MsoNormal" style="margin: 6pt 0cm; line-height: 16.8pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Soos iemand s&ecirc;:&nbsp; Hebrs. 12:1 is &lsquo;n trompetgeskal of geweerskoot om ons te waarsku dat die laaste rondtes begin het om ons lewens te sien as &lsquo;n wedloop wat met passie, ywer, toewyding, energie en dissipline gehardloop moet word.</span></p>\r\n<p class="MsoNormal" style="margin: 6pt 0cm; line-height: 16.8pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">En as die Hebre</span><span style="font-size: 10pt; color: black;"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami; color: black;">rsskrywer s</span><span style="font-size: 10pt; color: black;"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami; color: black;">: &ldquo;Gooi elke las af.</span></p>\r\n<p class="MsoNormal" style="margin: 6pt 0cm; line-height: 16.8pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Ook &nbsp;die sonde wat jou so maklik verstrik&rdquo; &ndash; dan bedoel hy: &ldquo;Neem die wedloop ernstig op!&rdquo;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">In ons wedloop....s</span><span style="font-size: 10pt; color: black;"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami; color: black;"> die Hebr. skrywer...moet ons:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Elke las oftewel gewig van ons afgooi. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Die Griekse woord hier impliseer menslike oorgewig.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Van hierdie oor-gewig, die las, die hindernis moet jy ontslae raak deur die regte geloofsoefening. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Soos &rsquo;n swaar kleed wat om jou skouers hang, wat jou belemmer in jou wedloop, moet dit weggewerp word.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Maw alles wat jou geestelike groei en vordering belemmer.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En as die skrywer praat van sondes wat ons so maklik verstrik &ndash; verwys hy na dit wat die satan deur sy versoekings aan jou wil doen.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Soos seekatarms moet hierdie versoekings &rsquo;n al hoe groter houvas op jou leefwyse kry en jou moed en wil breek om te volhard in jou wedloop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Satan wil jou verstrik en pooitjie sodat jy val en bly l</span><span style="font-family: Times New Roman;"><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL">&ecirc;. </span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Jou oog op Christus moet vervaag sodat jy nie jou einddoel bereik nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hierdie versoekings moet jy ontvlug en agterlaat en na Jesus toe hardloop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Dws &ndash; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om jou gebedslewe lewendig en aktief te hou.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om jou gees voortdurend te voed met die waarhede uit God se Woord.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om bywyse van spreke die oog wat verleiding soek uit te pluk.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om die hand wat uitreik na verkeerde begeertes af te kap.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om so die satan te weerstaan.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om elke gedagte wat in jou kop opkom gevange te neem en aan Jesus gehoorsaam te maak.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">So &ndash; wat behels my wedloop?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Wat is die laste wat ek&nbsp; moet afgooi?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Wat is die sondes wat die satan voor my voete gooi?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Waarin moet ek volhard? </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ek vra dit terwyl ons weet:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&lsquo;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.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook steeds verlei word en sonde doen.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook aan drank of dwelms of watookal verslaaf raak.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan Hy ook troosteloos ineen stort as gevolg van aanhoudende beproewings.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook dikwels totaal moedeloos en kragteloos voel.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook depressief raak en moeg word vir die lewe.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook eensaamheid ervaar.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook ook soms verstote voel.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook onder die die tonge van onsimpatieke&nbsp; en onvergewingsgesinde mense deurloop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy kan ook deur ander verontreg word.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Sy geloofslewe kan ook slordig word en sy gebedslewe taan.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Sy verhouding en omgang met God kan ook oppervlakkig word.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">&rsquo;n Christen se lewe &ndash; U en my lewe vra volharding.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God vra volharding.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God skenk ook volharding!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Volharding om al die dinge wat op jou pad kom in jou wedloop te kan hanteer &ndash; met Goddelike hulp en bystand.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ja, ons moet in hierdie land as Christene volhard om elke dag tmv allerlei gevare voort te gaan met ons lewens &ndash; om jou beroep te getrou te beoefen; om jou gesin te versorg.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om te volhard om daarin om die Goue re</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;">l van Jesus toe te pas, naamlik &ndash; om die goeie en mooi dinge wat jy wil h</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> dat ander aan jou moet doen, om </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">dit eerste aan hulle te gaan doen.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Volharding in die dra van die vrugte van die Gees.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om te volhard in jou geloof in en jou vertroue op God &ndash; dat Hy jou sal beskerm en lei. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om te volhard in jou geloof dat Hy jou liefhet en dat Hy oorvloedige genade vir jou het deur Jesus Christus.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om te volhard in jou soeke na God se wil.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Om te volhard in jou stryd teen satan, en voortdurend jou sondes te bely en daaruit op te </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">staan....</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God het die prostituut Ragab gered.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het Dawid sy ontrou vergewe en gedra in sy geloofsworsteling.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God het hulle ondersteun in hul en geloofswedloop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hoekom nie ook vir jou en my nie?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Kyk na Paulus se lewe:</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Sy lewe was een lang tydperk van ontberings.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Op sy lewenswedloop het hy met baie teestand en vyandigheid te doen gekry.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Hy het dit fisies aan sy lyf gevoel.</span></p>\r\n<p class="MsoHeading7" style="margin: 12pt 0cm 3pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Tog volgehou en volhard om sy goddelike roeping uit te voer....</span></p>\r\n<p class="MsoHeading7" style="margin: 12pt 0cm 3pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">In Filip. 4: 13: skryf hy: &ldquo;Ek is tot alles in staat deur Hom wat my krag gee&rdquo;. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">En in Filip. 3: 12-15 (14,15) skryf hy:&nbsp; &ldquo;E<em>k span my in</em> om by die wenstreep te kom...sodat ek die hemelse prys kan behaal&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Ja, VOLHARDING tsv doring in sy vlees.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Luister na sy raad aan Timotheus: </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">&ldquo;In die goeie wedloop van die geloof moet jy al jou kragte inspan en die ewige lewe as prys behaal&rdquo;.1 Tim.6:11,14.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">In 2 Tim.4:7 skryf hy: &ldquo;Ek het die goeie wedloop afgel</span><span style="font-size: 10pt; color: black;"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami; color: black;">; ek het die wenstreep bereik; ek het gelowig enduit volgehou.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">&nbsp;Nou wag die oorwinnaarskroon vir my, die lewe by God. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Op 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&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Ja, volharding is om wat ookal met jou gebeur te omskep in nog &rsquo;n stap vorentoe. </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Tov ons wedloop s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> die Hebr. skrywer:<span style="color: black;">12: 1 &ndash; 3</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">&ldquo;Hou jou oog gevestig op op Jesus Christus die Begin en die Voleinder van die geloof.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Hou Hom voor o</span><span style="font-size: 10pt; color: black;"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami; color: black;"> , dan sal julle nie geestelik moeg word en uitsak nie&rdquo;.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hou jou oog op Jesus.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het Sy Wedloop, maw die pad wat God vir Hom uitgel</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;</span></span><span style="font-size: 10pt; font-family: Gautami;"> het, perfek geloop, tsv hindernisse.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy was die volmaakte voorbeeld.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy is ons voorloper.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Op sy lewenspad het Hy geen sonde gedoen nie &ndash; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">maar is gestraf vir sondaars.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het ook nie vir die skande van die kruis teruggediens nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Alles ter wille van jou en my.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy het die grootste offer gebring ter wille van ons verlossing, naamlik Homself.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami; color: black;">Waarop het Christus se volharding uitgeloop?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Sy wedloop het deur die skande en pyn van die kruisdood geloop tot by die Triomfantlike einde, waar Hy aan die Regterstoel van God sit.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Daarom dat Hy aan die kruis kon s</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&ecirc;: </span></span><span style="font-size: 10pt; font-family: Gautami;">&ldquo;Dit is Volbring&rdquo;!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Ons moet ons o</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;"> op Hom gefokus hou.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hoekom?</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Sodat ons nie mismoedig word, geestelik moeg word en uitsak nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">As ek wil uitval en wil moed opgee &ndash; moet ek na Hom kyk, na dit wat dit Hom gekos het om my te red.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">As Ho</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;"> Priester sit Hy nou aan die regterkant van die troon van God.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">En omdat Hy die pad met die hindernisse ken wat </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">God 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.&nbsp; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hy is met een jou metgesel en die een wat vir jou wag.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Jy is nie alleen in jou wedloop nie.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hy is die een wat jou aanmoedig en ondersteun om nie uit te sak nie;&nbsp; </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Wat jou in jou wedloop krag gee en uithou en aanhouvermo</span><span style="font-size: 10pt; mso-ansi-language: NL;" lang="NL"><span style="font-family: Times New Roman;">&euml;</span></span><span style="font-size: 10pt; font-family: Gautami;">; moed en hoop.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">- Hy is die een na wie jy moet kyk.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy is die enigste rede waarom ons die wedloop voltooi.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">= Wanneer jy jou oog op Hom gevestig, ja, genael hou, is Hy soos &rsquo;n magneet wat jou na Hom trek!</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy wink en roep jou en my &ndash; &ldquo;Kom! </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hardloop na My toe!&rdquo;</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Hy wag om vir jou en my te kroon! </span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;">&nbsp;</p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 10pt; font-family: Gautami;">Amen.</span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: Times New Roman; font-size: small;">&nbsp;</span></p>', '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', '<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center;" align="center"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&lsquo;n Diakonale Toevalligheid.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center;" align="center"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">(Ds. Petrus Venter )</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center;" align="center"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">Leespreek 22 Maart 2009 &ndash; Upington Geref. Kerk.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">Skriflesing:<span style="mso-tab-count: 1;">&nbsp;&nbsp;&nbsp;&nbsp; </span>Rut 2</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">Teks:<span style="mso-tab-count: 1;">&nbsp;&nbsp; </span>Rut 2: 2 &ndash; 4; 12, 20.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">Sing:<span style="mso-tab-count: 1;">&nbsp;&nbsp; </span>Ps. 147: 1, 5.<span style="mso-tab-count: 2;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Ps. 119: 60<span style="mso-tab-count: 2;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Ps. 119: 44<span style="mso-tab-count: 2;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Ps. 65: 7, 9.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">Rut 2 is &lsquo;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 &lsquo;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. <span style="mso-spacerun: yes;">&nbsp;</span>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<span style="mso-spacerun: yes;">&nbsp; </span>om alles haarfyn te lei. Alles is vir ons haarfyn uitgewerk.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-size: small;"><em style="mso-bidi-font-style: normal;"><span style="font-family: Arial;" lang="AF">En gelukkig, of bygeval </span></em><span style="font-family: Arial;" lang="AF">(wat direk beteken toevallig) <em style="mso-bidi-font-style: normal;">, het Rut by &lsquo;n stuk land uitgekom wat behoort het aan Boas uit die geslag van Elimeleg.</em></span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">En in vers 4 lees ons in die Hebreeus dieselfde woord, wat die Afrikaans vertaal het met die woordjie JUIS. . . </span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-size: small;"><em style="mso-bidi-font-style: normal;"><span style="font-family: Arial;" lang="AF">En Boas het <strong style="mso-bidi-font-weight: normal;">juis</strong> van Bethelehem afgekom . . . </span></em><span style="font-family: Arial;" lang="AF"></span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">&nbsp;&

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', '<p>Luk 13 v 9</p>', '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;
		}
	}

?>

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

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.

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

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!

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?

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).

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.