Witam,
Mam taki problem, zapytanie które powinno aktualizować rekord nie aktualizuje go ani nie zwraca żadnego błędu.
Co może być przyczyną?
mysql_query("UPDATE ".dbprefix
."offerlist SET `StartDate`='2010-08-08 10:21:08',`EndDate`='2050-01-01 10:21:08',`OfferDay`='0', `mobile_ID`='".$_SESSION['offer'][$_offerID]['add']['mobilede_ID']."',`autosPicturesArray`='".addslashes($_SESSION['offer'][$_offerID]['add']['autos_pictures_array']) ."', `OfferType`='".$_SESSION['offer'][$_offerID]['add']['body_types']."',`Mark`='".$_SESSION['offer'][$_offerID]['add']['mark']."',
`Model`='".$_SESSION['offer'][$_offerID]['add']['model']."',`Category`='".$_SESSION['offer'][$_offerID]['add']['auto_type']."',
`Title`='".addslashes($_SESSION['offer'][$_offerID]['add']['title'])."',`Price`='".$_SESSION['offer'][$_offerID]['add']['price']."', `Currency`='".$_SESSION['offer'][$_offerID]['add']['currency']."',`EngineType`='".$_SESSION['offer'][$_offerID]['add']['petrol']."',
`EngineDesignation`='".$_SESSION['offer'][$_offerID]['add']['engine_designation']."',`EnginePower`='".$_SESSION['offer'][$_offerID]['add']['engine_power']."',
`EnginePowerUnit`='1',`EngineCapacity`='".$_SESSION['offer'][$_offerID]['add']['capacity']."',`Yearbook`='".$_SESSION['offer'][$_offerID]['add']['year']."',
`Mileage`='".$_SESSION['offer'][$_offerID]['add']['mileage']."',`VehicleCondition`='".$_SESSION['offer'][$_offerID]['add']['vehicle_condition']."',
`DoorsNumber`='".$_SESSION['offer'][$_offerID]['add']['doors_number']."',`Color`='".$_SESSION['offer'][$_offerID]['add']['body_color']."',
`ColorType`='".$_SESSION['offer'][$_offerID]['add']['color_type']."',`WhereIsVehicle`='".$_SESSION['offer'][$_offerID]['add']['where_is'] ."',
`SeatsNumber`='".$_SESSION['offer'][$_offerID]['add']['seats_number']."',`SportSeats`='".$_SESSION['offer'][$_offerID]['add']['sports_seats']."',
`GearsNumber`='".$_SESSION['offer'][$_offerID]['add']['gears_number']."',`Radio`='".$_SESSION['offer'][$_offerID]['add']['radio_type']."',
`RadioModel`='".$_SESSION['offer'][$_offerID]['add']['radio_marka_model']."',`ElectricWindows`='".$_SESSION['offer'][$_offerID]['add']['electric_windows'] ."',
`4x4`='".$_SESSION['offer'][$_offerID]['add']['x4x4']."',`Pneumatic`='".$_SESSION['offer'][$_offerID]['add']['pneumatic'] ."',
`ChildSeatsIsofix`='".$_SESSION['offer'][$_offerID]['add']['children_seats_isofix'] ."',`Quattro`='".$_SESSION['offer'][$_offerID]['add']['quattro']."',
`ABS`='".$_SESSION['offer'][$_offerID]['add']['ABS']."',`AirBags`='".$_SESSION['offer'][$_offerID]['add']['air_bag']."',
`CarAlarm`='".$_SESSION['offer'][$_offerID]['add']['alarm']."',`Wheels`='".$_SESSION['offer'][$_offerID]['add']['wheels']."',
`ASR`='".$_SESSION['offer'][$_offerID]['add']['ASR']."',`AutomaticGears`='".$_SESSION['offer'][$_offerID]['add']['automatic_transmission']."',
`AutomaticRearviewMirror`= '".$_SESSION['offer'][$_offerID]['add']['automatic_rear_view_mirrors']."',`CentralLocking`='".$_SESSION['offer'][$_offerID]['add']['central_locking']."',
`TintedGlass`='".$_SESSION['offer'][$_offerID]['add']['tinted_glass']."',`RainSensor`='".$_SESSION['offer'][$_offerID]['add']['rain_sensor']."',
`PartialSkin`='".$_SESSION['offer'][$_offerID]['add']['partial_skin']."',`ExtrasSkin`='".$_SESSION['offer'][$_offerID]['add']['addons_in_leather']."',
`ElectricMirrors`='".$_SESSION['offer'][$_offerID]['add']['electric_mirrors']."',`ElectricallyAdjustableSeats`='".$_SESSION['offer'][$_offerID]['add']['electrically_adjustable_seats']."',
`ESP`='".$_SESSION['offer'][$_offerID]['add']['esp']."',`Air-conditionedSeats`='".$_SESSION['offer'][$_offerID]['add']['air_conditioning_seats']."',
`HeatedSeats`='".$_SESSION['offer'][$_offerID]['add']['heated_seats']."',`SeatsWithMemory`='0',
`ChildSeats`='".$_SESSION['offer'][$_offerID]['add']['child_seats'] ."',`Warranty`= '".$_SESSION['offer'][$_offerID]['add']['guarantee']."',
`Hith`='".$_SESSION['offer'][$_offerID]['add']['hook']."',`Halogens`='".$_SESSION['offer'][$_offerID]['add']['halogens']."',
`TelephoneInstallation`='".$_SESSION['offer'][$_offerID]['add']['telephone_instalation']."',`Klimatronic`='".$_SESSION['offer'][$_offerID]['add']['klimatronic']."',
`AirConditioning`='".$_SESSION['offer'][$_offerID]['add']['air_conditioning'] ."',`On-boardComputer`='".$_SESSION['offer'][$_offerID]['add']['on_board_computer']."',
`ServiceBook`='".$_SESSION['offer'][$_offerID]['add']['service_book']."',`MultimediaSteeringWheel`='".$_SESSION['offer'][$_offerID]['add']['multimedia_steering']."',
`Multitronic`='".$_SESSION['offer'][$_offerID]['add']['multitronic']."',`Navigation`='".$_SESSION['offer'][$_offerID]['add']['navigation']."',
`EuroStandard`='0',`HeatedWindscreen`='".$_SESSION['offer'][$_offerID]['add']['heated_windshield']."',`AuxiliaryHeating`='".$_SESSION['offer'][$_offerID]['add']['auxiliary_heating']."',
`DoubleCab`='0',`Parktronic`='".$_SESSION['offer'][$_offerID]['add']['parctronic']."',`Pilot`='".$_SESSION['offer'][$_offerID]['add']['pilot']."',
`PneumaticSuspension`='".$_SESSION['offer'][$_offerID]['add']['pneumatic']."',`Rails`='".$_SESSION['offer'][$_offerID]['add']['railings']."',
`Skin`='".$_SESSION['offer'][$_offerID]['add']['leather']."',`Sunroof`='".$_SESSION['offer'][$_offerID]['add']['sunroof']."',
`ElectricSunroof`='".$_SESSION['offer'][$_offerID]['add']['electric_sunroof']."',`Immobilizer`='".$_SESSION['offer'][$_offerID]['add']['immobilizer']."',
`Tachograph`='0',`TCS`='".$_SESSION['offer'][$_offerID]['add']['TCS']."',`CruiseControl`='".$_SESSION['offer'][$_offerID]['add']['tempomat']."',
`Tiptronic`='".$_SESSION['offer'][$_offerID]['add']['tiptronic']."',`Velvet`='".$_SESSION['offer'][$_offerID]['add']['velvet']."',
`PowerSteering`='".$_SESSION['offer'][$_offerID]['add']['power_steering']."',`Xenons`='".$_SESSION['offer'][$_offerID]['add']['xenons']."',
`XenonsLight`='".$_SESSION['offer'][$_offerID]['add']['xenons_light']."',`WiperLights`='".$_SESSION['offer'][$_offerID]['add']['wiper_lights']."',
`AdditionalInformation`='".addslashes($_SESSION['offer'][$_offerID]['add']['additional_information'])."',`AdditionalContact`='".addslashes($_SESSION['offer'][$_offerID]['add']['dealer_id_list'])."', `ParticulateFilter`='".$_SESSION['offer'][$_offerID]['add']['particulate_filter']."',`HeatedOutsideMirrors`='".$_SESSION['offer'][$_offerID]['add']['heated_outside_mirrors']."',
`BluetoothTelephoneConnect`='".$_SESSION['offer'][$_offerID]['add']['bluetooth_telephone_connect']."',`VehicleDynamicControl`='".$_SESSION['offer'][$_offerID]['add']['vehicle_dynamic_control'] ."',
`FPS`='".$_SESSION['offer'][$_offerID]['add']['FPS']."',`USBinterface`='".$_SESSION['offer'][$_offerID]['add']['USB_interface']."',
`AluminiumFinish`='".$_SESSION['offer'][$_offerID]['add']['aluminium_finish']."',`LightSensor`='".$_SESSION['offer'][$_offerID]['add']['light_sensor']."',
`PowerBrakes`='".$_SESSION['offer'][$_offerID]['add']['power_brakes']."',`DSG`='".$_SESSION['offer'][$_offerID]['add']['DSG']."',
`Climatic`='".$_SESSION['offer'][$_offerID]['add']['climatic']."',`FinishInSkin`='".$_SESSION['offer'][$_offerID]['add']['finish_in_skin']."',
`4x2`='".$_SESSION['offer'][$_offerID]['add']['x4x2']."',`Kinetic`='".$_SESSION['offer'][$_offerID]['add']['kinetic']."',
`Serviced`='".$_SESSION['offer'][$_offerID]['add']['serviced']."',`SportSteering`='".$_SESSION['offer'][$_offerID]['add']['sport_steering']."',
`BiXenons`='".$_SESSION['offer'][$_offerID]['add']['bi_xenons']."',`LeatherSteeringWheel`='".$_SESSION['offer'][$_offerID]['add']['leather_steering_wheel']."',
`ChromeFinish`='".$_SESSION['offer'][$_offerID]['add']['chrome_finish']."',`GlassRoof`='".$_SESSION['offer'][$_offerID]['add']['glass_roof']."' WHERE `id` = '".$_SESSION['offer'][$_offerID]['add']['mysql_id']."'")