");*/ $query = sub($QUERY_STRING, "%20"," "); $query = sub($query, "%22","\""); $query = sub($query, "_"," "); $query_array = split($query, "&"); $number = #$query_array; $record_no = $query_array[0]; $business_name = $query_array[1]; $business_name = sub($business_name, "|","&"); $business_type = $query_array[2]; $account_type_flag = $query_array[3]; $cuisine = $query_array[4]; $phone_no = $query_array[5]; $stno_name = $query_array[6]; $stno_name = sub($stno_name, "|","&"); $city_suburb = $query_array[7]; $state = $query_array[8]; $postcode = $query_array[9]; $db_query = "update take_away_restaurants set business_name='$business_name', business_type='$business_type', account_type_flag='$account_type_flag', cuisine='$cuisine', phone_no='$phone_no', stno_name='$stno_name', city_suburb='$city_suburb', state='$state', postcode='$postcode' where record_no=$record_no"; /*echo("

$db_query

");*/ if(msqlQuery($sock, $db_query ) < 0) { fatal("Error: $ERRMSG\n"); } /*echo("$record_no");*/ echo(""); } else { echo(""); echo(""); $query="select * from take_away_restaurants where cuisine='' and state='VIC'"; /* $query="select * from take_away_restaurants where cuisine=''";*/ if(msqlQuery($sock, $query ) < 0) { fatal("Error: $ERRMSG\n"); } $res = msqlStoreResult(); $counter = 0; if (msqlNumRows($res) < 1) { echo("

AGAIN NOTHING FOUND! CONTACT TECHNICAL HELP ON 0405104934 A.S.A.P.
$query

"); } else { $row = msqlFetchRow($res); while (#$row > 0) { echo(""); $row = msqlFetchRow($res); $counter++; } } echo("
No.Business nameBusiness TypeFlagCuisinePhone No.Street No. NameCity/SuburbStatePcode
"); msqlFreeResult($res); msqlClose($sock); /*echo("$query $row[0] $row[1]");*/ } >