imam veoma blesav problem sa skriptom
code je sledeci:
Code:
$query="select distinct
h1.PropertyName
, h1.Address1
, h1.City
, h1.StateCode
, h1.Postal
, h1.CountryCode
, h1.Latitude
, h1.Longitude
, h1.PropertyTypeID
, h1.NumFloors
, h1.NumRooms
, h1.YearBuilt
, h1.YearOfLastRenov
, h1.MobilStarRating
, h2.amenities
, h3.PropertyDescription
from
ta_propertyactive h1, ta_grouped_amenities h2, ta_propertydescription h3
where
h1.PropertyID = h2.PropertyID
and h1.PropertyID = h3.PropertyID
and h1.PropertyID = $id
";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$query="select distinct
h1.PropertyName
, h1.Address1
, h1.City
, h1.StateCode
, h1.Postal
, h1.CountryCode
, h1.Latitude
, h1.Longitude
, h1.PropertyTypeID
, h1.NumFloors
, h1.NumRooms
, h1.YearBuilt
, h1.YearOfLastRenov
, h1.MobilStarRating
, h2.amenities
, h3.PropertyDescription
from
ta_propertyactive h1, ta_grouped_amenities h2, ta_propertydescription h3
where
h1.PropertyID = h2.PropertyID
and h1.PropertyID = h3.PropertyID
and h1.PropertyID = $id
";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
kad odshtampam $query
i primenim ga u phpMyAdmin - da bash to shto trazim
kad stavim print ispred $result - da mi vrednost ResouceID #9
znachi - neshto ima
a $row je prazan
ne razumem gde je problem
jedan smeshni nekomercijalni video: http://www.develop-one.net/blog/2008/08/27/HugADeveloper.aspx