This is not working

NZ_Kiwis

<?php
$i = "003"; 
if ($i < "628"){

echo "INSERT INTO `travel_photos` ( `id` , `photoname` , `trip_id` , `takenby` , `location` , `details` , `private` , `degrees` , `hits` , `date` , `front` ) VALUES ('', 'Picture$i.jpg', '11', '', '', '', '0', '0', '0', '0000-00-00', '');";

echo "<p>";
$i++;
};

?>

WHY???

YAOMK

Why are you enclosing integers in quotes like strings?

$i = "003";
if ($i < "628")

Also you don't need to use back-ticks around every column, they are meant to be used around sql reserved words such as "id".

NZ_Kiwis

Otherwise i becomes 3 and not 003... is there another ay around this?

YAOMK

checkout the manual for floating points.

NZ_Kiwis

I don't get it

YAOMK

why does it have to be 003? is it a fraction of a decimal?

NZ_Kiwis

No it's the current file name. i wish to keep it like this for several reasons but I want to remove the gap for other reasons. I take lots of photos and are sick of changing fir first 100 to just 1,2,3 etc.

YAOMK

Well in Javascript when one compares values with the greater/lower than operators the interpreter will try to convert said strings into numbers, I believe the same holds true in php, so when you compare $i < "628", $i becomes 3. Therefore a simple solution would be to come up with a different naming convention for your files.

laserlight

It works for me 😉

Anyway, just use something like [man]sprintf/man or [man]str_pad/man to format the number into a string of the required length.