PHP - Moved: Select 'brand' Column And Remove/condense Duplicates

My query is a fixtures list for my local sports team- There seems little point including fixtures from the past as they are in a results query anyway.
I'm ordering by date (see below) but how can I remove the ones already past?

$query = "SELECT * FROM fix10 ORDER BY Date";

TIA Nick

Hi, i got help earlier with the this code-- exploding a field and getting an array, then inserting the array into a multiselect box-- That part is easy and works fine.

Now the explode function gives an array of words with duplicate words in it:
I tried several ways most either give a blank option/value, or the array word..

here is the code:


$query = "SELECT DISTINCT property_functionsexperience FROM #__users_profiles WHERE published = '1' ORDER BY property_functionsexperience ASC";
      $functionsexperiencelistgeneral=doSelectSql($query);      
        foreach($functionsexperiencelistgeneral as $words)
      $property_funcexperilist=$words->property_functionsexperience;      
        $wording = explode(', ', $property_funcexperilist);
        foreach($wording as $funciex)
      $funcexi=array_unique($funciex);
      $funcexpList .= "<option value=\"".$funcexi.','."\">".$funcexi."</option>";
      $funcexpList .= "</optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         


this code is adapted slightly from the working original that gives the double words-- this code gives a blank, but i think its on the correct track!?

is it possible to do something like

Code: [Select]
$today = date("Y-m-d");

$result = mysql_query("SELECT * FROM staff where date = '.$today.'  ");
also, is it normal for the first entry in the database not to be displayed?  i have 6 entries in a table and only 2-6 are shown.  when i changed the id for 1 to 7, it only displayed 3-7.

The Script:

<?php

    include("connect.php");

?>
<?php

    echo "<h1>The Hashtag: </h1>";
    if(isset($_GET['hashtag'])){
        echo $_GET['hashtag'];
    }


    // Select the ID of the given hashtag from the "hashtags" table.
    $tqs = "SELECT `id` FROM `hashtags` WHERE `hashtag` = '" . $_GET['hashtag'] . "'";
    $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));
    $row = mysqli_fetch_assoc($tqr);

    // This prints e.g.:
    // 100
    echo "<br/><br/>";
    print_r($row['id']);

    // Select the threads from the "thread" table which contains the hashtag ID number.
    $tqs_two = "SELECT * FROM `thread` WHERE `hashtag_id` IN ('" . $row['id'] . "')";
    $tqr_two = mysqli_query($dbc, $tqs_two) or die(mysqli_error($dbc));
    $row_two = mysqli_fetch_assoc($tqr_two);

    echo "<br/><br/>";
    print_r($row_two);

?>

The script should select the rows by that ID number of the hashtag. It should look in the "hashtag_id" column of the table and see if that ID number can be found there, if it can be found there, then it should select that row.   The ID numbers are inside that "hashtag_id" column separated by commas.   Example:

98, 99, 100

My Question: How to do the SQL query so it selects the rows by the hashtag ID number?
Edited by glassfish, 17 October 2014 - 10:35 AM.

Me and a buddy have started a new website.  Were basically looking to make a site where you can upload a swf or image file (at first) for a temp. amount of time.  Lets say 24 hours.  Then after 24 hours its deleted.    We eventually wanna grow into a bigger site where you can log in, keep your files, etc.  However we have the site layed out and a server set up.  We are missing the key part of PHP making the site work. 

What are the first steps we should take?

Are their any tutorials to help us set up a basic site?

Does anyone wanna help with the project?   ....  j/k..... but seriously.

Thanks guys.  Would love any advice or tips. 

Please I want get data from mysql; 

1. The last 24 hours. 
2 the last 7 days 
3. the last Months  4. Last 12 hours

please try and help me

I am trying to display records from a database using pagination.  Currently the first page is showing and data is being displayed correctly.  The links are also available below to move from page to page, however when I click on the next page, nothing happens.  I know I need to add parameters to my query string, but I'm unsure as to what I need to add.  Can someone help?

Here is where I am calling the page:

Code: [Select]
<a href="index.php?menukey=7" accesskey="7" title="">Project 3</a>
Here is my pagination:

