Hi all,

I am getting the following error:

Fatal error:  Call to undefined function VDFormat()

I am not an IT god, infact nowhere near it. I can remember the basics etc. however I can't troubleshoot.

I do know that I need to define VDFormat, however I have no idea where to start with the coding on that.

Can anyone help?

Regards,

line 36

No, that's wrong, it is line 38.

Yeh okay... sorry... I forgot to add in the code that I am using...

<?php
$sDatabase = 'client_quotes';
$sHostname = 'localhost';
$sPort     = 3306;
$sUsername = '';
$sPassword = '';
$sTable    = 'client_quotes';

$rConn = mysql_connect("$sHostname:$sPort", $sUsername, $sPassword) or die(mysql_error());
mysql_select_db($sDatabase);

$sName = VDFormat($_POST['Name'], true);
$sQuery = "INSERT INTO $sTable SET Name = '$sName'";

$sOtherNames = VDFormat($_POST['OtherNames'], true);
$sQuery = "INSERT INTO $sTable SET OtherNames = '$sOtherNames'";

$sCountry = VDFormat($_POST['Country'], true);
$sQuery = "INSERT INTO $sTable SET Country = '$sCountry'";

$sArrAirport2 = VDFormat($_POST['ArrAirport1'], true);
$sQuery = "INSERT INTO $sTable SET ArrAirport1 = '$sArrAirport1'";

$sArrAirport2 = VDFormat($_POST['ArrAirport2'], true);
$sQuery = "INSERT INTO $sTable SET ArrAirport2 = '$sArrAirport2'";

$sArrAirport3 = VDFormat($_POST['ArrAirport3'], true);
$sQuery = "INSERT INTO $sTable SET ArrAirport3 = '$sArrAirport3'";

$sResort = VDFormat($_POST['Resort'], true);
$sQuery = "INSERT INTO $sTable SET Resort = '$sResort'";

$sHotel = VDFormat($_POST['Hotel'], true);
$sQuery = "INSERT INTO $sTable SET Hotel = '$sHotel'";

$sDepAirport = VDFormat($_POST['DepAirport'], true);
$sQuery = "INSERT INTO $sTable SET DepAirport = '$sDepAirport'";

$stransfers = VDFormat($_POST['transfers'], true);
$sQuery = "INSERT INTO $sTable SET transfers = '$stransfers'";

$sstage = VDFormat($_POST['stage'], true);
$sQuery = "INSERT INTO $sTable SET stage = '$sstage'";

$sRef1 = VDFormat($_POST['Ref1'], true);
$sQuery = "INSERT INTO $sTable SET Ref1 = '$sRef1'";

$sRef2 = VDFormat($_POST['Ref2'], true);
$sQuery = "INSERT INTO $sTable SET Ref2 = '$sRef2'";

$sRef3 = VDFormat($_POST['Ref3'], true);
$sQuery = "INSERT INTO $sTable SET Ref3 = '$sRef3'";

$sRef4 = VDFormat($_POST['Ref4'], true);
$sQuery = "INSERT INTO $sTable SET Ref4 = '$sRef4'";

$sTotalTripCost = VDFormat($_POST['TotalTripCost'], true);
$sQuery = "INSERT INTO $sTable SET TotalTripCost = '$sTotalTripCost'";

$sCommission = VDFormat($_POST['Commission'], true);
$sQuery = "INSERT INTO $sTable SET Commission = '$sCommission'";

mysql_query($sQuery);
?>

It looks like you're using VDaemon, you should go there to get the help you need:

http://www.x-code.com/vdaemon_web_form_validation.php

(also check out there sample section)