I have a set of dates (and times), which are returned from a mySQL query.
These usually span from 1-2 months and I need to be able to separate the results (using HTML) every sunday (monday being the start of the week).
Set of timestamps....
Code: [Select]1255482000
1255483800
1255485600
1255487400
1256086800
1256088600
1256090400
1256092200
1256691600
1256693400
1256695200
1256697000
1257300000
1257301800
1257303600
1257305400
1257904800
1257906600
1257908400
1257910200
1258509600
1258511400
1258513200
1258515000
1259114400
1259116200
1259118000
1259119800
Currently the code looks like this, but having trouble getting round the logic of doing this...
Code: [Select]<?php
while ($sqlresults = mysql_fetch_array($results)) {
$compare = strtotime(date('d F Y',$laststamp)." next Sunday");
echo $sqlresults['timestamp'].'
';
if ($sqlresults['timestamp'] != $laststamp) {
if ($compare > $laststamp) {
#HTML CODE
}
}
$laststamp = $sqlresults['timestamp'];
}
?>
But at the moment it just puts HTML code inbetween every time
gmdate() - want 1 hr before time
Hi,I am using php gmdate(). Now I am entering all dates in my dbase using gmdate("Y-m-d H:i:s")I want 1 hr before datetime.So am using like gmdate("Y-m-d H:i:s",
Open/Close Links in Php
Hello, Hoping someone can inform me how I can get PHP to automatically open a set of links in a new tabbed window.Example:$start= 1;$var = $start+1;$end = 5000;Website to open:
Table colours fail when extra row added
Hey Gurus,I got a weird problem with formating the colour of a table made in php. Everything works fine when i use 5 rows each row has an alturnative colour, but when i add the 6th row the colour
Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.However it ruins html and bbcode tags.. . I only want it to have affect on everything else within $text but not
SHOW TABLES Help
Hi allI have the followingCode: [Select]<?php$sql = "SHOW TABLES";$result = mysql_query($sql);while ($row = mysql_fetch_row($result)) { echo "Table:
Remove values in array2 from array1
I have two arrays.Array 1 is where the array key holds various different numbers. For example:Code: [Select]$array[32] = 1;$array[122] = 1;$array[238] = 1;$array[324] = 1;The other array holds values
search function
HI guys,if anyone could point us in the right direction of how to do this, or provide some test code for a similar problem would be great!Basically, I have user profiles on my site, and I have a
Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story short, im building a hockey stat tracking site for a local hockey league around here.my problem is, i
Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a switch function to reduce redundancies, and to efficaciously implement the script on to other
Checkbox info wont include in Mailto
Hey, im new to php.Basically I have made a form to request which type of job(s) are needed, which when filled will then be sent to an email address.The problem im having is that when more than 1
