I will try to explain this the best I can....
My search form asks to return certain fields from the MySQL database and that works fine, all the record & fields come back. Fields are AUTHOR DATE CATEGORY TITLE INFORMATION
However in the results the INFORMATION field can be extremely long and take up a few pages per record. I would like my results to return AUTHOR DATE CATEGORY TITLE of all matching records and if the user determines that they would like to see a certain record they could click on a field to return the INFORMATION field. (even if I have to redirect them to another page). ANY SUGGESTIONS???
Check it out yourself:
Go to and enter MATT in the text box and you can see how much text is actually returned for each record.
PHP CODE
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<TITLE>INPUT FORM</TITLE>
</HEAD>
<BODY>
<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>AUTHOR</b></td>
<td width="100"><b>DATE</b></td>
<td width="70"><b>CATEGORY</b></td>
<td width="150"><b>TITLE</b></td>
<td width="150"><b>INFORMATION</b></td>
</tr>
<tr>
<td>
<?php
$dbh=mysql_connect ("localhost", "USER", "PASSWORD"
or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("panao3_tierii"
?>
<?php
//error message (not found message)begins
$XX = "No Record Found, to search again please close this window";
//query details table begins
$query = mysql_query("SELECT * FROM sbmtdfrms WHERE $metode LIKE '%$search%' LIMIT 0, 50"
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["name"];
$variable2=$row["date"];
$variable3=$row["category"];
$variable4=$row["title"];
$variable5=$row["information"];
//table layout for results
print ("<tr>"
print ("<td valign='top'>$variable1</td>"
print ("<td valign='top'><pre>$variable2<pre></td>"
print ("<td valign='top'>$variable3</td>"
print ("<td valign='top'>$variable4</td>"
print ("<td valign='top'><pre>$variable5</pre></td>"
print ("</tr>"
}
//below this is the function for no record!!
if (!$variable1)
{
print ("$XX"
}
//end
?>
</table>
</center>
</body>
My search form asks to return certain fields from the MySQL database and that works fine, all the record & fields come back. Fields are AUTHOR DATE CATEGORY TITLE INFORMATION
However in the results the INFORMATION field can be extremely long and take up a few pages per record. I would like my results to return AUTHOR DATE CATEGORY TITLE of all matching records and if the user determines that they would like to see a certain record they could click on a field to return the INFORMATION field. (even if I have to redirect them to another page). ANY SUGGESTIONS???
Check it out yourself:
Go to and enter MATT in the text box and you can see how much text is actually returned for each record.
PHP CODE
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<TITLE>INPUT FORM</TITLE>
</HEAD>
<BODY>
<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>AUTHOR</b></td>
<td width="100"><b>DATE</b></td>
<td width="70"><b>CATEGORY</b></td>
<td width="150"><b>TITLE</b></td>
<td width="150"><b>INFORMATION</b></td>
</tr>
<tr>
<td>
<?php
$dbh=mysql_connect ("localhost", "USER", "PASSWORD"
or die ('I cannot connect to the database because: ' . mysql_error());mysql_select_db ("panao3_tierii"
; ?>
<?php
//error message (not found message)begins
$XX = "No Record Found, to search again please close this window";
//query details table begins
$query = mysql_query("SELECT * FROM sbmtdfrms WHERE $metode LIKE '%$search%' LIMIT 0, 50"
; while ($row = @mysql_fetch_array($query))
{
$variable1=$row["name"];
$variable2=$row["date"];
$variable3=$row["category"];
$variable4=$row["title"];
$variable5=$row["information"];
//table layout for results
print ("<tr>"
;print ("<td valign='top'>$variable1</td>"
; print ("<td valign='top'><pre>$variable2<pre></td>"
; print ("<td valign='top'>$variable3</td>"
; print ("<td valign='top'>$variable4</td>"
; print ("<td valign='top'><pre>$variable5</pre></td>"
; print ("</tr>"
; }
//below this is the function for no record!!
if (!$variable1)
{
print ("$XX"
;}
//end
?>
</table>
</center>
</body>