question about table columns after a search query

[cybermob]

just curious i am trying to make 2 columns with my search query results, have everything working great except this ....not sure how i would go about it ? here is my noobie code hehe

<?php
include("checkme.php");
$mqsearch = $_GET['mqsearch'];
include("util.php");

if(!isset($_GET['page'])){
    $page = 1;
    } else {
    $page = $_GET['page'];
    }
$mqsearch = $_GET['mqsearch'];
$max_results = 3;
$q = $mqsearch;
$from = (($page * $max_results) - $max_results);
$sql = mysql_query("SELECT * FROM macontact WHERE MATCH (firstname,lastname,customer,talent) AGAINST ('%$q*%' IN BOOLEAN MODE) LIMIT $from, $max_results");
while($row = mysql_fetch_array($sql)){

echo ("<a href='mysite.php?info=$row[customer]'><table width='234' height='103' border='0' cellpadding='0' cellspacing='0'>");
echo  "<tr>";
echo  "<td colspan='2' rowspan='2'> <img src='images/BUSCARD_01.gif' width='13' height='14' alt=''></td>";
echo   "<td colspan='4'> <img src='images/BUSCARD_02.gif' width='206' height='5' alt=''></td>";
echo   "<td colspan='3' rowspan='2'> <img src='images/BUSCARD_03.gif' width='14' height='14' alt=''></td>";
echo   "<td> <img src='images/spacer.gif' width='1' height='5' alt=''></td>";
echo   "</tr>";
echo   "<tr>" ;
echo    "<td colspan='4'> <img src='images/BUSCARD_04.gif' width='206' height='9' alt=''></td>";
echo    "<td> <img src='images/spacer.gif' width='1' height='9' alt=''></td>";
echo   "</tr>";
echo   "<tr>" ;
echo    "<td rowspan='4'> <img src='images/BUSCARD_05.gif' width='5' height='72' alt=''></td>";
echo    "<td rowspan='9'> <img src='images/BUSCARD_06.gif' width='8' height='88' alt=''></td>";
echo     "<td rowspan='4'> <img src='";
echo    $row['headshot'];
echo    "' width='75' height='72' alt=''></td>";
echo    "<td rowspan='6'> <img src='images/BUSCARD_08.gif' width='9' height='79' alt=''></td>";
echo    "<td colspan='3'> <img src='images/spacer.gif' width='130' height='1' alt=''></td>";
echo    "<td rowspan='5'> <img src='images/BUSCARD_10.gif' width='5' height='75' alt=''></td>";
echo    "<td rowspan='9'> <img src='images/BUSCARD_11.gif' width='1' height='88' alt=''></td>";
echo    "<td> <img src='images/spacer.gif' width='1' height='5' alt=''></td>";
echo    "</tr>";
echo    "<tr>";
echo    "<td rowspan='6'> <img src='images/spacer1.gif' width='19' height='77' alt=''></td>";
echo    "<td colspan='2' valign='top'><div align='left'><font face='Arial, Helvetica, sans-serif'>";
echo     $row['firstname'].$row['lastname'];
echo     "</font></div></td>";
echo     "<td> <img src='images/spacer.gif' width='1' height='25' alt=''></td>";
echo     "</tr>";
echo     "<tr>" ;
echo     "<td colspan='2' valign='top'> <div align='left'><font face='Arial, Helvetica, sans-serif'>";
echo     $row['customer'];
echo      "  </font></div></td>";
echo      "<td> <img src='images/spacer.gif' width='1' height='27' alt=''></td>";
echo     "</tr>";
echo      "<tr>";
echo     "<td colspan='2' rowspan='2' valign='top'><div align='left'><font face='Arial, Helvetica, sans-serif'>";
echo     $row['talent'];
echo      "</font></div></td>";
echo      "<td> <img src='images/spacer.gif' width='1' height='15' alt=''></td>";
echo      "</tr>";
echo      "<tr>" ;
echo      "<td rowspan='5'> <img src='images/BUSCARD_16.gif' width='5' height='16' alt=''></td>";
echo      "<td rowspan='2'> <img src='images/BUSCARD_17.gif' width='75' height='7' alt=''></td>";
echo      "<td> <img src='images/spacer.gif' width='1' height='3' alt=''></td>";
echo      "</tr>";
echo      "<tr>" ;
echo      "<td colspan='3' rowspan='2'> <img src='images/BUSCARD_18.gif' width='116' height='7' alt=''></td>";
echo       "<td> <img src='images/spacer.gif' width='1' height='4' alt=''></td>";
echo       "</tr>";
echo       "<tr>";
echo       "<td colspan='2'> <img src='images/BUSCARD_19.gif' width='84' height='3' alt=''></td>";
echo       "<td> <img src='images/spacer.gif' width='1' height='3' alt=''></td>";
echo       "</tr>";
echo        "<tr>";
echo       "<td colspan='4'> <img src='images/BUSCARD_20.gif' width='206' height='5' alt=''></td>";
echo       "<td colspan='2' rowspan='2'> <img src='images/BUSCARD_21.gif' width='13' height='6' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='1' height='5' alt=''></td>";
echo        "</tr>";
echo        "<tr>";
echo         "<td colspan='4'> <img src='images/BUSCARD_22.gif' width='206' height='1' alt=''></td>";
echo         "<td> <img src='images/spacer.gif' width='1' height='1' alt=''></td>";
echo         "</tr>";
echo         "<tr>" ;
echo        "<td> <img src='images/spacer.gif' width='5' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='8' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='75' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='9' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='19' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='103' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='8' height='1' alt=''></td>";
echo         "<td> <img src='images/spacer.gif' width='5' height='1' alt=''></td>";
echo        "<td> <img src='images/spacer.gif' width='1' height='1' alt=''></td>";
echo        "<td></td>";
echo         "</tr>";
echo        "</table></a>";
}

