PHP - How To Search Mysql Database And Display Results According To Query?

Need some help I have 2 tables in a database and I need to search the first table and use the results from that search, to search another table, can this be done? and if it can how would you recommend that I go about it?

Thanks For Your Help Guys! 

I have the following code that searches my database and displays results in a table:

$fields = array("field1", "field2", "field3")
$cols   = implode (', ', $fields); 

$result= mysql_query 
(" SELECT $cols FROM tablename  WHERE ................... ");

if (!$result) {die('Could not search database: ' . mysql_error());}

if($result)
{   
    
    if(mysql_num_rows($result) == 0)
    {
        return "Sorry. No records found in the database";                       
    }
    else 
    {
        $table = "<table border='1' cellpadding='5' cellspacing='5'>";
        while($arr = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            $table .= "\t\t<tr>\n";
            foreach ($arr as $val_col) 
            {
                $table .= "\t\t\t".'<td>'.$val_col.'</td>'."\n";
            }
            $table .= "\t\t</tr>\n";  
        }
        $table .= "</table>";
        echo $table;
    }
    mysql_free_result($result);       
}

As you can see each of the MySQL table fields specified by $fields is displayed in a new column in the html table.
I want to change this so that e.g. "field3" is displayed in a new row instead.

So, instead of the html table looking like:

| "field1-result1" | "field2-result1" | "field3-result1" |
| "field1-result2" | "field2-result2" | "field3-result2" |
| "field1-result3" | "field2-result3" | "field3-result3" |

I want it to look like:

| "field1-result1" | "field2-result1" | 
| "field3-result1" |                          |
| "field1-result2" | "field2-result2" |
| "field3-result2" |                          |
| "field1-result3" | "field2-result3" |
| "field3-result3" |                          |

I guess this is quite straightforward, but I can't work it out! Pls help!

Thanks.

I'm new to php and been trying to follow along with different tutorials to try and build my own site, i followed a tutorial on making a search feature
for the site and have it working perfectly, but i want to change the way how to search displays the results. I want to make it display them how there displayed on the index page.

here is the index page how there displayed


<div id="table">
            <table>
                <tr class="top">
                <th>Account</th>
                <th>Country</th>
                <th>Info</th>
                <th>Login</th>
                <th>Pass</th>
                <th>Price</th>
                <th>Buy</th>
            </tr>
            
              
           <?php $class = 'grey'; ?>
                <?php $items = getItems(); ?>
           <?php if(empty ($items)): ?>
                <h3>No Items Found</h3>
            <?php else: ?>
                <?php foreach($items as $item): ?>
                  <?php $class = ($class == 'grey') ? 'grey2' : 'grey'; ?>
                   <tr class="<?php echo $class; ?>">              
                    <td><?php echo $item['item_account']; ?></td>
                    <td><?php echo $item['item_country']; ?></td>
                    <td><?php echo $item['item_info']; ?></td>
                    <td><?php echo maskUser($item['item_login']); ?></td>
                    <td><?php echo maskPass($item['item_pass']); ?></td>
                    <td><?php echo $item['item_price']; ?> </td>
                    <td><form method="post" action="https://sci.libertyreserve.com/"><input type="submit" name="buy" value="Buy" class="button" /></form></td>
                    
                </tr>
               
                <?php endforeach; ?>
          <?php endif; ?>


how the search is display


if (strlen($search) <= 2)
        {
            echo 'Search keyword is too short.';
        }
        else
        {
            echo "You searched for <b>$search</b><hr size='1'>";
           
              
                $search_exploded = explode(" ", $search);
                
                foreach($search_exploded as $search_each)
                {
                   
                    $x++;
                    if ($x == 1)
                        $construct .= "item_account LIKE '%$search_each%'";
                    else
                        $construct .= " OR item_account LIKE '%$search_each%'";
                        
                    
                }
                
                $construct = "SELECT * FROM items WHERE $construct";
                
               $run = mysql_query($construct);
               
               $foundnum = mysql_num_rows($run);
               
               if ($foundnum == 0)
               {
                   echo 'No results found.';
               }
               else
               {
                   echo "$foundnum results found!</p>";
                   
                   while ($numrows = mysql_fetch_assoc($run))
                   {
                       $item_id = $numrows['item_id'];
                       $itemAccount = $numrows['item_account'];
                       $itemI = $numrows['item_info'];
                       $itemLogin = $numrows['item_login'];
                       $itemPass = $numrows['item_pass'];
                       $itemPrice = $numrows['item_price'];
                       
                       echo "
                           <b>$itemAccount</b><br />
                           $itemI <br />
                            " . maskUser($itemLogin) . '<br />' . maskPass($itemPass, 0) . '<br />'; 
                   }
                   
               }
           
            
        }

my question is im not sure how to edit the search code to display the results in the same format as the index page

thanks

Hello,

I have a search engine on my website that uses the following code:
Code: [Select]
//SQL FOR *SEARCH.PHP

