login  Naam:   Wachtwoord: 
Registreer je!
 Forum

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/wandelenmetannet.nl/httpdocs/Kalender/index php on line 41

Offline demingel - 20/08/2005 10:14
Avatar van demingelNieuw lid Hoi ik heb net een kalender geinstalleerd maar krijg de bovenstaande foutmelding.
onderstaande pagina is de index pagina waar de fout ergens in zit

php code - Bekijk de code zonder highlighting - Klap code in 
  1. Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/wandelenmetannet.nl/httpdocs/Kalender/index.php on line 41


php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  2. require_once("includes/config.php");
  3.  
  4. if(!isset($installed))
  5. {
  6. 	header("Location: install.php");
  8. }
  9. else
  10. {
  11. 	if(file_exists('install.php'))
  12. 	{
  13. 		header("Location: install.php");
  15. 	}
  16. }
  17.  
  18. $db_connection = mysql_connect ($DBHost, $DBUser, $DBPass) OR die (mysql_error());  
  19. $db_select = mysql_select_db ($DBName) or die (mysql_error());
  20. $db_table = $TBL_PR . "events";
  21.  
  22. function getmicrotime(){ 
  23.     list($usec, $sec) = explode(" ",microtime()); 
  24.     return ((float)$usec + (float)$sec); 
  25. } 
  26.  
  27. $time_start = getmicrotime();
  28.  
  29. IF(!isset($_GET['year'])){
  30.     $_GET['year'] = date("Y");
  31. }
  32. IF(!isset($_GET['month'])){
  33.     $_GET['month'] = date("n")+1;
  34. }
  35.  
  36. $month = addslashes($_GET['month'] - 1);
  37. $year = addslashes($_GET['year']);
  38.  
  39. $query = "SELECT event_id,event_title,event_day,event_time FROM $db_table WHERE event_month='$month' AND event_year='$year' ORDER BY event_time";
  40. $query_result = mysql_query ($query);
  41. while ($info = mysql_fetch_array($query_result))
  42. {
  43.     $day = $info['event_day'];
  44.     $event_id = $info['event_id'];
  45.     $events[$day][] = $info['event_id'];
  46.     $event_info[$event_id]['0'] = substr($info['event_title'], 0, 8);;
  47.     $event_info[$event_id]['1'] = $info['event_time'];
  48. }
  49.  
  50. $todays_date = date("j");
  51. $todays_month = date("n");
  52.  
  53. $days_in_month = date ("t", mktime(0,0,0,$_GET['month'],0,$_GET['year']));
  54. $first_day_of_month = date ("w", mktime(0,0,0,$_GET['month']-1,1,$_GET['year']));
  55. $first_day_of_month = $first_day_of_month + 1;
  56. $count_boxes = 0;
  57. $days_so_far = 0;
  58.  
  59. IF($_GET['month'] == 13){
  60.     $next_month = 2;
  61.     $next_year = $_GET['year'] + 1;
  62. } ELSE {
  63.     $next_month = $_GET['month'] + 1;
  64.     $next_year = $_GET['year'];
  65. }
  66.  
  67. IF($_GET['month'] == 2){
  68.     $prev_month = 13;
  69.     $prev_year = $_GET['year'] - 1;
  70. } ELSE {
  71.     $prev_month = $_GET['month'] - 1;
  72.     $prev_year = $_GET['year'];
  73. }
  74.  
  75.  
  76.  
  77. ?>
  78. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  79. <html>
  80. <head>
  81. <title>Wandelen met annet.nl</title>
  82. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  83. <link href="images/cal.css" rel="stylesheet" type="text/css">
  84. <script language="JavaScript" type="text/JavaScript">
  85. <!--
  86. function MM_jumpMenu(targ,selObj,restore){ //v3.0
  87.   eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  88.   if (restore) selObj.selectedIndex=0;
  89. }
  90. function MM_openBrWindow(theURL,winName,features) { //v2.0
  91.   window.open(theURL,winName,features);
  92. }
  93. //-->
  94. </script>
  95. </head>
  96.  
  97. <body>
  98. <div align="center"><span class="currentdate"><? echo date ("F Y", mktime(0,0,0,$_GET['month']-1,1,$_GET['year'])); ?></span><br>
  99.   <br>
  100. </div>
  101. <div align="center"><br>
  102.   <table width="700" border="0" cellspacing="0" cellpadding="0">
  103.     <tr> 
  104.       <td><div align="right"><a href="<? echo "index.php?month=$prev_month&amp;year=$prev_year"; ?>">&lt;&lt;</a></div></td>
  105.       <td width="200"><div align="center">
  106.  
  107.           <select name="month" id="month" onChange="MM_jumpMenu('parent',this,0)">
  108.             <?
  109. 			for ($i = 1; $i <= 12; $i++) {
  110. 				$link = $i+1;
  111. 				IF($_GET['month'] == $link){
  112. 					$selected = "selected";
  113. 				} ELSE {
  114. 					$selected = "";
  115. 				}
  116. 				echo "<option value=\"index.php?month=$link&amp;year=$_GET[year]\" $selected>" . date ("F", mktime(0,0,0,$i,1,$_GET['year'])) . "</option>\n";
  117. 			}
  118. 			?>
  119.           </select>
  120.           <select name="year" id="year" onChange="MM_jumpMenu('parent',this,0)">
  121. 		  <?
  122. 		  for ($i = 2000; $i <= 2010; $i++) {
  123. 		  	IF($i == $_GET['year']){
  124. 				$selected = "selected";
  125. 			} ELSE {
  126. 				$selected = "";
  127. 			}
  128. 		  	echo "<option value=\"index.php?month=$_GET[month]&amp;year=$i\" $selected>$i</option>\n";
  129. 		  }
  130. 		  ?>
  131.           </select>
  132.         </div></td>
  133.       <td><div align="left"><a href="<? echo "index.php?month=$next_month&amp;year=$next_year"; ?>">&gt;&gt;</a></div></td>
  134.     </tr>
  135.   </table>
  136.   <br>
  137. </div>
  138. <table width="700" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#000000">
  139.   <tr>
  140.     <td><table width="100%" border="0" cellpadding="0" cellspacing="1">
  141.         <tr class="topdays"> 
  142.           <td><div align="center">Zondag</div></td>
  143.           <td><div align="center">Maandag</div></td>
  144.           <td><div align="center">Dinsdag</div></td>
  145.           <td><div align="center">Woensdag</div></td>
  146.           <td><div align="center">Donderdag</div></td>
  147.           <td><div align="center">Vrijdag</div></td>
  148.           <td><div align="center">Zaterdag</div></td>
  149.         </tr>
  150. 		<tr valign="top" bgcolor="#FFFFFF"> 
  151. 		<?
  152. 		for ($i = 1; $i <= $first_day_of_month-1; $i++) {
  153. 			$days_so_far = $days_so_far + 1;
  154. 			$count_boxes = $count_boxes + 1;
  155. 			echo "<td width=\"100\" height=\"100\" class=\"beforedayboxes\"></td>\n";
  156. 		}
  157. 		for ($i = 1; $i <= $days_in_month; $i++) {
  158.    			$days_so_far = $days_so_far + 1;
  159.     			$count_boxes = $count_boxes + 1;
  160. 			IF($_GET['month'] == $todays_month+1){
  161. 				IF($i == $todays_date){
  162. 					$class = "highlighteddayboxes";
  163. 				} ELSE {
  164. 					$class = "dayboxes";
  165. 				}
  166. 			} ELSE {
  167. 				IF($i == 1){
  168. 					$class = "highlighteddayboxes";
  169. 				} ELSE {
  170. 					$class = "dayboxes";
  171. 				}
  172. 			}
  173. 			echo "<td width=\"100\" height=\"100\" class=\"$class\">\n";
  174. 			$link_month = $_GET['month'] - 1;
  175. 			echo "<div align=\"right\"><span class=\"toprightnumber\">\n<a href=\"javascript:MM_openBrWindow('event_add.php?day=$i&amp;month=$link_month&amp;year=$_GET[year]','','width=500,height=300');\">$i</a>&nbsp;</span></div>\n";
  176. 			IF(isset($events[$i])){
  177. 				echo "<div align=\"left\"><span class=\"eventinbox\">\n";
  178. 				while (list($key, $value) = each ($events[$i])) {
  179. 					echo "&nbsp;<a href=\"javascript:MM_openBrWindow('event.php?id=$value','','width=500,height=200');\">" . $event_info[$value]['1'] . " " . $event_info[$value]['0']  . "</a>\n<br>\n";
  180. 				}
  181. 				echo "</span></div>\n";
  182. 			}
  183. 			echo "</td>\n";
  184. 			IF(($count_boxes == 7) AND ($days_so_far != (($first_day_of_month-1) + $days_in_month))){
  185. 				$count_boxes = 0;
  186. 				echo "</TR><TR valign=\"top\">\n";
  187. 			}
  188. 		}
  189. 		$extra_boxes = 7 - $count_boxes;
  190. 		for ($i = 1; $i <= $extra_boxes; $i++) {
  191. 			echo "<td width=\"100\" height=\"100\" class=\"afterdayboxes\"></td>\n";
  192. 		}
  193. 		$time_end = getmicrotime();
  194. 		$time = round($time_end - $time_start, 3);
  195. 		?>
  196.         </tr>
  197.       </table></td>
  198.   </tr>
  199. </table>
  200. <p align="center"><span class="footer">&copy; 2005 
  201.     <a href="http://www.phpcalendars.com">PHPCalendars.com</a><br>
  202.     Script Execution Time: <? echo $time; ?></span><br><br>
  203.  
  204. </body>
  205. </html>

9 antwoorden

Gesponsorde links
Offline cracker - 20/08/2005 10:27
Avatar van cracker Onbekend een kolom ofzo bestaat niet.
voeg mysql_error() toe aan uw query.
php code - Bekijk de code zonder highlighting - Klap code in 
  1. $query = "SELECT event_id,event_title,event_day,event_time FROM $db_table WHERE event_month='$month' AND event_year='$year' ORDER BY event_time";
  2. $query_result = mysql_query ($query) or die(mysql_error());
Offline demingel - 20/08/2005 11:07 (laatste wijziging 20/08/2005 11:08)
Avatar van demingel Nieuw lid Dus onderstaand moet ik in regel 41 veranderen??


php code - Bekijk de code zonder highlighting - Klap code in 
  1. $query = "SELECT event_id,event_title,event_day,event_time FROM $db_table WHERE event_month='$month' AND event_year='$year' ORDER BY event_time";
  2. $query_result = mysql_query ($query) or die(mysql_error());


ik heb dit geprobeerd maar krijg dus een foutmelding
Citaat:
Unknown column 'event_id' in 'field list'
Offline cracker - 20/08/2005 11:10
Avatar van cracker Onbekend da's geen fout.
Da's de uitleg wat je moet doen om de fout te verwijderen.

PHP vindt geen kolom met de naam 'event_id' in de tabel.
Offline Rens - 20/08/2005 11:10
Avatar van Rens Gouden medaille

