PHP - Search Accross Multiple Columns Script

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo

I want to echo out a few subcategories per main category.
It should be a maximum of 20 entries per column

At this stage I have the following... It echo's the results out in 4 columns and not what I want.
Any suggestions?

$query = "SELECT 
adsubcat.name AS subname, adsubcat.linkname AS sublink, adcat.clinkname AS clink
FROM adsubcat 
JOIN adcat ON adcat.id=adsubcat.catid
WHERE adsubcat.catid='$catid' ORDER BY adsubcat.name ASC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {

$count = 0;

print '<table style="text-align:left;margin-left:0px;width:943px;">'."\n";
while ($row = mysql_fetch_assoc($result)){
$gal = '<a href="'.$root.'/'.$row['clink'].'/'.$row['sublink'].'">'.$row['subname'].'</a>';
if ($count == 0){
print '<tr>';
}
++$count;
print '<td>'.$gal.'</td>';
if ($count == 4){
$count = 0;
print'</tr>'."\n";
}
}
print'</table>'."\n";
}

Hello all! I'm having some issues with a snippet that I found online and have edited to how I want it.

Basically the code works at the moment, except if I were to search for 2 or 3 terms, it would search the columns username/action/result/changes for any result that have any of the words rather than results that include both terms, instead of either.

I want the query to be like (assuming 2 search terms):

Quote

username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%' AND username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'


and not:

Quote

username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%' OR username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'


It needs an AND instead of an OR, but I'm not sure how to go around doing it.

Here's the code as it is at the moment:

$filter = ($_POST['filter']); 

$query = "SELECT * FROM activity WHERE"; 

$searchresult = explode(" ", $filter); 

     foreach ($searchresult as $key => $filter) { 
$query .= " username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'"; 
     if ($key != (sizeof($searchresult) - 1))   
$query .= " AND ";
     }
$query .= "ORDER BY id DESC"; 

Sorry if this is a little confusing to understand, hope someone understands what I need.

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

Hi all

How do I modify the below code to search multiple tables in mySQL database?

$query = "select * from store_items where description like \"%$trimmed%\"  or title like \"%$trimmed%\" or dimensions like \"%$trimmed%\" order by id ASC";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

It is for a search function and I need it to search another table called 'about_text' and 'faq_text'

Thanks
Pete

I'm somewhat new to OOP PHP, and I'm still learning, but basically I want searchcolumns() to set which MySQL columns that it'll search inside but I don't know where to go from what I've already coded.

Here's the basic input to be sent to my classes file:

$getusers = new database;
$getusers->search($_GET['search']);
$getusers->searchcolumns('username','account','email');

And to put it simple, I need my $where variable to output this:

$where .= "(username LIKE '%$search%' OR account LIKE '%$search%' OR email LIKE '%$search%')";

Except replacing the already set columns with the ones that I assigned in the searchcolumns() array, and then adding an OR string if there's more than 1 column set.

Here's the code as I have it at the moment, for obvious reasons, it doesn't work how I want it to:

// Search columns
function searchcolumns($columns) {

$this->column = explode(", ", $columns);
}

// Search results
function search($search) {

$search = ($_POST['search']);

if (isset($_GET['search']) && strlen($_POST['search']) > 1) {

$searchresult = explode(" ", $search);

$where = "WHERE";

foreach ($searchresult as $key => $search) { 

$where .= "($this->column LIKE '%$search%')";
if ($key != (sizeof($searchresult) - 1))   

$where .= " AND ";
} 

$this->where = $where;
}

}

Sorry if this has been somewhat confusing to explain, but hopefully someone understands what I'm trying to achieve.

I'm wanting to output data into two columns.  I've searched for this in a few places.  A vast majority of the search results deal with getting data from multiple columns, and the the ones that deal with what I'm looking for don't really have any solutions attached to them.

I'm not fully worried about the columns being equal length.  The data is broken up into a certain number of rows in a given year.  I have about 12 years, probably 6-8 rows per year.  I just don't know how to get it into different columns.  I don't care if it goes left to right then down or down then left to right.

If there has been a solution to that here already, feel free to point me in that direction.  Point me in any applicable direction, I'd fine with.  I just can't locate anywhere what trigger would cause that.

I have this code which works fine. I want to improve it by displaying it into multiple columns. Current output:

