Gill Posted November 21, 2003 Share Posted November 21, 2003 Using: DWMX/PHP/Mysql Hi All First time here so im not sure who the members of this group are so hello to everyone. Using dreamweaverMX I have inserted a recordset on my page which displays all the results from my database. I am trying to find a php script to go on my page as a visible text hyperlink that users can click to resort/refilter the results. ie making the current results: $query_Recordset1 = \"SELECT * FROM books\"; which is showing ALL the results from the database table, change to show only results where name column= paperback or name column = hardback etc i.e. allowing people to refilter the results. below is a full copy of my page. Can anyone tell me how to do this? Any advice is very much appreciated Gill ----- <?php require_once(\'Connections/str.php\'); ?> <?php $maxRows_Recordset1 = 10; $pageNum_Recordset1 = 0; if (isset($HTTP_GET_VARS[\'pageNum_Recordset1\'])) { $pageNum_Recordset1 = $HTTP_GET_VARS[\'pageNum_Recordset1\']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; mysql_select_db($database_str, $str); $query_Recordset1 = \"SELECT * FROM books\"; $query_limit_Recordset1 = sprintf(\"%s LIMIT %d, %d\", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $str) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); if (isset($HTTP_GET_VARS[\'totalRows_Recordset1\'])) { $totalRows_Recordset1 = $HTTP_GET_VARS[\'totalRows_Recordset1\']; } else { $all_Recordset1 = mysql_query($query_Recordset1); $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); } $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; ?> <html> <head> <title>Untitled Document</title> </head> <body> <table border=\"0\"> <tr> <td>no</td> <td>name</td> <td>url</td> </tr> <?php do { ?> <tr> <td><?php echo $row_Recordset1[\'no\']; ?></td> <td><?php echo $row_Recordset1[\'name\']; ?></td> <td><?php echo $row_Recordset1[\'url\']; ?></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table> </body> </html> <?php mysql_free_result($Recordset1); ?> Link to comment https://forums.phpfreaks.com/topic/1407-a-php-script-to-refilter-results/ Share on other sites More sharing options...
Gill Posted November 25, 2003 Author Share Posted November 25, 2003 Link to comment https://forums.phpfreaks.com/topic/1407-a-php-script-to-refilter-results/#findComment-4708 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.