0

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

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

3
Contributors
10
Replies
12
Views
7 Years
Discussion Span
Last Post by JRM
0
`courier` float NOT NULL default '0',

Needs to be:

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

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

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

Edited by nonshatter: n/a

0

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.

0

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.

0

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;</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;">Weet die skrywer van Rut dan nie dat daar geen toeval is nie (Son. 10 HK) ?</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;">Broeder en suster, op eg die menslike van die verhaal het ons alreeds gewys. Dit is eintlik eg menslik om te dink dat dinge toevallig in ons lewe gebeur. Die Heilige Gees gebruik as&rsquo;t ware hierdie eg menslike eienskap en uitgangspunt van ons as mense om dit wat vir ons toeval lyk, uit te wys as die Here se bestier. Dit wat skynbaar toevallig gebeur het, in in werklikheid presies hoe die Here dit bestier het.</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;">Al was daar nou weer brood in Bethlehem,<span style="mso-spacerun: yes;">&nbsp; </span>beteken dit nie dat daar vanselfsprekend brood in Naomi se huis was nie. Kos kom mos nie vanself na &lsquo;n mens toe nie, dit moet gehaal word; daarvoor moet gewerk word.</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;">Deurdat Rut haar land, haar volk, haar familie, haar sekuriteit prysgegee het, gaan sy en Naomi gehelp kan word. Sien u hier alreeds die bestier van God raak, dit wat so na blote toeval lyk ?</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;">Hierin wys die Here vir ons hoe Hy wat God is, van vroeg reeds sy diakens, sy daikonale hulp uitgeplaas het. Hulp is nie vir die Here maar &lsquo;n saak van toeval nie. Hulp is vir God &lsquo;n <strong style="mso-bidi-font-weight: normal;">moet</strong>, al lyk dit dalk vir ons <strong style="mso-bidi-font-weight: normal;">toevallig</strong>. Hierdie is dieselfde hulp wat ons diakens vandag nog moet kan en wil gee. In die tyd het die Here die hulp so bepaal volgens Levitikus 19 en Levitikus 23 en ook Deutronomium 24, dat wanneer die Israeliete hulle oeste insamel, hulle die are wat per ongeluk uitval nie mag optel nie. Sou daar selfs &lsquo;n hele gerf op die land agterbly en hulle dit vergeet, dan mag dit nie weer gaan haal word nie. Hulle moet ook nie die lande tot op die hoeke afoes nie. Hulle moes die hoeke maar rond afsny dat daar nog op die hoeke graan oorbly.</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;">Dit is met hierdie re&euml;ling van die Here waarmee Rut ook nou vertroud geraak het, en<span style="mso-spacerun: yes;">&nbsp; </span>waarmee sy na die graanlande stap. Tog moet ons nie vergeet in watter tyd sy dit doen nie. Sy doen dit in die slegte tyd van die rigters. &lsquo;n Tyd waar daar geen koning was nie, &lsquo;n tyd waarin elkeen maar gedoen het wat reg was in sy eie o&euml;. Hoe gevaarlik sou dit wees vir &lsquo;n vreemdeling, en dit boonop nog vrou-alleen om na die lande te stap in die warm oosterse son.</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;">By geval/toevallig kom Rut by die land aan, en volgens vers 7 wil dit lyk of sy eers toestemming gevra het om daar are te mag optel. Daar blyk nog verdere toeval in Rut se lewe te wees. Boas het toevallig op daardie stadium van Bethlehem afgekom.</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;">Die geluk of toeval gebeur onder God se hand, of ons kan ook praat van onder God se vlerke, soos wat Boas vir Rut in vers 12 s&ecirc;:</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 36pt; text-indent: 36pt; 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">die God onder wie se vleuels jy kom skuil het.</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;</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;">Wie die weg van die Here berwandel, of dit nou &lsquo;n regering is, &lsquo;n vermo&euml;nde ryk man of &lsquo;n enkele vreemdeling-vrou, so iemand kan die se&euml;ninge van die Here te wagte wees. Die Heilige Gees werk sigbaar !</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;">Die ontmoeting van Boas met Rut is nie net die draaipunt van die hele verhaal van Rut wat ons tot dusver gelees het nie, maar benewens die normale draaie, kom daar die kardinaal ingrypende draaie in die mense se lewe. Hier is God deur die ontmoeting van Boas met Rut, sonder dat een van hulle dit nog geweet het, eintlik besig om hulle lewe kardinaal te draai.</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;">Die Here het Boas al met &lsquo;n skaduwee van die diaken-amp gese&euml;n, as ons sien hy tot Rut nader. Boas weet toe alreeds alles van Rut af, sy werkers het hom vertel. Hy kon help sonder om met haar te praat, maar tog wil hy ook praat met<span style="mso-spacerun: yes;">&nbsp; </span>die een wat hy wil help. Die diaken is ook pastoraal besig. Met woorde moet hy bemoedig, aanmoedig, vertroos, hy moet ruimhartig wees.</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;">Daardie begrip van Boas vir Rut se situasie is nie maar net om van haar ontslae te raak nie, maar Boas sien God daarin raak. Boas is heilsordelik besig. Boas het &lsquo;n heils-, &lsquo;n verlossingsbegrip; hy wil vir Rut van haar en haar skoonma se honger en ellende verlos.</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;">Nooit sou Boas <span style="mso-spacerun: yes;">&nbsp;</span>besef dat Rut op haar beurt weer as instrument gebruik sou word om die heil, die groot verlossing, die finale heil te bewerk nie.</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 sou selfs saam met Boas kon aansit en eet. Sy wat &lsquo;n vreemdeling is, Boas is nou haar gasheer. Naomi het ges&ecirc; dat God haar vol laat wegtrek het, en leeg laat terugkeer het, maar hier kom Rut<span style="mso-spacerun: yes;">&nbsp; </span>en wys die omgekeerde. Leeg het Rut daardie oggend weggetrek, maar vol het God haar daardie aand laat terugkeer. Selfs Naomi se lewe het verander. Naomi het weer haar sprankelende lieflikheid teruggevind.</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;">U het die Heilige Gees sigbaar in Boas sien werk. In sy diakonale werk is daar die liefde van God. U moet weet die liefde hou nie maar daar op nie. Kyk wat doen die werk van die Gees deur Boas aan Naomi se lewe. Pinkster<span style="mso-spacerun: yes;">&nbsp; </span>het verby Rut tot Naomi deurgedring. Die bittere, verbitterde, Mara het weer Naomi geword. Dieselfde vrou praat nou soveel anders. Sy het haar lieflikheid teruggevind, en dit deur hom wat diakonaal opgetree het. Sy het weer nuwe hoop. Sy het nuwe hoop op kos en &lsquo;n nageslag gekry.</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;">So is die werk van de Heilig Gees nie net lewendwekkend nie, maar die Gees wek in ons nuwe hoop. Sy sien weer kans vir wat voorl&ecirc;. Hoor hoe die ek&rsquo;ke van haar lewe in hoofstuk 1 vervang word met die woordjie ons ... vers 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;"><span style="mso-tab-count: 1;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><em style="mso-bidi-font-style: normal;">Die man is <strong style="mso-bidi-font-weight: normal;">ons</strong> naasbestaande... hy is een van <strong style="mso-bidi-font-weight: normal;">ons</strong> lossers</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;">Naomi glo weer, sy vertrou, die Here is weer vir haar die Here van die verbond, nie net meer Almagtige nie.</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt 36pt; line-height: 150%; text-align: justify;"><span style="font-family: Arial;" lang="AF"><span style="font-size: small;">...<em style="mso-bidi-font-style: normal;">Mag hy gese&euml;nd wees deur die Here wat sy guns aan lewende en dode nie onttrek nie.</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;">Naomi, die verlore dogter van die Ou Testament het by haar hemelse Vader teruggekom.</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;">U wat diakens is, mag Boas vir u gewys het waartoe diakonale hulp in staat is, al lyk dit so klein. Die resultaat strek baie verder as net Boas en Rut, dit loop deur tot by Naomi, dit gaan deur tot by Jesus Christus. U wat diakonale hulp moet ontvang, moet dit nie weier nie, onthou, dit het met Pinkster te doen. Geesvervulde diakonale hulp moet nie onderskat word nie. Dit wat alles so toevallig gelyk het, dit laat Naomi die voorsienigheid van God bely. Sy is nie meer Mara nie. Aan die begin wou sy haar naam verander en nie haar hart nie, nou verander haar hart en nie haar naam nie.</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;">Broeder en suster, word u ook nie toevallig opgeroep om daadwerklike liefde aan u medegelowige en aan ander mense te bewys nie.</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;">Dit mag meskien so lyk, dit mag moeite wees, dit mag selfs so klein lyk, maar soos die Here deur Sagaria s&ecirc;</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;"><span style="mso-tab-count: 1;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><em style="mso-bidi-font-style: normal;">Moenie die dag van die klein dingetjies gering ag nie.</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;">In die klein dingetjies is ons in Jesus, die Seun van die grote God, tot heerlikheid gereken.</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;">AMEN.</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;">&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;">&nbsp;</span></span></p>', NULL, 'Rut 2', 'Dikonale toevalligheid');
INSERT INTO `preke` (`id`, `naam`, `datum`, `preek`, `title`, `vers`, `tema`) VALUES
(36, 'Oudl. Flip vd Steen', '2009-03-29', '<p class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-outline-level: 1;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;">Leesdiens</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;">Ons hulp is in die Naam van die Here wat die hemel en die aarde gemaak het en wat trou bly tot in ewigheid.<span style="mso-spacerun: yes;">&nbsp; </span>Amen</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-outline-level: 1;"><strong><em style="mso-bidi-font-style: normal;"><span style="text-decoration: underline;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Lofpsalm</span></span></span></em></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Ps 32 vers 2,3 en 4</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">2</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Toe ek voor U al worst&rsquo;lende verstom het</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Geen boetegebed my uit die hart gekom het,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Het my gebeent&rsquo;, verskrik deur my geklag,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Verswak en uitgeteer die ganse dag.</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">U hand het swaar gedruk op al my lede;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Bedags geen rus, en snags geen stem van vrede;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">My krag het weggedroog van uur tot uur</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Soos velde deur die somersonnevuur</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">3</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Ek het bely,o Heer! &ndash;in sielerou nie</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">My hart gegrendel of my mond weerhou nie.</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Ek het bely wat my van U vervreem,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">U het my skuld genadig weggeneem.</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Dus kom Gods volk, dus kom al sy bemindes</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: Times New Roman;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;">Om</span></strong><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"> Hom te soek terwyl sy guns te vind is;</span></strong></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Die lewensee mag met sy golwe slaan,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Dit deer hul nie dit raak hul selfs nie aan.</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">4</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">U is dit , Heer, wat tot my hulp gereed is,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">&lsquo;n skut en skerm in alle angs en leed is;</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">In nood my red, met jubels my omring,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">En in my gees weer vreugde laat ontspring.</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">Maar nee, o God, U goedheid reik nog verder!</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">U s&ecirc;: Ek wil jou oppas soos &lsquo;n herder,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Times New Roman;">En wil jou voet op veil&rsquo;ge pad laat gaan,</span></span></strong></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: Times New Roman;"><strong style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;">Waarop my oog jou altyd gade slaan</span></strong></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;"><span style="mso-spacerun: yes;">&nbsp; </span><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;</span></span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-outline-level: 1;"><span style="font-family: Times New Roman;"><em style="mso-bidi-font-style: normal;"><span style="text-decoration: underline;"><span style="font-size: 12pt; mso-bidi-font-weight: bold;">Geloofsbeleidenis</span></span></em><em style="mso-bidi-font-style: normal;"></em></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;">Ek glo in God die Vader, die Almagtige, die Skepper van die hemel en die aarde. En in Jesus Christus, Sy eniggebore Seun, Ons Here wat ontvang is van die Heilige Gees, gebore uit die maagd Maria, wat gely het onder Pontius Pilatus, gekruisig, gestorwe en begrawe is en neergedaal het na die hel, wat op die derde dag weer opgestaan het uit die dode; opgevaar het na die hemel en sit aan die regterhand van God, die Almagtige Vader, van waar hy sal kom om te oordeel die lewende en die dode.<span style="mso-spacerun: yes;">&nbsp; </span>Ek glo in die Heilige Gees.<span style="mso-spacerun: yes;">&nbsp; </span>Ek glo aan &lsquo;n heilige algemene kerk, die gemeenskap van die heiliges, die vergewing van sondes; die wederopstanding van die vlees; en &lsquo;n ewige lewe.<span style="mso-spacerun: yes;">&nbsp; </span></span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-outline-level: 1;"><span style="font-family: Times New Roman;"><em style="mso-bidi-font-style: normal;"><span style="text-decoration: underline;"><span style="font-size: 16pt; mso-bidi-font-weight: bold;">Wet </span></span></em><em style="mso-bidi-font-style: normal;"><span style="font-size: 16pt;">Exsodus 20</span></em></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;">&nbsp;</span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;"><span style="mso-spacerun: yes;">&nbsp;</span></span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;">Toe het God al hierdie woorde gespreek en ges&ecirc;.<span style="mso-spacerun: yes;">&nbsp; </span>Ek is die Here jou God wat jou uit Egipteland, uit die slawehuis uitgelei het.<span style="mso-spacerun: yes;">&nbsp; </span>Jy mag geen ander gode voor my aangesig h&ecirc; nie.<span style="mso-spacerun: yes;">&nbsp; </span>Jy mag vir jou geen gesnede beeld of enige gelykenis maak van wat bo in die hemel is of wat onder op die aarde is, of wat in die waters onder die aarde is nie. </span></span></p>\r\n<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 16pt;"><span style="font-family: Times New Roman;"><span style="mso-spacerun: yes;">&nbsp;</span>Jy mag jou voor hulle nie neerbuig en hulle dien nie, want Ek, die Here jou God, is &lsquo;n jaloerse God wat die misdaad van die vaders besoek aan die kinders aan die derde en aan die vierde geslag van die wat My haat, en Ek bewys barmhartigheid aan duisende van die wat my liefhet en my gebooie onderhou.<span style="mso-spacerun: yes;">&nbsp; </span></span></span></p>\r\n<p clas

Edited by nav33n: Please use [code][/code] tags to wrap your code for easy readability. And also, post only *relevant code*.

0

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;
		}
	}

?>

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

Edited by nav33n: Use [code][/code] tags.

0

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.

0

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

0

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!

0

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?

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.