TITLE 1
JOB1
---------
TITLE 2
JOB 2
---------
ETC...

I want it to display like this instead:

TITLE 1  |   TITLE 2
JOB 1     |  JOB 2

Here is my code:

$sql = "SELECT * FROM coaches WHERE position = 'Junior Coach'"; 
$result = mysql_query ($sql); 

while ($row = mysql_fetch_array($result)){ 
$id = $row["id"];
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$position = $row["position"];
$image = $row["image"];
?>
             <table width="183" border="1">
                <tr>
                  <td align="center" height="18">
                  <?php echo "<img id='image_shadowCoaches' src=" . $image . ">"; ?><br />
  <?php echo "<div id='Coaches_Detail'>".$firstname." ".$lastname."</div>" ?>
                 <?php echo "<div id='Coaches_DetailLower'>".$position."</div>" ?>
                  
                  </td>
                </tr>
                </table>
             <?php } ?>

Hi there,

This is what I need to do, blow that is the code I have knocked up to do it but it doesn't seem to work. The main problem is the query that matches the atc callsigns to the pilots destinations.. can't fathom it myself.

1. Pull all the records from my database.
2. Assign their unique user id's, callsigns and destinations.
3. Execute a query in which you: SELECT * FROM CLIENTS WHERE (The 'clienttype' = 'ATC') AND match the callsign of the ATC users to the 'planned_destairport' of the 'clienttype' = 'PILOT'.

For example if three people are going to Heathrow, then it would return 3 results.
4. Then do a mysql_num_rows of the result.
5. Lastly, execute a query that would update the 'atcarrivals' collumn in the database with the count number using the unique 'cid' as the identifier.

All in a loop of course.


// Selects all of the ATC Records.
$atc_arrivals_selectquery = mysql_query ("SELECT * FROM CLIENTS");

// Starts the loop for fetching the records of the previous query.
while($atc_arrivals_row = mysql_fetch_array($atc_arrivals_selectquery)){

// Sets the users cid, planned_destairport and callsign.
$atc_cid = $atc_arrivals_row['cid'];
$atc_destinations = $atc_arrivals_row['planned_destaiport'];
$atc_callysign = $atc_arrivals_row['callsign'];

// Searches the database and selects all records where the callsign is LIKE the destination airport.
$atc_arrivals_check = mysql_query("SELECT * FROM CLIENTS WHERE clienttype = 'ATC' AND callsign LIKE '%$atc_destinations'");

// Counts previous query results.
$atc_arrivals_count = mysql_num_rows($atc_arrivals_check);

// Updates the atcarrivals column with the count..
$atc_arrivals_updatequery = mysql_query("UPDATE CLIENTS SET atcarrivals = '$atc_arrivals_count' WHERE cid = '$atc_cid' AND clienttype = 'ATC'");

// End loop.
}


Concerned columns are these:
"cid" - Unique client id.
"atcarrivals" - Number of arrivals from count. (This is the problem.)
"planned_destairport" - Destination airport of pilot. Usually four letters long. IE. EGLL = Heathrow.

Thanks.

I have some code that selects one column from mysql table. However when I try to add more it doesn't work.   First the working code....

$query = "SELECT `profile_privacy`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);

And here is where I have added another column....

$query = "SELECT `profile_privacy`, `profile_pictures`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);
$profile_pictures = mysql_result($result, 1);

What have I done wrong?

Many thanks,

Hi

I'm trying to find the max value in 3 columns, new_date, reply_date and finalized_date in my table:

Code: [Select]
$test = safe_query("SELECT MAX(new_date) FROM (SELECT new_date AS new_date FROM ".PREFIX."cup_challenges UNION SELECT reply_date FROM ".PREFIX."cup_challenges UNION SELECT finalized_date FROM ".PREFIX."cup_challenges) AS maxval");
Did some research and have no idea what is wrong/if the above is correct?
The page breaks below this code.

Hi. Im trying to get my table so I can click on username and it will display ascending or click again and it descends.

I want to be able to do this will all of them..Username Password IP Country Type Status E-mail Date start Date end ..
If anyone can help me it would be great. I dont know PHP . I paid someone to make this for my and they binned it half way through the job taking my money...



Thank you

This is my code



