[SOLVED] Search results like these (link)

[skuliaxe]

** EDIT**
Skip to post #3

I´m looking to build a search results PHP like this one, but I wouldn't know where to start. I would like my results to display in a simple yet elegant manner (like in the link).

1. [Species name]
[Species description................]

2. etc....

Species name from tableX_Column2 and species description from tableX_column3. (Column1 (is primary, auto increment).

**EDIT**
I've erased most part of my original post as is was to much/complicated.
See post #3 for a more concise post

[masonbarge]

Sorry, it's just too much work to read through the entire code. However, if I'm correctly following what you have and what you want, it's just a matter of applying the correct html/css tags within the section you want to style. Like in

PHP: Select all

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.) $title" ;
  $count++ ;
  } 

You might have something like:

PHP: Select all

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;<div class='resulthead'>$title</div>" ;
  $count++ ;
  } 

I hope that helps a little.

[skuliaxe]

Thanks for that.
What I can´t seem to figure out (due to extreme lack of knowledge ) is th following:

Currently I´m using:
[SELECT * FROM table WHERE column LIKE (searchstring)...]

Could I use instead:
[SELECT id FROM table WHERE column LIKE (searchsting)...]
$id=mysql_query($query);
(Where 'id' is the Primary key and an auto increment for that field)

If that is OK then I don´t know how to echo/Print something like this:

echo [The 'name' from $id in database] <-- Looks up the 'id' field and fetches/prints data from the 'name' column in the field = $id.
echo [The 'description' from $id in database] <-- Looks up the 'id' field and fetches/prints data from the 'descriptions' column in the field = $id.

THAT IN A WHILE LOOP, while there is a result, echo/print that information.
That is what i´m trying to do here Any basic help or nudge in the right direction would make me really happy

[c010depunkk]

If you want to output everything in the database, then use "SELECT *":

PHP: Select all

$query=mysql_query("SELECT * FROM table");
while($row=mysql_fetch_array($query,MYSQL_ASSOC)) {
    echo('<h1>'.$row['name'].'</h1>');
    echo('<p>'.$row['description'].'</p>');
} 

If you just want the row with a specific id, then add a WHERE:

PHP: Select all

$query=mysql_query("SELECT * FROM table WHERE id='$id'");
while($row=mysql_fetch_array($query,MYSQL_ASSOC)) {
    echo('<h1>'.$row['name'].'</h1>');
    echo('<p>'.$row['description'].'</p>');
} 

If this isn't what you want, then, sorry... I hope I'm understanding your question, masonbarge also posted a similar solution.....

[skuliaxe]

[SOLVED]
Thank you so much masonbarge and c010depunkk (cookies )

I ended with the following:

PHP: Select all

$query = "SELECT * FROM table WHERE column1 LIKE \"%$trimmed%\" ORDER BY column1";

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

And then show results:

PHP: Select all

while ($row= mysql_fetch_array($result)) {
  $column1 = $row["column1"];
  $column2 = $row["column2"];

   echo "$count.)  $column1     $column2" ;
  $count++ ; 

Now I just have to do edit the 'echo' so it displays the results in a more elegant manner
Thanks again