TalkPHP - View Single Post

Tanax · 10-07-2007, 12:12 AM

PHP Code:


			
elseif($_POST['areaCode'] != ''){

                $szSQL = sprintf("SELECT `id` FROM `schools` WHERE `areaCode` LIKE '%%%d%%' ORDER BY `id`", $_POST['areaCode']);

                $iResult = $database->execute($szSQL);

                while($iRow = mysql_fetch_array($iResult, MYSQL_ASSOC)){

                    print_r($iRow);

                }

            }

Try that..

10-07-2007, 12:12 AM	#25 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	PHP Code: elseif($_POST['areaCode'] != ''){ $szSQL = sprintf("SELECT `id` FROM `schools` WHERE `areaCode` LIKE '%%%d%%' ORDER BY `id`", $_POST['areaCode']); $iResult = $database->execute($szSQL); while($iRow = mysql_fetch_array($iResult, MYSQL_ASSOC)){ print_r($iRow); } } Try that..