<?php
if(session_is_registered('username')){
    include("header.php");
   
?>                 
            <div id="content_main" class="clearfix">
            <div id="main_panel_container" class="left">
   <div id="tabledata" class="section">
            <h2 class="ico_mug">Users table</h2>
            <?
            if($_GET['type']=='delete'){
                mysql_query("delete from users where id='".$_GET['id']."'");
                ?><div id="success" class="info_div"><span class="ico_success">User deleted successful!</span></div><?
            }
            if($_GET['type']=='edit'){
                if(isset($_POST['username'])){
                    mysql_query("UPDATE users SET username='".$_POST['username']."',
                                                  password='".$_POST['password']."',
                                                  ip='".$_POST['ip']."',
                                                  country='".$_POST['country']."'
                                 WHERE id='".$_GET['id']."'");
                }
                $row=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='".$_GET['id']."'"));
                  ?>
                           <form action="" method="post" accept-charset="utf-8">
                           <fieldset>

                           <label>Username:<input type="text" name="username" value="<?echo $row['username'];?>" size=60/></label>
                           <label>Password:<input type="text" name="password" value="<?echo $row['password'];;?>" size=60/></label>
                           <label>IP:<input type="text" name="ip" value="<?echo $row['ip'];;?>" size=60/></label>
                           <label>Country:<input type="text" name="country" value="<?echo $row['country'];;?>" size=60/></label>
                             
                           <br />  <button>Submit</button>
             
                            </fieldset>
           
                            </form>
                            <button onclick="location.href='index.php?action=users';">Back</button>
                           <?
            }
            if($_GET['type']=='add'){
                if(isset($_POST)){
                    $j=0;
                    for($i=1; $i<=5; $i++){
                        if($_POST['username'.$i]!=''){
                        if(($_POST['username'.$i]!='') &&
                           ($_POST['password'.$i]!='') &&
                           ($_POST['ip'.$i]!='') &&
                           ($_POST['country'.$i]!=''))
                        {
                            if(($_POST['date_start'.$i]=='')||($_POST['date_end'.$i]=='')){
                                $date_start=0;
                                $date_end=0;
                            } else {
                            $date_start=strtotime($_POST['date_start'.$i]);
                            $date_end=strtotime($_POST['date_end'.$i]);
                            }
                            mysql_query("INSERT INTO users (username,password,ip,email,country,date_start,date_end) VALUES
                                        ('".$_POST['username'.$i]."','".$_POST['password'.$i]."','".$_POST['ip'.$i]."','".$_POST['email'.$i]."','".$_POST['country'.$i]."','".$date_start."','".$date_end."')
                                        ");
                            $j++;
                        } else {
                            ?><div id="fail" class="info_div"><span class="ico_cancel">Fields on the same row can't be blank</span></div><?
                        }
                        }
                    }
                    if($j>0){
                    ?><div id="success" class="info_div"><span class="ico_success"><? echo $j;?> users have been added!</span></div><?
                    }
                }
               
            ?>
            <fieldset>
            <i>
            Date format should be like 2000-05-25<br>
            Type: B for instant buy; S for subscription<br>
            Status: Y for active; N for inactive
            </i>
            </fieldset>
            <form action="" method="post" accept-charset="utf-8">
            <table id="table">
            <thead>
            <tr>
               
                <th>Username</th>
                <th>Password</th>
                <th>IP</th>
                <th>Email</th>
                <th>Country</th>
                <th>Type</th>
                <th>Status</th>
                <th>Date start</th>
                <th>Date end</th> 
            </tr>
            </thead>
            <tbody>
           
                           
           
                <?
                for ($i=1; $i<=5; $i++) {
?>
                <tr>
                <td>
                    <input type="text" name="username<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="password<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="ip<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="email<?echo $i;?>" size="10">
                </td>
                <td>
                    <select name="country<?echo $i;?>">
                        <option value="UK">UK</option>
                        <option value="US">US</option>
                    </select>
                </td>
                <td>
                    <select name="type<?echo $i;?>">
                        <option value="B" selected>B</option>
                        <option value="S">S</option>
                    </select>
                </td>
                <td>
                    <select name="status<?echo $i;?>">
                        <option value="Y" selected>Y</option>
                        <option value="N">N</option>
                    </select>
                </td>
                <td>
                    <input type="text" name="date_start<?echo $i;?>"  size="10">
                </td>
                <td>
                    <input type="text" name="date_end<?echo $i;?>" size="10">
                </td>
                </tr>
                <? } ?>
           
            <tr>
            <td><button>Submit</button> </td>
            </tr> 
                           
           
                           
            </tbody>
            </table>
            </form>
            <br>
            <?
           
            }
           
?>
       
       <?php
           
         if($_GET['type']=='import')
         {
            
            if($_POST['import'] && $_FILES['flimport']['name']!='')
            {
               //print_r($_FILES);
               $fieldseparator = ",";
               $lineseparator = "\n";
               $csvfile=$_FILES['flimport']['tmp_name'];
               $size = $_FILES['flimport']['size'];
               if(!$size) {
                  exit;
               }
               $file = fopen($csvfile,"r");
               $csvcontent = fread($file,$size);
               fclose($file);
               //////////////////////////////////////////////////////////////
               $lines = 0;
               $queries = 0;
               $linearray = array();
               foreach(split($lineseparator,$csvcontent) as $line) {
               
                  $lines++;
               
                  $line = trim($line," \t");
                  
                  $line = str_replace("\r","",$line);
                  $line = str_replace("'","\'",$line);
                  
                  $linearray = explode($fieldseparator,$line);
                  
                  $linemysql = implode("','",$linearray);
                  $exist=0;
                  if(is_numeric($linearray[0]))
                  {
                     $exist=mysql_num_rows(mysql_query("select id from users where username='".$linearray[2]."' or email='".$linearray[1]."'"));
                        $query = "insert into users values('$linemysql');";
                     
                  }
                  else
                  {
                     $exist=mysql_num_rows(mysql_query("select id from users where username='".$linearray[1]."' or email='".$linearray[0]."'"));
                        $query = "insert into users values('','$linemysql');";
                     
                  }
                  //echo $query."<br />";
                  if($exist==0)
                  {
                     @mysql_query($query);               
                     if(mysql_insert_id())
                        $queries++;
                  }
               }   
               
                  echo '<div id="success" class="info_div"><span class="ico_success">'.$queries.' users added successfully</span></div>';
               
            }
         ?>
            <form name="frmImport" action="" method="post" enctype="multipart/form-data">
            <input type="hidden" value="1" name="import" />
                <table id="table">
                <tbody>
                   <tr>
                         <td><span style="font-size:10px; color:#333">Note: Please entry ms excel <strong>.CSV (Comma delimited)</strong> file only</span></td>
                    </tr>
                    <tr>
                         <td><input type="file" accept="application/msexcel" name="flimport" />
                        </td>
                    </tr>
                    <tr>
                         <td><button>Import Now</button></td>
                    </tr>
                   </tbody>
                  </table>
            </form>
         <br />
         <?php } ?>
      
      <button onclick="location.href='index.php?action=users&type=add';">Add users</button>
      &nbsp;<button onclick="location.href='index.php?action=users&type=import';" name="btnimport">Import users</button>
         &nbsp;<button onclick="location.href='export.php?datafrom=users';" name="btnexport">Export users</button>
      
      
      
        <table id="table">
            <thead>
            <tr>
                <th>Actions</th>
                <th>Username</th>
                <th>Password</th>
                <th>IP</th>
                <th>Country</th>
                <th>Type</th>
                <th>Status</th>
                <th>E-mail</th>
                <th>Date start</th>
                <th>Date end</th>
               
            </tr>
            </thead>
            <tbody>
            <?
            if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }
            $start_from = ($page-1) * 20;
            $query=mysql_query("SELECT * FROM users WHERE 1 LIMIT $start_from, 20");
            while($row=mysql_fetch_array($query)){
               
           
?>
            <tr>
                <td><a href="index.php?action=users&type=delete&id=<?echo $row['id'];?>"><img src="img/cancel.jpg" alt="cancel"/></a><a href="index.php?action=users&type=edit&id=<?echo $row['id'];?>"><img src="img/edit.jpg" alt="edit"/></a></td>
                <td><?echo $row['username'];?></td>
                <td><?echo $row['password'];?></td>
                <td><?echo $row['ip'];?></td>
                <td><?echo $row['country'];?></td>
                <td><?echo $row['type'];?></td>
                <td><?echo $row['status'];?></td>
                <td><?echo $row['email'];?></td> 
                <td class="table_date"><?echo date("Y-m-d",$row['date_start']);?></td>
                <td class="table_date"><?echo date("Y-m-d",$row['date_end']);?></td>
            </tr>
           
            <?
            }
?>
            </tbody>
        </table>
        <?
           
            $rs_result = mysql_query("SELECT COUNT(id) FROM users");
            $row = mysql_fetch_row($rs_result);
            $total_records = $row[0];
            $total_pages = ceil($total_records / 20);
             
?>
           
            <div class="pagination">
                <span class="pages">Page 1 of <?echo $total_pages;?></span>
               
                <?php
                for ($i=1; $i<=$total_pages; $i++) {
                if($page==$i){
                    ?><span class="current"><b><?echo $page;?></span></b><?
                } else {
                    echo "<a href='index.php?action=users&type=view&page=".$i."'>".$i."</a> ";
                }
                }
                if($total_pages>1){
                $next=$page+1;
               
                ?>
                <a href="index.php?action=users&type=view&page=<? echo $next;?>" >&raquo;</a>
                <?
                }
?>
            </div>
        </div> <!-- end #tabledata -->

              <?
        include("shortcuts.php");
        ?>
            </div>
        <?
       
        ?>
        </div><!-- end #content_main -->


       
        </div><!-- end #content -->
 <?
    include("footer.php");
?>

<?
    } else {
    header( "Location: index.php?action=login" );
}
?>

Hello. I am working on a php script for searching a database table. I am really new to this, so I used the this tutorial http://www.phpfreaks.com/tutorial/simple-sql-search

I managed to get all the things working the way I wanted, except one important and crucial thing.
Let me explain.
My table consist of three columns, like this:

ID(bigint20)    title(text)        link (varchar255)
=============================
ID1                title1                link-1
ID2                title2                link-2
etc...

Like I said, I managed to make the script display results for a search query based on the title. Want I want it to do more, but I can't seem to find the right resource to learn how, is to place a "Download" button under each search result with its corresponding link from the table.

Here is the code I used.

<?php

$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'user'; 
$dbPass = 'pass';
$dbDatabase = 'db'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());
// Set up our error check and result check array
$error = array();
$results = array();
// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT title, link FROM db WHERE title LIKE '%{$searchTermDB}%'";

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

       

   
         }
      
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 


}
?>

      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="search?" name="searchForm">
         Search for title: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" />
        
         <input type="submit" name="submit" value="Search" />
      </form>

    <?php echo (count($results) > 0)?"Rezultate lucrari de licenta sau disertatie pentru {$searchTerms} :<br /><br />" . implode("", $results):""; ?>




 $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

 