$table = "videos";
  $search = $_GET['q'];
  // explode search words into an array
  $arraySearch = explode(" ", $_GET['q']);
  // table fields to search
  $arrayFields = array(0 => "title", 1 => "titletext", 2 => "tags", 3 => "originaltitle", 4 => "url");
  $countSearch = count($arraySearch);
  $a = 0;
  $b = 0;
  $sql = "SELECT * FROM ".$table."  WHERE status ='1' AND (";
  $countFields = count($arrayFields);
  while ($a < $countFields)
  {
    while ($b < $countSearch)
    {
      $sql = $sql."$arrayFields[$a] LIKE '%$arraySearch[$b]%'";
      $b++;
      if ($b < $countSearch)
      {
        $sql = $sql." AND ";
      }
    }
    $b = 0;
    $a++;
    if ($a < $countFields)
    {
      $sql = $sql.") OR (";
    }
  }
  $sql = $sql.") ORDER BY (videos.up-videos.down) DESC
LIMIT $start, $limit";

$result = mysql_query($sql);


My problem is that the SQL Query includes even videos that have STATUS='0' .. I only want the STATUS='1' to be shown.. How come? Thanks for help

I'm hoping this is a simple question.
When I use the code below, my twitter search query appears in BOLD within the returned results. I would like to style the search term differently. I can use CSS to style the avatar, author, and other information within the returned results etc, but I can't figure out how to style the search term ($q) within the returned twitter information. Any help would be much appreciated.

<?php

class twitter_class
{    
    function twitter_class()
    {
        $this->realNamePattern = '/\((.*?)\)/';
        $this->searchURL = 'http://search.twitter.com/search.atom?lang=en&q=';
        
        $this->intervalNames   = array('second', 'minute', 'hour', 'day', 'week', 'month', 'year');
        $this->intervalSeconds = array( 1,        60,       3600,   86400, 604800, 2630880, 31570560);
        
        $this->badWords = array('somebadword', 'anotherbadword');
    }

    function getTweets($q, $limit=15)
    {
        $output = '';

        // get the search result
        $ch= curl_init($this->searchURL . urlencode($q));

        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
        $response = curl_exec($ch);

        if ($response !== FALSE)
        {
            $xml = simplexml_load_string($response);
    
            $output = '';
            $tweets = 0;
            
            for($i=0; $i<count($xml->entry); $i++)
            {
                $crtEntry = $xml->entry[$i];
                $account  = $crtEntry->author->uri;
                $image    = $crtEntry->link[1]->attributes()->href;
                $tweet    = $crtEntry->content;
    
                // skip tweets containing banned words
                $foundBadWord = false;
                foreach ($this->badWords as $badWord)
                {
                    if(stristr($tweet, $badWord) !== FALSE)
                    {
                        $foundBadWord = true;
                        break;
                    }
                }
                
                $tweet = str_replace('<a href=', '<a target="_blank" href=', $tweet);
                
                // skip this tweet containing a banned word
                if ($foundBadWord)
                    continue;

                // don't process any more tweets if at the limit
                if ($tweets==$limit)
                    break;
                $tweets++;
    
                // name is in this format "acountname (Real Name)"
                preg_match($this->realNamePattern, $crtEntry->author->name, $matches);
                $name = $matches[1];
    
                // get the time passed between now and the time of tweet, don't allow for negative
                // (future) values that may have occured if server time is wrong
                $time = 'just now';
                $secondsPassed = time() - strtotime($crtEntry->published);

                if ($secondsPassed>0)
                {
                    // see what interval are we in
                    for($j = count($this->intervalSeconds)-1; ($j >= 0); $j--)
                    {
                        $crtIntervalName = $this->intervalNames[$j];
                        $crtInterval = $this->intervalSeconds[$j];
                            
                        if ($secondsPassed >= $crtInterval)
                        {
                            $value = floor($secondsPassed / $crtInterval);
                            if ($value > 1)
                                $crtIntervalName .= 's';
                                
                            $time = $value . ' ' . $crtIntervalName . ' ago';
                            
                            break; 
                        }
                    }
                }
                
                $output .= '
                <div class="tweet">
                    <div class="avatar">
                        <a href="' . $account . '" target="_blank"><img src="' . $image .'"></a>
                    </div>
                    <div class="message">
                        <span class="author"><a href="' . $account . '"  target="_blank">' . $name . '</a></span>: ' . 
                        $tweet . 
                        '<span class="time"> - ' . $time . '</span>
                    </div>
                </div>';
            }
        }
        else
            $output = '<div class="tweet"><span class="error">' . curl_error($ch) . '</span></div>';
        
        curl_close($ch);
        return $output;
    }
}

?>


The HTML I have been using with this code is here
Code: [Select]
<!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>
<title>Twitter</title>
</head>
<body>
<?php
  require('twitter.class.php');
  $twitter = new twitter_class();
  echo $twitter->getTweets('example search term', 10);
?>
</body>
</html>
This is not my code. It is from a tutorial that can be accessed from here >> http://www.richnetapps.com/php-twitter-search-parser/