alexyz.com

$cp_output = “”;
if(!$get_cp_data = mysql_query(”
SELECT
q.*,
c.*,
vote_counts.Tally
FROM
questions q
LEFT JOIN
(SELECT
questionId,
count(1) as Tally
FROM
votes
GROUP BY
questionId
) vote_counts
ON
q.questionId = vote_counts.questionId
LEFT JOIN
customers c
ON
c.customerId = q.customerId
WHERE
q.courseId = 1
ORDER BY
vote_counts.Tally desc
“)){ echo mysql_error(); }

while($get_cp_data_array = mysql_fetch_array($get_cp_data)){
$q_id = $get_cp_data_array['questionId'];

$q_fname = $get_cp_data_array['customerFName'];
$q_lname = $get_cp_data_array['customerLName'];
$q_email = $get_cp_data_array['customerEmail'];

$q_topic = $get_cp_data_array['questionTopic'];
$q_question = $get_cp_data_array['question'];
$q_date = $get_cp_data_array['questionDate'];
//$q_count = $get_cp_data_array['votecount'];
$q_customer = $get_cp_data_array['customerId'];

if($q_topic == “”){ $q_topic = “–”; }
if($q_fname != “” || $q_lname != “”){
$from = ‘<strong>’ . $q_fname . ‘ ‘ . $q_lname . ‘</strong> – ‘;
}

# Parse the question text.
$old = array(“\n”);
$new   = array(“<br/>”);
$q_question = str_replace($old, $new, $q_question);

# Output the question.
$cp_output = $cp_output . ‘
<div>’ . $q_id . ‘</div>
<div>
<div><strong>’ . $q_topic . ‘</strong></div>
<div>’ . $q_question . ‘</div>
<div><strong>Submitted</strong> ‘ . $q_date . ‘ by ‘ . $from . ‘<a href=”mailto:’ . $q_email . ‘”>’ . $q_email . ‘</a></div>
</div>
<div></div>
‘;
}

Note the ‘s

$product_list = “’1869′, ’1929′, ’549′, ’189′, ’419′, ’176′, ’192′, ’310′, ’291′, ’514′, ’1643′, ’1033′“;

$db_name = “dbName”;
//conditional platform logic to support multiple connection scenarios

switch($_SERVER['HTTP_HOST'])
{
case ‘localhost’:
$db_host = “localhost”;
$db_username = “userName”;
$db_password = “Password”;
$dblink = mysql_connect ($db_host, $db_username, $db_password);
mysql_select_db($db_name, $dblink);
break;
case ‘www-staging.site.com’: break;
case ‘www.site.com’:
include(‘/var/www/includes/connection_script.php’);
break;
}

$result = mysql_query(”
SELECT
product_id,
product_name
FROM
tableNameHere
WHERE
product_id IN (“.$product_list.“)
“);
if (!$result) { echo “Could not successfully run query ($sql) from DB: “ . mysql_error(); exit; }

//let’s break out the resource so that it can be singularly requested when needed

while($one = mysql_fetch_assoc($result))
{
$prod_id = $one['product_id'];
$product_name[$prod_id] = $one['product_name'];
}
@mysql_close($dblink);

http://www.eltcalendar.com/stuff/datemysqlphp.html

thank you for this great handy reference!

pasted verbatim:

Important Note:

The choice in MySQL between date_format() and time_format() depends on the type of column you have stored your date in.

NB: the time type for MySQL columns actually represents an amount of time elapsed; thus, it can be negative or positive. However, it can also be used to represent the time of day, where it represents the amount of time elapsed since 1 second past midnight. If you forget to add :00 for seconds (for example, using 13:30 for 1:30 p.m.), your time value will be interpreted as the number of minutes and seconds after midnight, or 12:30 a.m. plus 30 seconds.

@mysql_close($dblink);

or the network persistence traffic cop might come calling…YOU

$query = “SELECT
o.FirstName, o.LastName, o.Addr1, o.Addr2, o.City,
s.Name AS State, s.Abbrv as StateAbbrv, o.ZipCode,
o.Phone1, o.EmailAddr, o.CCLastFour, o.CCExp, o.PromoCode
FROM orders o
INNER JOIN states s ON s.StateID = o.StateID
WHERE o.OrderID = ” . $this->_orderID;