Public feed #379695

Mine

public text v1 · immutable
Raw Edit
·published 2007-03-03 12:55 UTC
rendered paste body
					if ( ($city = trim($_POST["city"])) != "" )
					{
						if ( $getCity = @mssql_init("sp_getCity") )
						{
							mssql_bind( $getCity , "@city" , $city , SQLVARCHAR ); mssql_bind( $getCity , "@idState" , $_POST["idState"] , SQLINT2 );
							
							if ( $rsCity = @mssql_execute($getCity) )
							{
								var_dump($rsCity);
								// echo mssql_num_rows($rsCity) .", ". $idState .", '". $city ."'<br />";
								$row = mssql_fetch_array($rsCity);
								mssql_bind( $updateUser , "@idCity" , $row[0] , SQLINT2 );
							} else
								$status_msg .= "<p class=\"error\">Could not modify CITY.<br />". mssql_get_last_message() ."</p>";
						}
					}