How do I insert specified time as a query?

[cherryst152]

while($i=01:00; $i<=01:10; $i++){
$query= "INSERT INSERT INTO $January_Ad1 (Day, Time) VALUES ('1','$i')";
$result= mysql_query($qu ery);
}

I want to insert 11 rows that say the Day is 1 and the time is incremented by 1 such that the time would read 01:00, 01:01, 01:02... 01:10.

[Markus]

while($i=01:00; $i<=01:10; $i++){
$query= "INSERT INSERT INTO $January_Ad1 (Day, Time) VALUES ('1','$i')";
$result= mysql_query($qu ery);
}

I want to insert 11 rows that say the Day is 1 and the time is incremented by 1 such that the time would read 01:00, 01:01, 01:02... 01:10.

What you are using there is incorrect.

i.e.
a while loop:
[php]
while($somethin g < $somethingElse) {
//execute code
}
[/php]
a FOR loop:
[php]
for($i = 1; $i < 100; $i++){
//eecute code
}
[/php]

[Markus]

After changing a few things i got the code to work :)
The revised code:
[php]
<?php
for($i='01:00'; $i<='01:10'; $i++){
#$query= "INSERT INSERT INTO $January_Ad1 (Day, Time) VALUES ('1','$i')";
echo $i."<br />";
}
?>
[/php]
1. I changed the loop to a FOR loop.
2. 01:00 is not a valid interger, so i wrapped it with single qoutes to change it into a string.
3. Echoed out the string to show it works.

-- just uncomment the query line (remove the #) and give it a run

:)

[cherryst152]

that worked very well and thanks for the fast response! only problem i am still having is getting it to insert into the database. it prints it out fine separately, but it's not being queried into the database even after i added in the line $result=mysql_q uery($query);

[cherryst152]

nvm, found that there were two inserts in the query.


thanks again though for the help!

[Markus]

nvm, found that there were two inserts in the query.


thanks again though for the help!

No problem my friend :)