Member Avatar for anony 
function gethotproperty($hot){
        $gethot = "select p.reference_id, p.area, p.area_unit, p.transaction_type,p.property_type,p.property_name,p.address1,p.address2,p.city,p.locality,p.pincode,p.area_in_sqft,p.total_price,p.negotiable,".
                        "p.rate_per_sqft,p.num_bedrooms,p.floor_number,p.intro_image_loc,p.amenities_detail, p.specification_detail, p.location_detail from " . DBConf::getDatabaseSchema() . "property p where p.hot = ".$hot;
        $result = mysql_query($gethot, $this->connection);

        $property = new Property();


        while($row = mysql_fetch_array($result)){
            $property->referenceId = $row['reference_id'];
            $property->transactionType = $row['transaction_type'];
            $property->propertyType = $row['property_type'];
            $property->propertyName = $row['property_name'];
            $property->address1 = $row['address1'];
            $property->address2 = $row['address2'];
            $property->city = $row['city'];
            $property->locality = $row['locality'];
            $property->pinCode = $row['pincode'];
            $property->areaInSqFt = $row['area_in_sqft'];
            $property->area = $row['area'];
            $property->areaUnit = $row['area_unit'];
            $property->totalPrice = $row['total_price'];
            $property->isNegotiable = $row['negotiable'];
            $property->ratePerSqFt = $row['rate_per_sqft'];
            $property->numberOfBedrooms = $row['num_bedrooms'];
            $property->floorNumber = $row['floor_number'];
            $property->amenities = $row['amenities_detail'];
            $property->introImageLocation = $row['intro_image_loc'];
            $property->specificationDetails = $row['specification_detail'];
            $property->locationDetails = $row['location_detail'];

        }
        return $property;
    }

what is wrong with this script.keep getting an error:

mysql_fetch_array(): supplied argument is not a valid MySQL result resource.
Edited by mike_2000_17 because: Fixed formatting
  • 3 Contributors
  • 4 Replies
  • 181 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by rajarajan2017
Member Avatar for pritaeas

Looks like an error in your query. Change

$result = mysql_query($gethot, $this->connection);

into

$result = mysql_query($gethot, $this->connection) or die(mysql_error());

to check if I'm right.

Member Avatar for rajarajan2017

DB name in the config.php may be wrong.
May be a spelling Mistakes in sql statments

Member Avatar for anony

yes you were right. Thank you so much. it is solved.No error but not displaying anything.

Edited by anony because: n/a
Member Avatar for rajarajan2017

Mark the thread solved! if it solved

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.