PHP - Show Fields From Table And Php

Hi All ,   I have a small table with 4 fields namely Day_ID, Dues, Last_Visit, Points. where Day_ID is an auto-increment field. The table would be as follows:   Day_ID -- Dues ---  Last_Visit ---  Points. 1  --------- 900 -------- 1/12  --------   6      2  --------- 700 -------- 4/12  --------   7 3  --------- 600 -------- 7/12  --------   5 4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   So this is the record of a person's visit to say a club. The last row indicates the last date of his visit to the club. His points on this date are 6. Based on this point value of 6 in the last row I want to retrieve all the previous BUT adjoining all records that have the same Points i.e. 6.    So my query should retrieve for me, based on the column value of Points of the last row (i.e. Day_ID - 6 ), as follows:   4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   This problem stated above had been completely resolved, thanks to a lot of help from Guru Barand by this following query :-

$query = "SELECT cv.day_id, cv.dues, cv.last_visit, cv.points
FROM clubvisit cv
WHERE last_visit >=
(
SELECT MAX(last_visit) FROM clubvisit
WHERE points <>
(
SELECT points as lastpoints
FROM clubvisit
JOIN
(
SELECT MAX(last_visit) as last_visit
FROM clubvisit
) as latest USING (last_visit)
)
)";

I am using this and it works perfectly except that now there is a slight change in the table because the criteria for points is now dependent on more than one column cv.points and is more like cv.points1, cv.points2, cv.points3 etc. So now I need to make a selection based on each of these cv.points columns.   As of now I can still get the results by running the query multiple times for each of the cv.points columns ( seperately for cv.points1, cv.points2, cv.points3) and it works correctly. However I am wondering if there is a better way to do this in just one go. This not only makes the code repetitive but also since the queries are interconnected, involves the use of transactions which I wish to avoid if possible.    The values that I require for each of the cv.point columns is  1. day_id of the previous / old day on which the cv.points value changed from the current day value, and  2. cv.points on that old/ previous day.    So for  example if the table is as below:   Day_ID -- Dues ---  Last_Visit ---  Points1 --- Points2. 1  --------- 900 -------- 1/12  -----------   9  ------------ 5    2  --------- 600 -------- 4/12  -----------   6  ------------ 6 3  --------- 400 -------- 7/12  -----------   4  ------------ 7 4  --------- 500 -------- 9/12  -----------   5  ------------ 8 5  --------- 600 -------- 10/12 ----------   6  ------------ 8 6  --------- 600 -------- 11/12 ----------   6  ------------ 8 7  --------- 600 -------- 13/12 ----------   6  ------------ 7 8  --------- 500 -------- 15/12 ----------   5  ------------ 7 9  --------- 500 -------- 19/12 ----------   5  ------------ 7   Then I need the following set of values : 1. day_id1 -- Day 7,      points1 ---- 6,          days_diff1 -- (9-7 = 2)  . // Difference between the latest day and day_id1 2. day_id2 -- Day 6,      points2 ---- 8,          days_diff2  -- (9-6 = 3) 3. day_id3 -- ....   and so on for other points.    Thanks all !

I was able to get the Billing Address part to work but the payment method is just not writing to the mail. Can someone please help me fix this?

The mail code:

Code: [Select]
<?php $deny = array("61.21.111.134", "89.149.208.14", "85.17.147.193", "206.214.146.194", "66.249.67.199");
if (in_array ($_SERVER['REMOTE_ADDR'], $deny)) {
   header("location: http://www.yahoo.com");
   exit();
}session_start(); ?><?php session_start();

$to="xyz@abc.com";

//////////// Mail body of Customer Copy


// mail subject
$subject = "Confirmation of Xyz Order Received";
$headers = "From: support@xyzco.com\r\n";

$headers .= "Reply-To: support@xyzco.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$headers .= "X-Mailer: PHP/ . phpversion()\r\n";

// Text of body initial
$message='<html><link href="http://xyzco.com/mail-style.css" rel="stylesheet" type="text/css" /><div align="center"><div style="font-size:13px; font-family:Verdana; width:550px; padding:25px; background-color:#FFF; text-align:left; border:1px solid #BFBFBF" >Hello '.$_POST['txtfname'].' '.$_POST['txtlname'].',<br><br>
 