Code: [Select]
function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5) {
        $this->conn = $connection;
        $this->sql = $sql;
        $this->rows_per_page = $rows_per_page;
        $this->links_per_page = $links_per_page;
        $this->php_self = htmlspecialchars($_SERVER['PHP_SELF']);
        if(isset($_GET['page'])) {
            $this->page = intval($_GET['page']);
        }
    }
   
    /**
     * Executes the SQL query and initializes internal variables
     *
     * @access public
     * @return resource
     */
    function paginate() {
        if(!$this->conn) {
            if($this->debug) echo "MySQL connection missing<br />";
            return false;
        }
       
        $all_rs = @mysql_query($this->sql);
        if(!$all_rs) {
            if($this->debug) echo "SQL query failed. Check your query.<br />";
            return false;
        }
        $this->total_rows = mysql_num_rows($all_rs);
        @mysql_close($all_rs);
       
        $this->max_pages = ceil($this->total_rows/$this->rows_per_page);
        //Check the page value just in case someone is trying to input an aribitrary value
        if($this->page > $this->max_pages || $this->page <= 0) {
            $this->page = 1;
        }
       
        //Calculate Offset
        $this->offset = $this->rows_per_page * ($this->page-1);
       
        //Fetch the required result set
        $rs = @mysql_query($this->sql." LIMIT {$this->offset}, {$this->rows_per_page}");
        if(!$rs) {
            if($this->debug) echo "Pagination query failed. Check your query.<br />";
            return false;
        }
        return $rs;
    }
   
    /**
     * Display the link to the first page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'First'
     * @return string
     */
    function renderFirst($tag='First') {
        if($this->page == 1) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page=1">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the link to the last page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'Last'
     * @return string
     */
    function renderLast($tag='Last') {
        if($this->page == $this->max_pages) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page='.$this->max_pages.'">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the next link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '>>'
     * @return string
     */
    function renderNext($tag=' &gt;&gt;') {
        if($this->page < $this->max_pages) {
            return '<a href="'.$this->php_self.'?page='.($this->page+1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the previous link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '<<'
     * @return string
     */
    function renderPrev($tag='&lt;&lt;') {
        if($this->page > 1) {
            return '<a href="'.$this->php_self.'?page='.($this->page-1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the page links
     *
     * @access public
     * @return string
     */
    function renderNav() {
        for($i=1;$i<=$this->max_pages;$i+=$this->links_per_page) {
            if($this->page >= $i) {
                $start = $i;
            }
        }
       
        if($this->max_pages > $this->links_per_page) {
            $end = $start+$this->links_per_page;
            if($end > $this->max_pages) $end = $this->max_pages+1;
        }
        else {
            $end = $this->max_pages;
        }
           
        $links = '';
       
        for( $i=$start ; $i<$end ; $i++) {
            if($i == $this->page) {
                $links .= " $i ";
            }
            else {
                $links .= ' <a href="'.$this->php_self.'?page='.$i.'">'.$i.'</a> ';
            }
        }
       
        return $links;
    }
   
    /**
     * Display full pagination navigation
     *
     * @access public
     * @return string
     */
    function renderFullNav() {
        return $this->renderFirst().'&nbsp;'.$this->renderPrev().'&nbsp;'.$this->renderNav().'&nbsp;'.$this->renderNext().'&nbsp;'.$this->renderLast();   
    }
   
    /**
     * Set debug mode
     *
     * @access public
     * @param bool $debug Set to TRUE to enable debug messages
     * @return void
     */
    function setDebug($debug) {
        $this->debug = $debug;

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=328353.0

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=325974.0

I have searched this forum as well as over 200 other forums and have not found the answer that is specific to my question. I have shortened my code drastically to assist in resolving this quickly -   I have a search form that has criteria for the search criteria with "virtual" "columns" in an array but it's not working. If I search one column at a time it works just fine but when I try to search 8 columns with one select I get the following error: SELECT Error: Unknown column 'achievements' in 'where clause'.   When a user selects search in Achievements, I need it to look at all 8 columns that are associated with achievements and bring back the results that match - the same as if the user selects search in Associations, I need it to look at all 5 columns and bring back the results that match.   My shortened code is as follows:

        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Search</title>
    </head>
    
    <body>
    
    <form name="search" action="" method="POST">
    
      <p>Search:</p>
      <p>
        
        Achievements/Associations: <input type="text" name="find1" /> in 
      <Select NAME="field1">
        <Option VALUE="achievements">Achievements</option>
        <Option VALUE="associations">Associations</option>
      </Select>
      <br><br>
      
      Secondary Education: <input type="text" name="find2" /> in 
      <Select NAME="field2">
        <Option VALUE="edu1sectype">Highest Certificate Attained</option>
        <Option VALUE="edu1secname">Highest Grade Passed</option>
        <Option VALUE="edu1secinst">Name of High School</option>
        <Option VALUE="edu1secdate">Date Completed</option>
        <Option VALUE="edu1secinsttyp">Type of Institution</option>
        <Option VALUE="subjects">Subjects</option>
      </Select>
      <br><br>
         
      <input type="hidden" name="searching" value="yes" />
      <input type="submit" name="search" value="Search" />
      </p>
    </form>
    
    <?php
    $searching = $_POST['searching'];
    
    $find1 = $_POST['find1'];
    $field1 = $_POST['field1'];
    
    $find2 = $_POST['find2'];
    $field2 = $_POST['field2'];
    
    if ($searching =="yes") 
     { 
     
     echo "<br><b>Searched For:</b>  $find1 $find2<br>"; 
     echo "<br><h2>Results</h2><p>"; 
     
     //If they did not enter a search term we give them an error 
     
     
     // Otherwise we connect to our Database 
    include_once "connect_to_mysql.php";
    mysql_select_db("table_name") or die(mysql_error());
     
     // We preform a bit of filtering 
    $find = strtoupper($find);
    $find = strip_tags($find);
    $find = trim($find);
    $find = mysql_real_escape_string($find);
    $field = mysql_real_escape_string($field);
    
    $data = mysql_query("SELECT * FROM table_name
    
    WHERE upper(".$field1.")  LIKE '%$find1%'
    AND upper(".$field2.")  LIKE '%$find2%'
    ") or die("SELECT Error: ".mysql_error());
    
    $result = mysql_query("SELECT * FROM table_name 
     WHERE upper($field1) LIKE '%$find1%'
    AND upper($field2) LIKE '%$find2%'
    ") or die("SELECT Error: ".mysql_error());
    $num_rows = mysql_num_rows($result);
    
    echo "There are $num_rows records:<br>";
     echo '<center>';
    										
    									    echo "<table border='1' cellpadding='5' width='990'>";
                                            
                                            // set table headers
                                            echo "<tr><th>Reference</th>
    										          <th>First Name</th>
    										          <th>Last Name</th>
    												  </tr>";
    
    //get images and names in two arrays
    
    $name= $row["name"];
    $surname= $row["surname"];
    $achieve1 = $row["achieve1"];
    $achieve2 = $row["achieve2"];
    $achieve3 = $row["achieve3"];
    $achieve4 = $row["achieve4"];
    $achieve5 = $row["achieve5"];
    $achieve6 = $row["achieve6"];
    $achieve7 = $row["achieve7"];
    $achieve8 = $row["achieve8"];
    $assoc1 = $row["assoc1"];
    $assoc2 = $row["assoc2"];
    $assoc3 = $row["assoc3"];
    $assoc4 = $row["assoc4"];
    $assoc5 = $row["assoc5"];
    $edu1sectype = $row["edu1sectype"];
    $edu1secinst = $row["edu1secinst"];
    $edu1secname = $row["edu1secname"];
    $edu1secdate = $row["edu1secdate"];
    $edu1secinsttyp = $row["edu1secinsttyp"];
    $subject1 = $row["subject1"];
    $subject2 = $row["subject2"];
    $subject3 = $row["subject3"];
    $subject4 = $row["subject4"];
    $subject5 = $row["subject5"];
    $subject6 = $row["subject6"];
    $subject7 = $row["subject7"];
    $subject8 = $row["subject8"];
    $compsoft1name = $row["compsoft1name"];
    $compsoft2name = $row["compsoft2name"];
    $compsoft3name = $row["compsoft3name"];
    $compsoft4name = $row["compsoft4name"];
    $compsoft5name = $row["compsoft5name"];
    $compsoft6name = $row["compsoft6name"];
    
    $achievements = array('achieve1', 'achieve2', 'achieve3', 'achieve4', 'achieve5', 'achieve6', 'achieve7', 'achieve8');
    
    $associations = array('assoc1', 'assoc2', 'assoc3', 'assoc4', 'assoc5');
    
    $subjects = array('subject1', 'subject2', 'subject3', 'subject4', 'subject5', 'subject6', 'subject7', 'subject8' );
    
    $compsoft = array('compsoft1name', 'compsoft2name', 'compsoft3name', 'compsoft4name', 'compsoft5name', 'compsoft6name');
    
    while ($row = mysql_fetch_array($result))
    {
    
     echo "<tr>";
    												echo "<td ALIGN=LEFT>" . $row['id'] . "</td>";
                                                    echo "<td ALIGN=LEFT>" . $row['name'] . "</td>";
                                                    echo "<td ALIGN=LEFT>" . $row['surname'] . "</td>";
    												echo "</tr>";
                                            }
                                            
                                            echo "</table>";
                                   
     
     
     //This counts the number or results - and if there wasn't any it gives them a little message explaining that 
     $anymatches=mysql_num_rows($data);
    if ($anymatches == 0) {
    echo "Sorry, but we can not find an entry to match your query";
    }
     }
     
    ?>
    
    </body>
    </html>

Any assistance will be greatly appreciated as I have been working on this website for the past 4 months which has totalled over 150 pages and this is one of the last pages left to program and it's taken 6 days to get to this search page to this point.

Ok basic setup is

Table name = unit_data
I have a field  unit_paid_date colum type = DATE

unit_paid_date = 2011-03-02
thats yyyy-mm-dd

lets say for example the DueDate is the Second of every month

I need to select all records from unit_data that are PAST DUE
so if the last paid date is 2011-01-02

that record will pop up as PAST DUE

BUT if that paid date is say 2011-03-10 it will not be shown because the invoice was paid Ahead of due date

I had this almost working properly -- but can use any help you guys offer.
I was attempting to use mysql WHERE queries and do checks against paid_date but failed

Thanks

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=316055.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=326002.0

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=307587.0

Hi.
Maybe a tricky question?

How do I reflect the content of a column from a database table in a roll down select menu in the browser?

Let's say that the content of the table column is:

Anna
Michael

These names should be reflected in this select menu like this:

<select name="friends">
<option value="Choose a name">Choose a name</option>
<option value="Anna">Anna</option>
<option value="Michael">Michael</option>

So visitors can choose a name, and thereby turn it into a variable, for reuse in the database.

Best regards Morris