load.php3

yuanma

<?
// Script by Rob Stanfield http://www.shockwavenz.co.nz


	$send_date = "datenow=";
	$send_date .= rawurlencode((date("j/m/Y")));

	echo "$send_date";

// connect to db

                      $db = mysql_connect("servername","username","password"); mysql_select_db("yourDB",$db);


	$get_count = "SELECT count(id) FROM guest";
	$count_result = mysql_query($get_count) or die ("Couldn't get count.");
	$count = mysql_result($count_result, 0, "count(id)");



	$get_date = "SELECT date FROM guest WHERE id = '$count'";
	$date_result = mysql_query($get_date) or die ("Couldn't get quote.");
	$return = mysql_result($date_result, 0, "date");
	$send_date2 = "&date=";
	$send_date2 .= rawurlencode($return );


	echo "$send_date2";


	$get_id = "SELECT id FROM guest WHERE id = '$count'";
	$id_result = mysql_query($get_id) or die ("Couldn't get quote.");
	$return= mysql_result($id_result, 0, "id");
	$send_id = "&No=";
	$send_id .= rawurlencode($return);


	echo "$send_id";
      

	$get_name = "SELECT name FROM guest WHERE id = '$count'";
	$name_result = mysql_query($get_name) or die ("Couldn't get quote.");
	$return = mysql_result($name_result, 0, "name");
	$send_name = "&name=";
	$send_name .= rawurlencode($return);


	echo "$send_name";

	$get_quote = "SELECT email FROM guest WHERE id = '$count'";
	$quote_result = mysql_query($get_quote) or die ("Couldn't get quote.");
	$return = mysql_result($quote_result, 0, "email");
	$send_email = "&email=";
	$send_email .= rawurlencode($return);


	echo "$send_email";

	$get_url = "SELECT url FROM guest WHERE id = '$count'";
	$url_result = mysql_query($get_url) or die ("Couldn't get quote.");
	$return = mysql_result($url_result, 0, "url");
	$send_url = "&url=";
	$send_url .= rawurlencode($return);


	echo "$send_url";

	$get_details = "SELECT details FROM guest WHERE id = '$count'";
	$details_result = mysql_query($get_details) or die ("Couldn't get quote.");
	$return = mysql_result($details_result, 0, "details");
	$send_details = "&details=";
	$send_details .= rawurlencode($return);


	echo "$send_details";

	$get_No_max = "SELECT id FROM guest WHERE id = '$count'";
	$No_max_result = mysql_query($get_No_max) or die ("Couldn't get quote.");
	$return = mysql_result($No_max_result, 0, "id");
	$send_No_max = "&Nomax=";
	$send_No_max  .= rawurlencode($return);


	echo "$send_No_max";
?>