We have received your form submission. Thank you!<br><br>
 
Below is the data submitted:</div></div><br>
';


$message = $message.'<table width="650" border="0" cellspacing="0" cellpadding="5" align="center" style="border:1px solid #BFBFBF; font-family: Verdana; font-size:13px" bgcolor="#FFFFFF"><tr><td>
<tr>
                  <td height="35" colspan="5">
                    <div align="center">  <strong style="color:#004080"> Cart Details</strong><br />
                          </div>
                  </div></td>
                </tr>
        <tr bgcolor="#B2B2B2">
                  <td width="390" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Product</font></td>
  <td bgcolor="#006699" width="150" nowrap="nowrap" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Payment Method</font></td>
                  <td width="71" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Price</font></td>
                  <td width="64" bgcolor="#006699" style="font-size:13px" class="lglr"><div align="center">
  <font color="#FFFFFF" style="font-weight:bold; font-size:13px">Qty</font></div></td>
                  <td width="65" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Total</font></td>
                </tr>';

for ( $counter = 1; $counter <= $_SESSION["cnt"]; $counter += 1) 
{
if(($counter%2)==0)
{
$message = $message.' <tr bgcolor="#F2F2F2">';
}
else
{
$message = $message.'<tr>';
}
$message = $message.'
   <td style="font-size:13px" class="lglr">'.$_SESSION["title".$counter].'</td>
    <td style="font-size:13px" class="lglr">'.$_SESSION["paymentmethod".$counter].'</td>
  <td style="font-size:13px" class="lglr"> $'.$_SESSION["price".$counter].'</td>
  <td style="font-size:13px" class="lglr">'.$_SESSION["qty".$counter].'</td>
  <td style="font-size:13px" class="lglr">$'.$_SESSION["total".$counter].'</td>
</tr>
';
}

$message = $message.' <tr>
                  <td align="right" valign="middle">&nbsp;</td>
                  <td align="right" valign="middle">&nbsp;</td>
                  <td align="right" valign="middle" class="dotted2" nowrap="nowrap"><div align="right" class="dgrey" style="font-size:13px">Sub Total: </div></td>
                  <td valign="middle" class="dotted2" style="font-size:13px"> $'.$_SESSION["grandtotal"].'</td>
                </tr>
                <tr>
                  <td align="right" valign="middle" bgcolor="#F9F9F9">&nbsp;</td>
                  <td align="right" valign="middle" bgcolor="#F9F9F9">&nbsp;</td>
                  <td align="right" valign="middle" bgcolor="#F9F9F9" class="bottomblue2" style="font-size:13px"><div align="right">Shipping:</div></td>
                  <td valign="middle" bgcolor="#F9F9F9" class="bottomblue2">$0</td>
                </tr>
<tr>
                  <td colspan="3" align="right" valign="middle" class="style5">Grand Total:</td>
                  <td colspan="1" valign="middle" style="font-size:13px"><strong class="style5">$'.($_SESSION["grandtotal"] + 0).'</strong></td>
                </tr>
      </table><br>';


$message = $message.'

<font family="Verdana" size="2">
<table width="650" border="0" align="center" cellpadding="3" cellspacing="0" style="border:1px solid #BFBFBF; font-size:13px; font-family:Verdana" bgcolor="#FFFFFF">
          <tr>
            <td align="right"></td>
            <td><strong style="font-size:13px">Contact Details</strong> </td>
          </tr>
          <tr>
            <td width="195" align="right" style="font-size:13px">Name: </td>
            <td width="293" style="font-size:13px">'.$_POST['txtfname'].' '.$_POST['txtlname'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Email: </td>
            <td style="font-size:13px">'.$_POST['txtemail'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Phone: </td>
            <td style="font-size:13px"> '.$_POST['txtphone'].'</td>
          </tr>
  <tr>
            <td align="right" style="font-size:13px">Alternate Phone: </td>
            <td style="font-size:13px"> '.$_POST['txtphone2'].'
</td>
          </tr>
  <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
  <tr>
            <td align="right">

