Result returns same time for each query

[[deleted]]

I have created a five day events calendar and I query my database for each day to find events for each day.

I used the below query and code to display the eventtime,eventtitle:

$result = mysql_query ("SELECT eventtitle,eventtime FROM crc1.events WHERE eventdate = '$day2_date'");
					if (mysql_num_rows($result)>0){
						while ($row = mysql_fetch_array($result)){
							echo date('g:i A',$row['eventtime']);echo $space;echo $space; echo $space;echo $row['eventtitle'];
							echo '<br/>';
						}//end while
					}else{
						echo '';
					}//end if

My problem is that no matter what eventtime is set to in the db the eventtime that displays on my page is 7:00 PM.

I have no idea what's going on here. Any thoughts on this problem?

[tekky]

$result = mysql_query ("SELECT eventtitle,eventtime FROM crc1.events WHERE eventdate = '$day2_date'");
					if (mysql_num_rows($result)>0){
						while ($row = mysql_fetch_array($result)){
							echo date('g:i A',$row['eventtime']).str_repeat($space,3).$row['eventtitle'];
							echo '<br/>';
						}//end while
					}else{
						echo '';
					}//end if

what type of field is eventtime?

and I cleaned up your current code a bit, it had some redundancies 😉

[[deleted]]

Time.

Thanks for cleaning up my code.

[tekky]

if its a time field then you need to do this before your date() function

list($hr, $min, $sec) = explode(":", $row['eventtime']);
echo date('g:i A',mktime($hr, $min, $sec, 8, 10, 2003)).str_repeat($space,3).$row['eventtitle']; //date() requires a unixtimestamp which mktime(hr, min, sec, month, day, year) provides to produce a time that you want, rather than the current time

note: you can prolly leave the month,day,year as 0,0,0 but just to be safe, I put todays date, it wont affect the return at all (or shouldnt I wouldnt think)

ps. OR you could just do some simple formatting on the time field to get the same result...