Crew algemeen		 Dan ben je in je SQL tabel vergeten om de kolom event_id aan te maken.

Unknown column = onbekende kolom
event_id in = <kolomnaam> in
field list = velden lijst
Offline demingel - 20/08/2005 11:19 (laatste wijziging 20/08/2005 11:24)
Avatar van demingel Nieuw lid ik hoefde volgende de installatie ook geen sql tabellen aan te maken
ik heb nu het volgende gedaan
ik heb alles van regel 40 t/m 42 verwijderd en nu heb ik dus geen foutmelding meer 

Maar als ik me dus nu inlog kan ik dus geen event toevoegen:?:
kon ik hiervoor ook al niet
Offline cracker - 20/08/2005 11:25 (laatste wijziging 20/08/2005 11:27)
Avatar van cracker Onbekend Het script verwijderen is geen oplossing ae 
geef eens de URL van die pagina.
Offline demingel - 20/08/2005 11:28
Avatar van demingel Nieuw lid http://www.wand...;year=2005
Offline cracker - 20/08/2005 11:32
Avatar van cracker Onbekend Ik vermoed dat al die fouten voortkomen uit uw mySQL versie of je hebt gewoon die scripts van phpcalendar.com verkeerd geïnstalleerd.
Offline demingel - 20/08/2005 11:34
Avatar van demingel Nieuw lid ik zal proberen om hem opnieuw te installeren.
in ieder geval bedankt voor de moeite
Gesponsorde links
Dit onderwerp is gesloten.
Actieve forumberichten
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.243s