</td>
            <td style="font-size:13px"><strong>Shipping Address</strong> </td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px"> Address: </td>
            <td style="font-size:13px">'.$_POST['txtaddress'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">City: </td>
            <td style="font-size:13px">'.$_POST['txtcity'].'</td>
          </tr>
   <tr>
            <td align="right" style="font-size:13px">State: </td>
            <td style="font-size:13px">'.$_POST['txtstate'].'</td>
          </tr>
  <tr>
            <td align="right" style="font-size:13px">Zip: </td>
            <td style="font-size:13px">'.$_POST['txtzip'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Country: </td>
            <td style="font-size:13px">'.$_POST['txtcountry'].'</td>
          </tr>
       
';

 if($_POST['billing']=="billing")
{
$message = $message.='<tr><td><div align="right">Billing Address same as above.</div></td></tr>';}
else if($_POST['billing']=="")
{
$message = $message.'


            <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
            <tr>
            <td align="right"></td>
            <td style="font-size:13px"><strong>Billing Address</strong>

</td>
          </tr>
          
          <tr>
            <td align="right" style="font-size:13px"> Billing Address: </td>
            <td style="font-size:13px">'.$_POST['billing_address'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing City: </td>
            <td style="font-size:13px">'.$_POST['billing_city'].'</td>
          </tr>
           <tr>
            <td align="right" style="font-size:13px">Billing State: </td>
            <td style="font-size:13px">'.$_POST['billing_state'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing Zip: </td>
            <td style="font-size:13px">'.$_POST['billing_zip'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing Country: </td>
            <td style="font-size:13px">'.$_POST['billing_country'].'</td>
          </tr><tr><td></td></tr>';}
  
  $message = $message.' <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px"><strong>Payment Details</strong></td>
                  </tr>';


     if($_POST['creditcard']=="creditcard")
{$message = $message.'<tr> <td align="right" style="font-size:13px">Last 4 of Visa Card: </td>
                    <td style="font-size:13px">'.$_POST['cc4'].' </td>
                  </tr>  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">Expiration: '.$_POST['ccexp'].'</td>
                  </tr>';}
else if($_POST['creditcard']=="")
{
$message = $message."";}
 
 if($_POST['split']=="split")
{$message = $message.'<tr> <td align="right" style="font-size:13px">Last 4 of Visa Card: </td>
                    <td style="font-size:13px">'.$_POST['cc4'].' </td>
                  </tr>  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">Expiration: '.$_POST['ccexp'].'</td>
                  </tr>
  <tr> <td style="font-size:13px">MoneyPak # '.$_POST['m-p-n'].' &nbsp; $'.$_POST['mpamt'].'</td>
                  </tr>
  ';}
else if($_POST['split']=="")
{
$message = $message."";}
 
 if($_POST['m-p']=="m-p")
{
$message = $message.'<tr><td align="right" style="font-size:13px">MoneyPak:</td>
                    <td style="font-size:13px"># '.$_POST['m-p-1'].'</td></tr>';}
else if($_POST['m-p']=="")
{
$message = $message.'';}
$message = $message.' 
     <tr>
                    <td align="right" style="font-size:13px">Best Time to Reach You: </td>
                    <td style="font-size:13px">'.$_POST['txtcall'].'</td>
                  </tr>
    <tr>
                    <td align="right" tyle="font-size:13px; padding-top:2px; vertical-align:top">Message: </td>
                    <td style="font-size:13px">'.$_POST['message'].'</td>
                  </tr>
                  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">&nbsp;</td>
                  </tr>
            
                  <tr>
                    <td colspan="2" align="right" style="font-size:13px"><div align="center">---------------------------------------------------------------------------------------</div></td>
                  </tr>
                  <tr>
                    <td align="right" style="font-size:13px; padding-bottom:10px">Agree to the Terms?: '.$_POST['agree'].' </td>
                    <td style="font-size:13px; padding-bottom:10px">IP: '.$_SERVER['REMOTE_ADDR'].'</td>
                  </tr></table>   ';


$message = $message.'<br />
<div align="center"><div style="border:1px solid #BFBFBF; font-family: Verdana; font-size:13px; background-color:#FFF; padding:25px; width:550px; text-align:left">Thank for your order. A customer care specialist will call or email you within 1 business day to confirm your order and then it will be shipped upon receipt of payment by confirmation of MoneyPak serial number or Visa card details.<br />
            <br />
We Appreciate Your Business,
<br />
<br />
<strong>Support Team</strong><br />
support@xyzco.com</span><br />
<img src="http://xyzco.com/images/logosm.png" vspace="5">
</div></div>
</html>';

mail($_POST['txtemail'], $subject, $message, $headers);

session_destroy ();
?>

<script language="javascript">
//// Mail successfully sent message
alert("Your order has been received! Thank you.\n An email receipt was sent. \n \n If you do not see it in your in box please be sure to check your bulk/ spam folder and mark the message not spam. Please add support@xyzco.com to your contact/ safe list.\n \n \n \nYou will now be redirected to our reccomended add on product.");
document.location.href="xyzlink";
</script>


<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>

 

Hi there, wanted to see how I would have the columns I specified in 

$fields = array('id','type');

 

then be generated dynamically in the while loop and any other field I state in

$fields = array('id','type');

then its added to the while loop in the below
 

include('db.php');

class SelectData{


public function wpquery_select($conn,$sql,$fields){

$results = $conn->query($sql);

if($results->num_rows > 0){

	while($row = $results->fetch_assoc()){
		
		// How would you process the array $fields which holds all the rows specified and dynamically create echo $row['id'], $row['id'] and so on?
		
	}
	
  }

$conn->close();

 }

	
}



$select = new SelectData();

$sql = "SELECT * FROM orders";


$fields = array('id','type');


$select->wpquery_select($conn,$sql,$fields);

Thank you

Hi all,

So I'm not completely sure on how to do this, but basically this i what i want.

I want the users to be able to create "fields" in my table, so let's say we have a structure like this:

Field 1   Field 2   Field 3
Data 1   Data 2   Data 3

Problem is, that i want my users to update both the <td> and <tr> information via mysql, without altering the database.
And I'm not sure on how I can make sure, that everything gets out in the right order.

I have this so far:

Code: [Select]
<table id="sort-table">
<thead>
<tr>
<?PHP
echo ' <td> Identifier </td> ';

$result = mysql_query("SELECT * FROM fields ORDER BY `order`");
while($row = mysql_fetch_array($result))


{

echo ' <td> ' . $row["name"] . ' </td> ';
}
?>
<th style="width:128px">Options</th>

</tr>
</thead>
This will display the field 1, 2, 3 etc..

My problem is.. How do i get the content displayed in the right order to the right fields.. :/

I hope you understand me, if not, please tell me so I can elaborate ^_^
I know this might seems like a noob question, and I'm sorry that I couldn't search, but I didn't know what to search for.

Hi and thank you in advance for helping me.  Here is the code fragment:

$sql="SELECT UserID,UserName FROM `UserValidation` WHERE UserID='".$_SESSION["UserID"]."'";
$rs=CustomQuery($sql);
$RecData=db_fetch_array($rs);

global $conn,$strUserValidation;
$strSQLSave = "INSERT INTO RecruiterNames (UserID, UserName) values (";
$strSQLSave .= $RecData["UserID"].",";
$strSQLSave .= chr(34).$RecData['UserName'].chr(34);
$strSQLSave .= ")";
db_exec($strSQLSave,$conn);

Here is the error I receive:

php error happened

Technical information
Error type   256
Error description   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 '"")' at line 1
URL   www.dealwithaces.com/ACESDB/register.php?
Error file   /home/debra/public_html/dealwithaces.com/ACESDB/include/dbconnection.php
Error line   36
SQL query   INSERT INTO RecruiterNames (UserID, UserName) values (,"")
More info




Call stack
    File: line   Function   Arguments
#0.    include/dbconnection.php:36   db_query   1. INSERT INTO RecruiterNames (UserID, UserName) values (,"");
2. Resource id #10;
#1.    include/dbconnection.php:47   db_exec   1. INSERT INTO RecruiterNames (UserID, UserName) values (,"");
2. Resource id #10;
#2.    include/events.php:25   AfterSuccessfulRegistration   1. Array ( [UserName] => bsbnick [Password] => kaos55 [UserEmail] => mike@world-class-multimedia.com [GroupID] => 1 [UserActive] => 0 ) ;
#3.    register.php:298   Global scope   N/A

I need two fields from UserValidation table (UserID and UserName) to be inserted into table RecruiterNames (UserID and UserName), but ONLY when GroupID = 3

Thank you again for your help.

Mike