Hi there,
I’m learning C++ from Cay Horstmann’s “Big C++”, and I stumbled upon the following code:

#include
#include

using namespace std;

int main()
{
cout <> first;
cin >> middle;
cin >> last;
string initials = first.substr(0,1) + middle.substr(0,1) + last.substr(0,1);
cout << "Your initials are " << initials << "n";

return 0;
}

If I begin middle name with one or more white-spaces, the output does not change. Is this because the .substr begins count only with the first non-whitespace character? For example, if we have the name John David Smith, and I enter,
John
David
Smith

the output is JDS regardless of whether I type David with or without space before it. This puzzles me. I know that space characters count between two or more words in a string (Hello, World!n consists of 14 characters total, since the space between the comma and the W is counted). But if I enter a string that begins with a white-space, and I ask .substr to begin count from character 0, does it disregard the space and jump to the first letter?
Any clarification would be greatly appreciated. Thank you!

After customer filling the form, the form data will be send to mysql, and an email will sent to me with the last form data that customer submitted. All is working, but only the problem is in the email “last mysql data” is not going as inline text. So, how to do this? I am doing in PHP. In am new in PHP. Please help me.

See full code – http://halmiratea.com/to-stackoverflow.com-not-personal1.php#problem

<?php

define('DB_NAME', 'sandi565_form11');
define('DB_USER', 'XXXXXXX');
define('DB_PASSWORD', 'XXXXXXX');
define('DB_HOST', 'localhost');

$link = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) {
die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) {
die('Can't use ' . DB_NAME . ': ' . mysql_error());
}

//Start Posting the data in Mysql database from Form Input

$value = $_POST['input1'];
$value2 = $_POST['MAmount'];

$sql = "INSERT INTO demo (input1, MAmount) VALUES ('$value', '$value2')";

if (!mysql_query($sql)) {
die('Error: ' . mysql_error());

}

//start print the database

$data = mysql_query("SELECT * FROM demo ORDER BY ID DESC LIMIT 1")
or die(mysql_error());
Print "”;
while($info = mysql_fetch_array( $data ))
{
Print “”;
Print “ID: “.$info['ID'] . ” “;
Print “Input1: “.$info['input1'] . ” “;
Print “MAmount: “.$info['MAmount'] . ” “;
}
Print “”;

mysql_close();

//end print the database on form processing page

//start emailing the data

date_default_timezone_set(‘Asia/Kolkata’);

require_once(‘class.phpmailer.php’);
//include(“class.smtp.php”); // optional, gets called from within class.phpmailer.php if not already loaded

$mail = new PHPMailer();

//$body = “gdssdh”;
//$body = preg_replace(“[]“,”,$body);

$mail->IsSMTP(); // telling the class to use SMTP
$mail->Host = “ssl://XXXXXXX.XXXXXXX.org”; // SMTP server
$mail->SMTPDebug = 1; // enables SMTP debug information (for testing)
// 1 = errors and messages
// 2 = messages only
$mail->SMTPAuth = true; // enable SMTP authentication
$mail->SMTPSecure = “ssl”; // sets the prefix to the servier
$mail->Host = “XXXXXXX.XXXXXXX.org”; // sets GMAIL as the SMTP server
$mail->Port = 465; // set the SMTP port for the GMAIL server
$mail->Username = “contact@XXXXXXX.com”; // GMAIL username
$mail->Password = “XXXXXXX”; // GMAIL password

$mail->SetFrom(‘contact@XXXXXXXX.com’, ‘HAL’);

//$mail->AddReplyTo(“user2@gmail.com’, ‘First Last”);

$mail->Subject = “Halmira 469″;

//THE PROBLEM IS HERE WHEN I WANT TO SEND THE DATA AS INLINE TEXT TO EMAIL FROM MYSQL IT IS NOT WORKING. ONLY “PRINT THE DATA” IS SENDING TO EMAIL.

$body = ‘Print the data’;
mysql_connect(“localhost”,”XXXXXXX”,”XXXXXXX”);
@mysql_select_db(“sandi565_form11″);
$query["SELECT * FROM demo ORDER BY ID DESC LIMIT 1"];
$result = mysql_query($query);

//while ($row = mysql_fetch_array ($result)) {
// $mail->AltBody = “To view the message, please use an HTML compatible email viewer!”; // optional, comment out and test
$mail->MsgHTML($body);
$address = “XXXXXXX@gmail.com”;
$mail->AddAddress($address, “user2″);

//$mail->AddAttachment(“images/phpmailer.gif”); // attachment
//$mail->AddAttachment(“images/phpmailer_mini.gif”); // attachment

if(!$mail->Send()) {
echo “Mailer Error: ” . $mail->ErrorInfo;
} else {
echo “Message sent!”;
}

?>

i’m trying to get the PK of the last record from a table. the catch is, the PK is not auto_incremented. it’s something like A1 where A is the user type (can be A, P, or S) and 1 is the part that is auto_incremented. in case you’re wondering why it’s like that, it was required of us to do it this way. i can’t use ORDER BY id DESC LIMIT 1 because it doesn’t return the PK of the last record. is there a way to do this?