{
$site_database_name = “norwalk_jcms”;
$site_database_server = “norwalkc.accountsupportmysql.com”;
$site_database_username = “norwalk_jcms”;
$site_database_password = “&Admin123*”;
$conn = mysql_connect(“$site_database_server”, “$site_database_username”, “$site_database_password”);
mysql_select_db(“$site_database_name”);
if (!$conn) {
echo “Unable to connect to DB: ” . mysql_error();
exit;
}
if (!mysql_select_db(“$site_database_name”)) {
echo “Unable to select dbname: ” . mysql_error();
exit;
}
return $conn;
}
function sql_select()
{
global $section;
$conn = connect();
$sql = “select cms_properties.pid,
cms_properties.section,
cms_properties.prop_name,
cms_properties.date,
cms_properties.add_by,
cms_properties.modified,
cms_properties.modified_by,
cms_properties.type,
cms_properties.address,
cms_properties.city,
cms_properties.state,
cms_properties.zip,
cms_properties.manager,
cms_properties.phone,
cms_properties.gmap,
cms_properties.fax,
cms_properties.title,
cms_properties.city_department,
cms_properties.roof,
cms_properties.sdescription,
cms_properties.description,
cms_properties.ammenities,
cms_properties.status,
cms_properties.feature,
cms_properties.contact_email,
cms_properties.built,
cms_properties.maintenance,
cms_properties.handicap,
cms_properties.ac,
cms_properties.breakdown,
cms_properties.flood_zone,
cms_properties.units,
cms_properties.stories,
cms_properties.contact_name,
cms_properties.neighborhood,
cms_properties.pets,
cms_properties.buildings,
cms_properties.vacation_rental,
cms_properties.main_website,
cms_properties.img1_title,
cms_properties.img1,
cms_properties.img2_title,
cms_properties.img2,
cms_properties.img3_title,
cms_properties.img3,
cms_properties.img4_title,
cms_properties.img4,
cms_properties.img5_title,
cms_properties.img5,
cms_properties.img6_title,
cms_properties.img6,
cms_properties.img7_title,
cms_properties.img7,
cms_properties.img8_title,
cms_properties.img8,
cms_properties.img9_title,
cms_properties.img9,
cms_properties.img10_title,
cms_properties.img10,
cms_properties.img11_title,
cms_properties.img11,
cms_properties.img12_title,
cms_properties.img12,
cms_properties.img13_title,
cms_properties.img13,
cms_properties.img14_title,
cms_properties.img14,
cms_properties.img15_title,
cms_properties.img15,
cms_properties.img16_title,
cms_properties.img16,
cms_properties.img17_title,
cms_properties.img17,
cms_properties.img18_title,
cms_properties.img18,
cms_properties.img19_title,
cms_properties.img19,
cms_properties.img20_title,
cms_properties.img20
from cms_properties
where cms_properties.pid = $_GET[pid];
” ;
//echo $sql;
$res = mysql_query($sql, $conn) or die(mysql_error());
return $res;
}
$conn = connect();
$res = sql_select();
print “
“.stripslashes($row[‘prop_name’]).” |
| “.stripslashes($row[‘address’]).” “.stripslashes($row[‘city’]).”, “.stripslashes($row[‘state’]).” “.stripslashes($row[‘zip’]).” “.stripslashes($row[‘main_website’]).” |
| Contact: “.stripslashes($row[‘contact_name’]).” – “.stripslashes($row[‘contact_email’]).” |
|
“.stripslashes($row[‘description’]).” |
\n”;
mysql_free_result($res);
[/insert_php]