<?php
        
        $data = mysql_query ("SELECT * FROM ***** WHERE ref='001'");
        while($info = mysql_fetch_array($data)) {  
        
    // data
        $url='/random/0345gdfg/filters/'.$info['url'];
        $addstats='/random/0345gdfg/filters/'.$info['urla'];
        
?>

        <table border="1" cellpadding="5" cellspacing="0" width="50%" align="center">
        
        <tr>
        <td width='60%' bgcolor='silver'><a href="<?php echo $url;?>"><?php echo $info['filter']; ?></a></td>
        <td width='40%'><?php include($addstats);?></td>
        </tr></table>

<?php
}  
?>

<?php include($_SERVER['DOCUMENT_ROOT'].'/random/0345gdfg/*****.php');?>

<table border="0" cellpadding="2" cellspacing="0" width="100%">            
                    
        <td width="25%"><?php
            $query = "SELECT SUM(profit) FROM *****";
        
            $result = mysql_query($query) or die(mysql_error());

        // Print out result
            while($row = mysql_fetch_array($result)){
            echo $row['SUM(profit)'];
        echo "<br />";
    }
    ?></td>
    
    
        <td width="25%"><?php
        $query = "SELECT COUNT(horse) FROM ***** WHERE pos ='1'";
    
        $result = mysql_query($query) or die(mysql_error());

    // Print out result
        while($row = mysql_fetch_array($result)){
        echo $row['COUNT(horse)'];
        echo $row['type'];
        echo "<br />";
        }
        ?></td>
        
        
        <td width="25%"><?php
        $query = "SELECT COUNT(horse) FROM *****";
    
        $result = mysql_query($query) or die(mysql_error());

    // Print out result
        while($row = mysql_fetch_array($result)){
        echo "Number of qualifers:". $row['COUNT(horse)'] ." ". $row['type'] ."";
        echo "<br />";
}
?></td>
    </tr>
</table>

SELECT firstName, lastName FROM users WHERE firstName = '$refFirstName' && lastName = '$refLastName';

ALTER PROCEDURE [dbo].[GetActivePeriod]
AS

SELECT  w.WorkKeeper, SUM (DATEDIFF (ss, a.ProcessDate, MIN(b.ProcessDate) ) ) AS 'ActivePeriod'

FROM Work w, ProcessLog a INNER JOIN ProcessLog b ON (b.ProcessId > a.ProcessId AND b.WorkId=a.WorkId)

WHERE CONVERT( varchar(10), a.ProcessDate, 111) = CONVERT( varchar(10), GETDATE(), 111)
AND CONVERT( varchar(10), b.ProcessDate, 111) = CONVERT( varchar(10), GETDATE(), 111)
AND a.ProcessNum=1
AND ( b.ProcessNum=2 OR b.ProcessNum=4 OR b.ProcessNum=5 OR b.ProcessNum=6 )
AND w.WorkId=a.WorkId

GROUP BY w.WorkKeeper

$query = "SELECT finish_id, finish, img FROM finishes WHERE range_id = $prange";
$result = mysqli_query ($dbc, query);

if (mysqli_num_rows($finish_result) > 0)
{
echo "<select name=\"fn\" id=\"fn\">";
echo "<option value=\"0\">Select finish</option>";
while ($row = mysqli_fetch_array ($finish_result, MYSQLI_ASSOC))
{
$finish_id = $row['finish_id'];
$finish = $row['finish'];
echo "<option value=\"" . $finish_id . "\"";
echo ">" . $finish . "</option>";
}
echo "</select> ";
while ($row = mysqli_fetch_array ($finish_result, MYSQLI_ASSOC))
{
$finish_id = $row['finish_id'];
$finish = $row['finish'];
$img = $row['img'];
$finishImgPath = "assets/finishes/preview/";
$size = getimagesize("assets/finishes/preview/{$img}");
echo "<img src=\"" . $mainPath . $finishImgPath . $img . "\" " . $size[3] . " alt=\"" . $finish . "\" title=\"" . $finish . "\" /></a>";
}
}