I would like the results to be displayed like this

Results for SearchItem:

Result 1
Download | Other link
Result 2
Download | Other link
etc.... or something like this.

So, how do I add the data from the link row into a text(Dowload), within an <a href> tag (well, at least I guess it would go this way) ?
My first tries (fueled by my lack of knowledge) where things like

$results[] = "{$row['title']}<br /> <a href="{$row['link']}">Download</a> <br /> ";

but I keep getting lots of errors, and then I don't know much about arrays and stuff (except basic notions);
So there it is. I am really stuck and can't seem to find any workaround for this.
Any suggestions? (examples, documentation, anything would do, really)
Thanks,
Radu

does anyone have a code todo this? a snippet or soemthing ive tried a few diffrent ones ive seen but nothing that works.. it takes whats submited in search, then takes the words, breaks them up and creates a query string with all the diffrent feilds... here is what phpadmin produces when i search

 SELECT *  FROM `breedclads`.`activeamahorse` WHERE (`id_entered` LIKE '%green%' OR `uuid` LIKE '%green%' OR `ama_hr_coat` LIKE '%green%' OR `breedable` LIKE '%green%' OR `ama_hr_sex` LIKE '%green%' OR `ama_hr_age` LIKE '%green%' OR `date_entered` LIKE '%green%' OR `ama_hr_eyes` LIKE '%green%' OR `ama_hr_eyes_type` LIKE '%green%' OR `ama_hr_mane` LIKE '%green%' OR `ama_hr_tail` LIKE '%green%' OR `ama_hr_luster_coat` LIKE '%green%' OR `ama_hr_luster_hair` LIKE '%green%' OR `ama_hr_gleam_coat` LIKE '%green%' OR `ama_hr_gleam_hair` LIKE '%green%' OR `ama_hr_parents` LIKE '%green%' OR `ama_hr_sale_type` LIKE '%green%' OR `ama_hr_sale_price` LIKE '%green%' OR `ama_hr_location` LIKE '%green%' OR `auction_date` LIKE '%green%' OR `picture_type` LIKE '%green%' OR `picture_name` LIKE '%green%' OR `picture_size` LIKE '%green%' OR `picture_content` LIKE '%green%' OR `ama_hr_coat_type` LIKE '%green%' OR `ama_hr_coat_gloom` LIKE '%green%' OR `ama_hr_hair_gloom` LIKE '%green%' OR `ama_hr_slurl` LIKE '%green%' OR `class_link_key` LIKE '%green%')  AND  (`id_entered` LIKE '%albino%' OR `uuid` LIKE '%albino%' OR `ama_hr_coat` LIKE '%albino%' OR `breedable` LIKE '%albino%' OR `ama_hr_sex` LIKE '%albino%' OR `ama_hr_age` LIKE '%albino%' OR `date_entered` LIKE '%albino%' OR `ama_hr_eyes` LIKE '%albino%' OR `ama_hr_eyes_type` LIKE '%albino%' OR `ama_hr_mane` LIKE '%albino%' OR `ama_hr_tail` LIKE '%albino%' OR `ama_hr_luster_coat` LIKE '%albino%' OR `ama_hr_luster_hair` LIKE '%albino%' OR `ama_hr_gleam_coat` LIKE '%albino%' OR `ama_hr_gleam_hair` LIKE '%albino%' OR `ama_hr_parents` LIKE '%albino%' OR `ama_hr_sale_type` LIKE '%albino%' OR `ama_hr_sale_price` LIKE '%albino%' OR `ama_hr_location` LIKE '%albino%' OR `auction_date` LIKE '%albino%' OR `picture_type` LIKE '%albino%' OR `picture_name` LIKE '%albino%' OR `picture_size` LIKE '%albino%' OR `picture_content` LIKE '%albino%' OR `ama_hr_coat_type` LIKE '%albino%' OR `ama_hr_coat_gloom` LIKE '%albino%' OR `ama_hr_hair_gloom` LIKE '%albino%' OR `ama_hr_slurl` LIKE '%albino%' OR `class_link_key` LIKE '%albino%')  AND  (`id_entered` LIKE '%69%' OR `uuid` LIKE '%69%' OR `ama_hr_coat` LIKE '%69%' OR `breedable` LIKE '%69%' OR `ama_hr_sex` LIKE '%69%' OR `ama_hr_age` LIKE '%69%' OR `date_entered` LIKE '%69%' OR `ama_hr_eyes` LIKE '%69%' OR `ama_hr_eyes_type` LIKE '%69%' OR `ama_hr_mane` LIKE '%69%' OR `ama_hr_tail` LIKE '%69%' OR `ama_hr_luster_coat` LIKE '%69%' OR `ama_hr_luster_hair` LIKE '%69%' OR `ama_hr_gleam_coat` LIKE '%69%' OR `ama_hr_gleam_hair` LIKE '%69%' OR `ama_hr_parents` LIKE '%69%' OR `ama_hr_sale_type` LIKE '%69%' OR `ama_hr_sale_price` LIKE '%69%' OR `ama_hr_location` LIKE '%69%' OR `auction_date` LIKE '%69%' OR `picture_type` LIKE '%69%' OR `picture_name` LIKE '%69%' OR `picture_size` LIKE '%69%' OR `picture_content` LIKE '%69%' OR `ama_hr_coat_type` LIKE '%69%' OR `ama_hr_coat_gloom` LIKE '%69%' OR `ama_hr_hair_gloom` LIKE '%69%' OR `ama_hr_slurl` LIKE '%69%' OR `class_link_key` LIKE '%69%')




i need this to be made when people search with mutliple words  as you can see it searchs each feilds for the green then each feild for albino, so on.. but i wont ever know what there searching for

Please help me, thanks

Hi There,

I have an SQL query that returns 10 rows, which I want to echo over 2 columns and 5 rows, however, I want rows 1-5 on the left hand column and rows 6-10 on the right hand side.

Is there an easy way to do this? Normally I would do a fetch_array but, that would place the rows in order of, left, right, left, right - if that makes sense?

Table is a standard table with 2 columns and 5 rows.

Thanks
Matt