MySQL Table Search

How can you limit the number of records shown?

At the minute there are 10 records, if I ad 20 more records I would have 30 records.

I would like to show only 15 records then the system will go to page 2, where page 2 would only show 15 records and so on.


For example: It would look like this: 1 - 2 - 3 - 4 > next

hey nice script dude, works fine with y website ...thnxxx

I'm unable download the "MySQL Table Search" script.

• 

  Sasho Valkanov

  March 29, 2012 at 07:47 am

  what browser are you using? Do you see any error message? Script downloads just fine.

  • reply
  • report
  • (0)
  • (0)

Hi,

I am successfully using the MySQL table search with the drop menu to filter results. Love it. Can anyone help me tie in a second drop down menu to filter by name AND city??

So far I have only declared a variable for the full_name field. What to do with the rest of the code????

if ($_REQUEST["city"]<>'') {

	$search_city = " AND city='".mysql_real_escape_string($_REQUEST["city"])."'";	

}

if ($_REQUEST["full_name"]<>'') {

	$search_city = " AND full_name='".mysql_real_escape_string($_REQUEST["full_name"])."'";	

}



if ($_REQUEST["from"]<>'') {

	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city;

} else if ($_REQUEST["to"]<>'') {

	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;

} else {

	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE id>0".$search_string.$search_city;

}

• 

  Sasho Valkanov

  March 25, 2012 at 21:02 pm

  did you add the second drop down above the table?

  • reply
  • report
  • (0)
  • (0)

Sorry about that. Should be able to download it fine now.

I'm so excited about this. However, I did the download and got and index.php file that has no code or anything with it. I tried to download again but I get the message "You can download 1 PHP script per day". I'm sure I did something wrong I just don't know what. Help!

the php index file appears empty
will try again

I'm unable download the "MySQL Table Search" script.