Results from Db outputted twice


Posted on 16th Feb 2014 07:03 pm by admin

Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out why.



Code: [Select]<html>
<head>
<title>Month Summary</title>

<!-- change styles if you want -->
<style type="text/css">
p {font-family: georgia, verdana, sans-serif; font-size: 13px; color: #333333; }
h1 {font-family: georgia, verdana, sans-serif; font-size: 16px; color: #26618e; }
body {background-color: #fcfcfc;}
</style>
</head>
<body>
<br/>

<?php

// THERE IS NO NEED TO EDIT BELOW HERE

$mon = $_GET['mon']; // month from clicked month name
$month = intval($mon); // var to use with month name array
if (strlen($mon)==1) { $mon = "0". $mon; }
$yr = $_GET['yr']; // year from clicked month name

include("cal_parms.php");
include("./lang/dat_nam_en.php"); // load default language file so as not to mess anything upp with new text.
include($dat_names); // retrieved from cal_parms.php as a 'language' file
include("cal_db_conn.php");
mysql_connect($db_host, $db_login, $db_pass) or die ("Can't connect!");
mysql_select_db($db_name) or die ("Can't open database!");

$min_dat = $yr. "-". $mon. "-01";
$max_dat = $yr. "-". $mon. "-31"; //sloppy but effective

// retrieve all events for the month
$query = "SELECT * from $db_table WHERE (ev_dat>='$min_dat') AND (ev_dat<='$max_dat') ORDER by ev_dat";
$result = @mysql_db_query($db_name, $query);
echo "<table width='480' cellpadding='3' cellspacing='3' align='center' style='border: thin dotted #999999;' bgcolor='#f7f7f7'><tr><td>";

while ($myrow = mysql_fetch_array($result)) // loop through all results
{
$found = $myrow['ev_dat'];
$pieces = explode("-", $found);
$monum = intval($pieces[1]);
$danum = intval($pieces[2]);
echo "<h1>". $danum. " ". $mo[$month]. ", ". $yr. "</h1>";
echo "<p><strong>". $EventText. ":&nbsp;". $myrow['ev_title']. "</strong><br/>";
echo $LocationText. ": &nbsp;". $myrow['ev_locn']. "<br/>";
echo $DetailsText. "<br/>". nl2br($myrow['ev_desc']). "</p>";
$i++;
}
if ($i==0) { echo "<h1>".$noEventsText." ". $mo[$month]. "</h1>"; }
if ($sho == "1") {
echo "<p align='right'><a href='javascript:self.close()'>".$closewindowText ."</a>";
}
else {
echo "<p align='right'>&laquo;&nbsp;<a href='javascript:history.go(-1)'>".$backToCalendar."</a></p>";
}
?>
</td></tr></table>
</html>
</body>
hopefully someone can see the reason why

Thanks

No comments posted yet

Your Answer:

Login to answer
312 Like 42 Dislike
Previous forums Next forums
Other forums

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

cURL Sending File as Post
This is a bit complicated, I'm just hoping someone else has run into this and knows how to do it a d

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

modifying a property of an object from a different class
I have 2 classes:
- Math
- Distance

in my math class, I have this line:
$distance =

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

ereg_replace()
Basically what i need to do is

$title = "This Suck's"

$striped = ereg_repl

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Help with PHP Calendar code...
Hello, I'm new to this forum and I'm glad I found it.
I wrote this code for a PHP calendar as an

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash