php - Why is sprintf returning false here? -
i trying work out why sprintf returning false here. can shed light?
sprintf( "select dog_name, date_format(meet_date, '%d %m %y') date, track_name, race_name, race_stakes, race_class, race_stakes, result_place, result_box, winner_name, winner_id, result_dog_trainer, race_distance dog join result using( dog_id ) join race r using( race_id ) join meet using( meet_id ) join track using( track_id ) join (select dog_name winner_name, dog_id winner_id, race_id dog join result using( dog_id ) result_place = 1 ) t0 on t0.race_id = r.race_id dog_id = %d order meet_date desc limit %d", 12345, 50);
you have few arguments. if use sprintf()
date_format
, should use 2 %
this:
sprintf( "select dog_name, date_format(meet_date, '%%d %%m %%y') date, track_name, race_name, race_stakes, race_class, race_stakes, result_place, result_box, winner_name, winner_id, result_dog_trainer, race_distance dog join result using( dog_id ) join race r using( race_id ) join meet using( meet_id ) join track using( track_id ) join (select dog_name winner_name, dog_id winner_id, race_id dog join result using( dog_id ) result_place = 1 ) t0 on t0.race_id = r.race_id dog_id = %d order meet_date desc limit %d", 12345, 50);
here's phpfiddle
Comments
Post a Comment