USE [SQL_reporting]
GO
/****** Object: StoredProcedure [dbo].[pp_Material_Request_CANCELED_byUser] Script Date: 10/27/2009 12:32:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ==================================================
-- Author: <me>
-- Modified: <me>
-- Create date: <7/30/2008>
-- Description: [pp_Material_Request_CANCELED_byUser]
-- ==================================================

ALTER PROCEDURE [dbo].[pp_Material_Request_CANCELED_byUser]
(
@facility varchar(10), @USER_VAL varchar(5000)
)

AS

SET NOCOUNT ON
SET ANSI_NULLS ON

DECLARE @connection_string As varchar(50)
SET @connection_string = dbo.linked_server(@facility)
--use the @connection_string variable in your calls for
--openquery('+@connection_string+',
SET @facility = dbo.change_BRE_to_BR(@facility)

-- end lines


SET @USER_VAL = dbo.format_string(@USER_VAL)


DECLARE @SQL VARCHAR(8000)
SET @SQL = '
SELECT tidmrmst.material_request, tidmrmst.matl_request_type,
tidmrmst.mr_status, tidmrmst.need_date_matl, tidmrmst.status_date,
tidmrmst.resp_id, tidmrmst.job_type, tidmrmst.reference_type,
tidmrmst.reference_nbr, tidmrmst.reference_sub_nbr, tidmrmst.title,
lower(ltrim(rtrim(tidprefs.preference_value))) ||''@''||
lower(ltrim(rtrim(tidprefs1.preference_value))) As email,
rtrim(tidemplo.first_name) || '' '' || ltrim(tidemplo.last_name) As name

FROM cb10.tidmrmst, cb10.tidprefs, cb10.tidprefs tidprefs1, tidemplo
WHERE (
(tidmrmst.resp_id IN ('+@USER_VAL+'))
AND (tidmrmst.facility = '''+@facility+''')
AND ((tidmrmst.mr_status = ''CANCELED''))
AND ((tidmrmst.resp_id = tidemplo.passport))
AND ((tidmrmst.resp_id = tidprefs.pref_qual_value (+)))
AND ((tidmrmst.resp_id = tidprefs1.pref_qual_value (+)))
AND ((tidprefs.preference_name = ''EMAIL USER ID''))
AND ((tidprefs1.preference_name = ''EMAIL USER NETADDR''))
)
ORDER BY tidmrmst.resp_id'

SET @SQL = 'select * from openquery('+@connection_string+',''' + REPLACE(@SQL,'''','''''') + ''')'
EXEC (@SQL)

SET NOCOUNT OFF

SELECT product_id, product, img1 FROM products WHERE product_id IN (SELECT product_id FROM productCat WHERE category_id = 9) ORDER BY (SELECT usort FROM productCat)

<?php
    // Make a MySQL Connection
        mysql_connect("*****", "*****", "*****") or die(mysql_error());
        mysql_select_db("******") or die(mysql_error());
?>

    <table border="1" cellpadding="2" cellspacing="0" width="100%">

        <tr>
        
        <td width="25%">No Filter</td>
                    
                    
            <td width="25%"><?php
            $query = "SELECT SUM(profit) FROM *****";
        
            $result = mysql_query($query) or die(mysql_error());

        // Print out result
            while($row = mysql_fetch_array($result)){
            echo $row['SUM(profit)'];
        echo "<br />";
    }
    ?></td>
    
    
        <td width="25%"><?php
        $query = "SELECT COUNT(horse) FROM ***** WHERE pos ='1'";
    
        $result = mysql_query($query) or die(mysql_error());

    // Print out result
        while($row = mysql_fetch_array($result)){
        echo "Number of winners:". $row['COUNT(horse)'] ." ". $row['type'] ."";
        echo "<br />";
        }
        ?></td>
        
        
        <td width="25%"><?php
        $query = "SELECT COUNT(horse) FROM *****";
    
        $result = mysql_query($query) or die(mysql_error());

    // Print out result
        while($row = mysql_fetch_array($result)){
        echo "Number of qualifers:". $row['COUNT(horse)'] ." ". $row['type'] ."";
        echo "<br />";
}
?></td>
    </tr>
</table>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <title>Edit Profile</title>
    <link href="CSS/profile.css" rel="stylesheet" type="text/css">
    <meta http-equiv="content-type" content="text/html;charset=utf-8">
    <meta http-equiv="Content-Style-Type" content="text/css">
</head>
<body>
<div class="centered_div">
<div class="header">
My Will Made Easy - Attorney Profile Editor
</div>
<div class="profile_text">
<?php
$con = mysql_connect("localhost","###","###");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("bigsilkd_attorneys", $con);

if (!empty($_POST['users']))
{
  $result = mysql_query('SELECT * FROM attorneys WHERE users=\'' . mysql_real_escape_string($_POST['users']) . '\'') or exit(mysql_error());
  if ($row = mysql_fetch_assoc($result))
  {
    ?>
User Name: <input type="text" size="20" name="users" value="<?php echo $row['users']; ?>">
Password: <input type="text" size="10" name="password" value="<?php echo $row['password']; ?>"> <br />
Law Firm Name: <input type="text" size="60" name="LawFirmName" value="<?php echo $row['LawFirmName']; ?>"> <br />
Main Office Address: <input type="text" size="60" name="MainOfficeAddress" value="<?php echo $row['MainOfficeAddress']; ?>"> <br />
City: <input type="text" name="MainOfficeCity" value="<?php echo $row['MainOfficeCity']; ?>">
ST: <input type="text" size="3" name="MainOfficeState" value="<?php echo $row['MainOfficeState']; ?>">
Zip: <input type="text" size="10" name="MainOfficeZip" value="<?php echo $row['MainOfficeZip']; ?>"> <br />
Main Phone: <input type="text" name="MainOfficePhone" value="<?php echo $row['MainOfficePhone']; ?>"> <br />
Main Email Address: <input type="text" name="MainOfficeEmail" value="<?php echo $row['MainOfficeEmail']; ?>"> <br />
Website Address: <input type="text" size="60" name="WebAddress" value="<?php echo $row['WebAddress']; ?>"> <br />
Firm Overview: <textarea name='Overview' rows='5' cols='40'value="<?php echo $row['Overview']; ?>"></textarea><br />
Years of Experience: <input type="text" name="YearsofExperience" value="<?php echo $row['YearsofExperience']; ?>"> <br />
Languages Spoken: <textarea name='Languages' rows='5' cols='40'value="<?php echo $row['Languages']; ?>"></textarea><br />
Geographical Areas Serving: <textarea name='GeographiesServing' rows='5' cols='40'value="<?php echo $row['GeographiesServing']; ?>"></textarea><br />
Areas of Legal Practice: <textarea name='PracticeAreas' rows='5' cols='40'value="<?php echo $row['PracticeAreas']; ?>"></textarea><br />
Primary Attorney's Name: <input type="text" name="MainAttorneyName" value="<?php echo $row['MainAttorneyName']; ?>"> <br />
Primary Attorney's Phone Number: <input type="text" name="MainAttorneyPhone" value="<?php echo $row['MainAttorneyPhone']; ?>"> <br />
Primary Attorney's Email Address: <input type="text" name="MainAttorneyEmail" value="<?php echo $row['MainAttorneyEmail']; ?>"> <br />
    <?php
  }
  else
  {
    echo 'Username not found.';
    ?>
<div class="profile_text">
<form action="retrieve2.php" method="post">
  User name: <input type="text" size="90" name="users" value="<?php echo $_POST['users']; ?>">
</form>
    <?php
  }
}
else
{
  echo 'You must enter a user';
}
?>
</div>
</div>
</body>
</html>

<?php
$con = mysql_connect("localhost","###","###");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("bigsilkd_attorneys", $con);

$sql="INSERT INTO attorneys (LawFirmName, MainOfficeAddress, MainOfficeCity, MainOfficeState, MainOfficeZip, MainOfficePhone, MainOfficeEmail, WebAddress, Overview, YearsofExperience, Languages, GeographiesServing, PracticeAreas, MainAttorneyName, MainAttorneyPhone, MainAttorneyEmail)
VALUES
('$_POST[LawFirmName]','$_POST[MainOfficeAddress]','$_POST[MainOfficeCity]','$_POST[MainOfficeState]','$_POST[MainOfficeZip]','$_POST[MainOfficePhone]','$_POST[MainOfficeEmail]','$_POST[WebAddress]','$_POST[Overview]','$_POST[YearsofExperience]','$_POST[Languages]','$_POST[GeographiesServing]','$_POST[PracticeAreas]','$_POST[MainAttorneyName]','$_POST[MainAttorneyPhone]','$_POST[MainAttorneyEmail]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

// already connected to sql host and database

$query = mysql_query("SELECT * FROM menu where power = 1 ORDER BY order");
while($row =  mysql_fetch_array($query))
{
echo "<a href='{$row['link']}'>{$row['name']}</a><br>/n";
$query2 = mysql_query("SELECT * FROM menu where under = {$row['id']} ORDER BY order");
$query3 = mysql_num_rows($query2);
if($query3 >= 1)
{
while($row2 = mysql_fetch_array($query2))
  {
  echo "-> <a href='{$row2['link']}'>{$row2['name']}</a>";
  }
}
}

select '', Invoices.DoctorNo, rtrim(Doctor.Name) as Doctor_Name, '', '',
       '', '', '',
       '', '',
       '', '', '',
       '', '', '', '',
       Sum(Invoices_Products.ProdAmount), sum(Invoices_Products.ProdQty)
  from ((((Doctor   left join Invoices on Invoices.Lab = Doctor.Lab
                                               and Invoices.DoctorNo = Doctor.Doctor)
                   inner join Invoices_Products on Invoices_Products.Lab = Invoices.Lab
                                               and Invoices_Products.CaseNo = Invoices.CaseNo
                                               and Invoices_Products.Invoice = Invoices.Invoice)
                   inner join Products          on Products.Lab = Invoices_Products.Lab
                                               and Products.Product = Invoices_Products.Product)
                   inner join Category          on Category.Lab = Products.Lab
                                               and Category.Category = Products.Category)
  where Doctor.Lab = 1 and ( Doctor.SalesSource = '26' or ( Doctor.SalesSource = '27' and Invoices.Shipped < '2008-03-31' ) ) and Invoices.Shipped > '2008-12-31'
    and    ( Category.Category = 'DA' or Category.Category = 'HA' or Category.Category = 'GA' or Category.Category = 'WA' )
  group by Invoices.DoctorNo, Doctor.Name

//do select query to verify item id
$check_sql = "SELECT * FROM aromaProducts1 WHERE id='".intval($_GET["productid"])."'";
$check_res = mysqli_query($mysqli, $check_sql) or  error_log(mysqli_error($mysqli)."\r\n");

  //do select query to check for item id already in basket
  $duplicate_sql = "SELECT qty FROM sessionBasket WHERE product_id='".intval($_GET["productid"])."' AND usersessid='".session_id()."'";
  $duplicate_res = mysqli_query($mysqli, $duplicate_sql) or  error_log(mysqli_error($mysqli)."\r\n");

    //item in basket - add another
    $add_sql = "UPDATE sessionBasket SET qty=qty+".intval($_GET["qty"])."  WHERE usersessid='".session_id()."'AND product_id='".intval($_GET["productid"])."'";
    $add_res = mysqli_query($mysqli, $add_sql) or  error_log(mysqli_error($mysqli)."\r\n");

  //insert query
  $insert_sql = "INSERT INTO ".$table." (userid, usersessid, date_added, product_id, qty, notes) VALUES (
  '".$userid."',
  '".session_id()."',
  now(),
  '".htmlspecialchars($productid)."',
  '".intval($_GET["qty"])."',
  '".htmlspecialchars($notes)."')";
  $insert_res = mysqli_query($mysqli, $insert_sql) or  error_log(mysqli_error($mysqli)."\r\n");

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID('MasteryNet')
AND OBJECT_ID=OBJECT_ID('LAST_RECORDS'

edit_band     edit_user     edit_time     edit_block     edit_reason
1              2          1248635164     2              Prova Motivo
1              2          1248635285     2              Prova Motivo 2
2              3          1250939034     1              Prova Motivo 3
1              2          1250978390     4
1              2          1250984273     4
1              2          1250984277     4
1              2          1250984314     4
1              2          1250984317     4
1              2          1250984351     4
1              2          1250984361     4
1              2          1250984533     4

SELECT band.band_id, band.band_name, edit.*, user.username, COUNT(edit.edit_band) AS total
FROM ip_bands AS band
RIGHT JOIN ip_bands_edits AS edit ON edit.edit_band = band.band_id
LEFT JOIN ip_users AS user ON edit.edit_user = user.user_id
GROUP BY edit.edit_band
ORDER BY edit.edit_time DESC LIMIT 0, 10

CREATE TABLE EVENT (
   EventID INT UNSIGNED NOT NULL AUTO_INCREMENT,
   DateFrom DATE NOT NULL,
   DateTo DATE NOT NULL,
   EventTitle VARCHAR(50) NOT NULL,
   Event TEXT NOT NULL,
   Created TIMESTAMP DEFAULT '0000-00-00 00:00:00',
   Updated TIMESTAMP DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY(EventID)
);

CREATE TRIGGER EVENT_TIME_CREATED
   BEFORE INSERT ON EVENT
   FOR EACH ROW SET NEW.Created = NOW(),
   NEW.Updated = '0000-00-00 00:00:00';

CREATE TRIGGER EVENT_TIME_UPDATED
   BEFORE UPDATE ON EVENT
   FOR EACH ROW SET NEW.Updated = NOW(),
   NEW.Created = OLD.Created;

CUSTOMERS
+--------+---------+
|   cid  |   cname |    
+--------+---------+
|   c001  | TipTop |
|   c002  | Basics |
|   c003  | Allied |      
|   c004  | ACME   |      
|   c006  | ACME   |        
+--------+---------+


ORDERS
+-------+------+-----+-----+
|ordnum | cid  | aid | pid |
+-------+------+-----+-----|
|   1011| c001 | a01 | p01 |
|   1012| c001 | a01 | p01 |
|   1019| c001 | a02 | p02 |
|   1017| c001 | a06 | p03 |
|   1021| c004 | a06 | p01 |
|   1016| c006 | a01 | p01 |
|   1024| c006 | a06 | p01 |
+-------+------+-----+-----+

SQL> SELECT customers.cid  
FROM customers
JOIN orders
ON customers.cid = orders.cid
WHERE  pid='p01' AND pid='p02';

SELECT *
FROM Cities
ORDER BY Country, Population DESC;

Dim cmdText As String = "Select a.ItemId,i.Description,Sum(QuantityPurchased) AS QuantityPurchased,Sum(QuantitySold) AS QuantitySold, " & _
        "(Sum(QuantityPurchased) - Sum(QuantitySold)) as Balance  " & _
        "From " & _
        "( SELECT pt.PDate as TransactionDate, pt.ItemId, pt.Quantity AS QuantityPurchased, " & _
        "0 AS QuantitySold FROM PurchaseTable pt " & _
        "UNION ALL " & _
        "Select st.SDate as TransactionDate, st.ItemId, 0 AS QuantityPurchased, " & _
        "st.Quantity AS QuantitySold " & _
        "From SalesTable st ) a " & _
        "Join ItemsTable i On a.ItemId = i.ItemId  " & _
        "WHERE a.TransactionDate Between @START and @END " & _
        "GROUP BY a.ItemId, i.Description "

$q2 = '(SELECT ageing_id, ageing_name, 1 AS selected FROM ageing as a, productAge AS p WHERE p.product_id=' . $id . ' AND p.age_id=a.ageing_id)';
$q2 .= ' UNION ';
$q2 .= '(SELECT ageing_id, ageing_name, 0 AS selected FROM ageing)';
$q2 .= ' ORDER BY ageing_id';

$poruke_re = mysql_query("SELECT ID_MSG FROM $table_messages WHERE ID_TOPIC='$boardch_subject_id' GROUP BY ID_MSG");
while($pod_teme = mysql_fetch_array($poruke_re)) {
    echo "<br>" . $pod_teme['ID_MSG'];
}

20
22
23
24

20
22
23
24


20
22
23
24


20
22
23
24


20
22
23
24

$gmenu=mysql_query("SELECT * FROM products GROUP BY cat ORDER BY cat");
while($smenu=mysql_fetch_array($gmenu))
{
    echo'<div style="background-color:#999999;border:#000000 thin solid;width:100%;">'.stripslashes($smenu["cat"]).'</div>
    
    <div style="background-color:#CCCCCC;width:100%;border:#000000 thin solid;" id="'.$smenu["Name"].'">';
    $g=mysql_query("SELECT * FROM products WHERE cat='{$smenu['cat']}' GROUP BY size ORDER BY size");
    while($s=mysql_fetch_array($g))
    {
        echo'-<a style="width:100px;color:#666666;" href="Products.php?cat='.$s["cat"].'&Size='.$s["size"].'">'.$s["size"].'</a><br />';
    }
    echo'</div>';

}
}

SELECT tidapmst.created_by, tidapmst.create_date, tidapmst.invoice_no,
tidapmst.invoice_date, tidapmst.vendor_code, tidapmst.facility
FROM cb10.tidapmst
WHERE ((tidapmst.invoice_date BETWEEN '20090701' AND '20090731'))
AND ((tidapmst.facility = 'BIG'))
AND ((tidapmst.created_by <> 'APBAK'))
AND ((tidapmst.created_by <> 'ADASCO'))
ORDER BY tidapmst.created_by ASC AND tidapmst.created_date ASC

<?php
session_start();
include_once("db_include.php5");
doDB();

//check for required fields from the form
if ((empty($_POST['username']) && empty($_POST['email'])) || empty($_POST['password'])) {
        $_SESSION["username"] = trim(mysqli_real_escape_string($mysqli, check_chars_username($_POST["username"])));
      $_SESSION["email"] = trim(mysqli_real_escape_string(check_chars_username($_POST["email"])));

header("Location: loginform.php5?error=ef");
exit;
}   else if($_POST["username"] && $_POST["password"]){

    //create and issue the query
    $sql = "SELECT id, username, email FROM aromaMaster WHERE username='".$_POST["username"]."' AND password=PASSWORD('".$_POST["password"]."')";
    $sql_res =mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

    //get the number of rows in the result set; should be 1 if a match
    if(mysqli_num_rows($sql_res) != 0) {
      //if authorized, get the userid
      while($info = mysqli_fetch_array($sql_res)) {
        $userid = $info["id"];
        $username = stripslashes($info["username"]);
        $email = stripslashes($info["email"]);
      }
      //set session variables
      $_SESSION["userid"] = $userid;
      $_SESSION["username"] = $username;
      $_SESSION["email"] = $email;
      session_write_close();

      //select all rows in sessionBasket with the current session id
      $select_sql = "SELECT product_id, qty, notes FROM sessionBasket WHERE usersessid = '".session_id()."'";
      $select_res = mysqli_query($mysqli, $select_sql) or die(mysqli_error($mysqli));

      $newInfo = mysqli_fetch_array($select_res);
      $newQty = $newInfo["qty"];

      //if no rows, then do nothing
      if(mysqli_num_rows($select_res) == 0) {
        header("Location: your_basket.php5?res=loggedin_noitems");
        exit();
      } else if(mysqli_num_rows($select_res) > 0) {
      //else, for each item, check if there is an existing item of that kind in the basket

      while($row = mysqli_fetch_array($select_res)) {



        //check for pre-existing basket items for this account
        $old_items_sql = "SELECT qty FROM userBasket WHERE userid = '".$userid."' AND product_id = '".$product_id."'";
        $old_items_res = mysqli_query($mysqli, $old_items_sql) or die(mysqli_error($mysqli));
        
        if(mysqli_num_rows($old_items_res) > 0) {
          //pre-existing items - update qty
          $oldInfo = mysqli_fetch_array($old_items_res);
          $oldQty =  $oldInfo["qty"];
          
          $update_sql = "UPDATE userBasket SET qty=".intval($oldQty+$newQty)." WHERE product_id = '".$product_id."' AND usersessid = '".session_id();"'";
          $update_res = mysqli_query($update_sql) or die(mysqli_error($mysqli));
          
          if(mysqli_num_rows($update_res) == 0) {
            //failed
            header("Location:your_basket.php5?failed=update5060");
            exit();
          } else if(mysqli_num_rows($update_res) > 0) {
            //success
            header("Location:your_basket.php?success=update5060");
            exit();
          }
         } else if(mysqli_num_rows($old_items_res) == 0) {

          //no preexisting items - insert the current ones
          $insert_new_sql = "INSERT INTO userBasket (userid, usersessid, date_added, product_id, qty, notes) VALUES (
          '".$userid."',
          '".session_id()."',
          now(),
          '".$product_id."',
          '".$qty."',
          '".$notes."')";
          $insert_res = mysqli_query($mysqli, $insert_new_sql) or die(mysqli_error($mysqli));
         }}

      mysqli_free_result($sql_res);
      //redirect to main page
      header("Location: loginredirect.php5");
      exit; }




    } else if($_POST["email"] && $_POST["password"]) {

          //create and issue the query
    $sql = "SELECT id, username FROM aromaMaster WHERE email='".$_POST["email"]."' AND password=PASSWORD('".$_POST["password"]."')";
    $sql_res =mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

    //get the number of rows in the result set; should be 1 if a match
    if(mysqli_num_rows($sql_res) != 0) {

      //if authorized, get the userid
      while($info = mysqli_fetch_array($sql_res)) {
        $userid = $info["id"];
        $username = stripslashes($info["username"]);
        $email = stripslashes($info["email"]);
      }
      //set session variables
      $_SESSION["userid"] = $userid;
      $_SESSION["username"] = $username;
      $_SESSION["email"] = $email;
      session_write_close();

      mysqli_free_result($sql_res);
      $userupdate_sql = "UPDATE sessionBasket SET userid = '".$userid."' WHERE usersessid='".session_id()."'";
              $userupdate_res = mysqli_query($mysqli, $userupdate_sql) or die(mysqli_error($mysqli));

      //redirect to main page
      header("Location: loginredirect.php5");
      exit;
      } else {
      //redirect back to login form
      $_SESSION["username"] = trim(stripslashes(check_chars_username($_POST["username"])));
      $_SESSION["email"] = trim(stripslashes(check_chars_username($_POST["email"])));
      session_write_close();
      header("Location: loginform.php5?error=ef");
      exit;
    }  }
?>

SELECT SET1, SET2, SET3 FROM table1 WHERE NAME LIKE '%$terms%' UNION ALL

SELECT ageing_id, ageing_name FROM ageing WHERE ageing_id IN (SELECT age_id FROM productAge WHERE product_id = 30)

if (mysqli_num_rows($ageing_result) > 0)
{
echo "<select name=\"ageing\" id=\"ageing\">\n";
echo "<option value=\"0\">Please select...</option>";
while ($row = mysqli_fetch_array ($ageing_result, MYSQLI_ASSOC))
{
echo "<option value=\"{$row['ageing_id']}\"";

echo ">{$row['ageing_name']}</option>\n";
}
echo "</select>";

<?PHP
session_start();
$con = mysql_connect("my host","my username","my password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my database", $con);

if (isset ($_POST[Submit]))
{
$title = htmlspecialchars(strip_tags($_POST['title']));
$thumb = htmlspecialchars(strip_tags($_POST['thumb']));
$screen = htmlspecialchars(strip_tags($_POST['screen']));
$screent = htmlspecialchars(strip_tags($_POST['screent']));
$version = htmlspecialchars(strip_tags($_POST['version']));
$size = htmlspecialchars(strip_tags($_POST['size']));
$comp = htmlspecialchars(strip_tags($_POST['comp']));
$link = htmlspecialchars(strip_tags($_POST['link']));
$desc = $_POST['desc'];

$desc = nl2br($desc);

if (!get_magic_quotes_gpc()) {
$title = addslashes($title);
$thumb = addslashes($thumb);
$screen = addslashes($screen);
$screent = addslashes($screent);
$version = addslashes($version);
$size = addslashes($size);
$comp = addslashes($comp);
$link = addslashes($link);
$desc = addslashes($desc);
}

$sql="INSERT INTO Games (title, date, thumb, screen, screent, desc, version, size, comp, link)
VALUES ('$title',now(),'$thumb','$screen','$screent','$desc','$version','$size','$comp','$link')";

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

}

if (!isset($_SESSION['user'])){echo "You must log in. </div></div>"; include('footer.php'); echo "</body></html>"; exit;}
echo "Hello, NT. You are logged in. You are adding a game.<br /> <br />

<form name='gamesubmit' id='gamesubmit' method='post' action=''>
<table>
<tr>
<td class='td' valign='top'>
<input type='text' name='title' class='forminput' maxlength='25' /> Title<br /><br />
<input type='text' name='thumb' class='forminput' maxlength='50' /> Thumbnail<br /> <br />
<input type='text' name='screen' class='forminput' maxlength='100' /> Screenshot<br /> <br />
<input type='text' name='screent' class='forminput' maxlength='100' /> Screenshot 2<br /> <br />
<input type='text' name='version' class='forminput' maxlength='100' /> Version<br /> <br />
<input type='text' name='size' class='forminput' maxlength='100' /> Size<br /> <br />
<input type='text' name='comp' class='forminput' maxlength='100' /> Compatible<br /> <br />
<input type='text' name='link' class='forminput' maxlength='100' /> File Link<br /> <br />
<textarea rows='7' cols='30' name='desc' class='forminput'></textarea><br /> <br />
</td>
</tr>
</table>
<input type='submit' value='Submit' name='Submit' id='Submit' class='sub_button' /></form>";

mysql_close($con);
?>

SELECT jumbo.jumbo_id, jumbo.machine_id, jumbo.grade_spec, jumbo.ts_turned_up,
jumbo_audit.jumbo_id AS jumbo_audit_jumbo_id, jumbo_audit.mx_timestamp, jumbo_audit.mx_action_code, jumbo_audit.wgt_slabbed

FROM jumbo INNER JOIN jumbo_audit ON jumbo.jumbo_id = jumbo_audit.jumbo_id

WHERE (((jumbo.machine_id)='14') AND ((jumbo.ts_turned_up)>=1246791600 And (jumbo.ts_turned_up)<=1246877999));

SELECT *
FROM
(SELECT z.zone_id AS Zones,z.zone_name AS ZoneName,count(c.circle_id) AS Circles,count(c.trans_id) AS Transfer,sum(c.housescovered) AS HousesCover,sum(c.housesnotcovered) AS HousesnotCover
                FROM zone_mas z
        INNER JOIN circle_mas c
         ON z.zone_id=c.zone_id
         GROUP BY z.zone_id,z.zone_name) a
INNER JOIN
(
SELECT z.zone_id, count(distinct s.loc_id) AS Locations,count(distinct s.veh_no) AS Vehicles,sum(s.bin_no) AS Bins
        FROM Zone_mas z
        LEFT JOIN schedule_mas s
        on s.zone_id=z.zone_id
               GROUP BY z.zone_id,z.zone_name) b
ON a.Zones = b.zone_id

$verify_sql = "SELECT ft.topic_id, ft.topic_title FROM forum_posts AS fp LEFT JOIN forum_topics AS ft ON fp.topic_id = ft.topic_id WHERE fp.post_id = '".$_GET["post_id"]."'";