How to send these few informations to the users e-mail?

Gmans

Hi
How can I send this few information below from the "MY ORDER" to the user that is logged in. I get all the right information below from the database on the USER PROFILE page, but I also want that the user can send these information to his email adress ($un) by one click.

Thanks

////USER PROFILE
db_connect ($cfg["db_server"], $cfg["db_user"], $cfg["db_pass"], $cfg["db_database"]);
$sql = "select * from users where user='$cur_user'";
$result = db_query ($sql);
echo "<table width=100% border=1 bordercolor=cdcdcd cellpadding=4>
<tr><Td bgcolor=cdcdcd>My Order";
while ($row=mysql_fetch_object($result)) {
$un = $row->username;$first=$row->first;$last=$row->last;$created=$row->created;$exp=date("m/d/Y h:i:sa",$row->expire);
echo "<tr><td>Order no.: $created";
echo "<tr><td>Order date: ";
echo strftime('%e',$created);
echo ".";
echo strftime('%m',$created);
echo ".";
echo strftime('%G',$created);
echo "<tr><td>Deliver date: ";
echo strftime('%e',$created);
echo ".";
echo strftime('%m',$created);
echo ".";
echo strftime('%G',$created);
echo "<tr><td>Payment status: Paid with creditcard";
echo "<tr><td>Item: 1 superbox";
echo "<tr><td>Total: $ 19.00 "; echo "<tr><td>CLICK HERE to send Order details to my e-mail";

}
mysql_close();
echo "</table>";
echo " ";

dalecosp

I'm sure that you might have a better chance at getting help if you clean up the code ... wrapping it in

 tags might help, for example.

dagon

ditto the above + everything you echo write to a var, use mail() and send that var in the body

Gmans

🙂
🙂

Gmans

Hi I have now made a nice html mail, thanks all of you 🙂
BUT im missing som values from another table in the database. How can I get them?

Now I get information from the USER table in the data base like here:
//User
if ($id) { db_connect ($cfg["db_server"], $cfg["db_user"], $cfg["db_pass"], $cfg["db_database"]);
$sql = "select * from users where user='$cur_user'";
$result = db_query ($sql);
while ($row=mysql_fetch_object($result))
{$un = $row->username;$first=$row->first;$last=$row->last);
echo "name: $first $last";

But I also need information from the CONTACT table in the database. Is it possible to get information from those 2 tables at the same time. I have found this from another page:
// Billing contact
db_connect ($cfg["db_server"], $cfg["db_user"], $cfg["db_pass"], $cfg["db_database"]);
$sql = "select * from businesses,contacts where businesses.business=contacts.business and businesses.user='$cur_user' and contacts.pri_contact='2'";
$result = db_query ($sql);
while ($row=mysql_fetch_object($result))
{$add1 = $row->address1;$add2=$row->address2;$city=$row->city);

dalecosp

Just get them.

For example:

<?php

$conn=mysql_connect("localhost","username","supersecretwords");
$sel=mysql_select_db("mybusiness");

if (!$conn && !$sel) {
   die("db failure");
}

$q1=mysql_query("select * from infotable");
$q2=mysql_query("select * from someotherdatatable");


$data1=mysql_fetch_array($q1);
$data2=mysql_fetch_array($q2);

print_r($data1);
print_r($data2);

?>

Gmans

hmmm can't get it to work. I think i'm to stupid for php. I have to find other solutions on the Internet if nobody can help me here, thanks