Hi all, I am new here, I am a newbie to php as well. I am writing a small stuff but got some problems. Can you help me please. this is the form page [a href=\"http://www.haivenu-vietnam.com/test_script/show_referees.htm\" target=\"_blank\"]http://www.haivenu-vietnam.com/test_script/show_referees.htm[/a] , when visitor choose 3 boxes (I will make visitor only can choose 3 boxes only) it will lead to the [a href=\"http://www.haivenu-vietnam.com/test_script/result.htm\" target=\"_blank\"]result page [/a] ([i]I make it, infact it's not automatically generated from database[/i]) and this is the database: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]CREATE TABLE `referees` ( `id` int(10) unsigned NOT NULL auto_increment, `number` int(3) NOT NULL default '0', `name` text NOT NULL, `telephone` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `referees` -- INSERT INTO `referees` VALUES (1, 0, 'Thanh Nguyen', 915678976); INSERT INTO `referees` VALUES (2, 0, 'Haivenu', 9272917); INSERT INTO `referees` VALUES (3, 0, 'Nguyen Tat Thanh', 912853450); INSERT INTO `referees` VALUES (4, 0, 'thanh nguyen', 34683402); [/quote] And this is the process file: [code]<?php $link = mysql_connect('localhost', 'xxxxx', 'ixxxxx'); mysql_select_db('haivenu_xxxx') or die(mysql_error().' : '.mysql_error()); if (!$link) { die('Could not connect: ' . mysql_error()); } //query details table begins SELECT * FROM articles $query = "select * from visitors WHERE Name like `%$search%`"; //for($i=0;$i<=20;$i++)if(isset($_POST["number"][$i])) $query = mysql_query("select * from referees where number=".$_POST["number"]." "); //$query = mysql_query("select number from referees order by id DESC LIMIT 10"); while ($row = @mysql_fetch_array($query)) { $variable1=$row["number"]; $variable2=$row["name"]; $variable3=$row["telephone"]; //table layout for results print ("$variable1</br>"); print ("$variable2</br>"); print ("$variable3</br>"); } mysql_close($link); ?> [/code] Can you please check the process file and the form file and if you don't mind please post you solution here. I highly appreciate your help, indeed. Thanks in advance. Thanh Nguyen