$total_results = mysql_result(mysql_query("SELECT COUNT(*) FROM macontact WHERE MATCH (firstname,lastname,customer,talent) AGAINST ('%$q*%' IN BOOLEAN MODE)"),0);

$total_pages = ceil($total_results / $max_results);
$searchme = $mqsearch;
$mqsearch = $_POST['mqsearch'];

echo "<center>Select a Page<br />";

if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev&mqsearch=$q\"><< Previous</a>";
    
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
    echo "$i";
    } else {
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i&mqsearch=$q\"> $i</a>";
    }
    }
    
if($page < $total_pages){
$next = ($page + 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next&mqsearch=$q\"> Next >></a>";
}
echo "</center>";

include('footer.php'); 

?>

[markl999]

Not entirely sure what your question/problem is but i wouldn't echo wacking great chunks of HTML like that
Better to break in and out of PHP mode, e.g.
<html>
...some more html here..
<?php some php here ?>
...some more html here..
<?php more php etc..etc.. ?>
</html>

[cybermob]

wasnt sure if getting in and out of php would work with this so havent tried that yet hehe.

My main prob is right now my search results will come back to be in a single column straight down the page depending on how many i set per page.

i would really like it to go 2 across and 4 down from the query results, so if i get 8 results it would show all 8 on the page instead of 4 on first page and 4 on second.

just not sure how to structure the loop to do that

[Toly]

This link should help you out...

http://codewalkers.com/tutorials/15/1.html

[cybermob]

Thank you Toly !!! i get the concept now of doing columns in the search result, makes total sense now !!

and thank you Mark1999 i just put the html right in with nestled php for the variables and everything worked perfectly , much cleaner now !!!


Thanks all !!!!

[giropets]

This works also :

<?php
// Random Value //
$this = "that";

// Number of columns that you want to show //
$cols = "2";

// Percent in which you wish to have your columns //
$width = "50";

// MySQL Queries //
$query1 = mysql_query("SELECT * FROM tblName WHERE something='$this'") or exit("Please Contact Admin :  " . mysql_error());
$query2 = mysql_num_rows($query1);

// No results, display an error //
if($query2 == "0"){exit("No results to display.");}

// Counting -- DO NOT CHANGE //
$count = "0";

// Show the table and the first tr row //
echo"<table border='1' width='100%'>
<tr valign='top' align='center'>";

// Looping the Queries //
while($query3 = mysql_fetch_array($query1)){

// Updating the count //
$count = $count +1;

// Showing info //
echo"<td width='$width'>$query3[var1] - $query3[var2]</td>";

// If the count is greater than or equal to the columns set in the settings, make a new row and set the counting to '0' //
if($count >= "$cols"){echo"</tr><tr valign='top' align='center'>";$count = "0";}

// End your table //
echo"</table>";

}

?>

Just to let you know.