Hello guys
i have big problem with this message
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/htdocs/www_kursova/test3.php on line 95
тhis is my source code
anybody can help to solved this problem Thanks
<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<?php
require("/var/www/htdocs/www_kursova/config/db_config.php");
$connection =mysql_connect($db_host, $db_user, $db_password ) or die ("ERROR CONNECTION") ;
mysql_select_db ($db_name, $connection);
$modelplane = $_POST["tip"];
$len = strlen($modelplane);
// only write to database if there`s a model of plane
if ($len > 0)
{
$passangers = $_POST["pasang"];
$takeofplace = $_POST["start"];
$landigplace = $_POST["end"];
$takeofdate = $_POST["dataStart"];
$takeofhour = $_POST["hourStart"];
$landighour = $_POST["hourEnd"];
$date = time();
$query = "INSERT INTO samolet (autoID, modelplane, passangers, takeofplace, landigplace, takeofdate, takeofhour, landighour, data_auto) VALUES (NULL, '$modelplane', '$passangers', '$takeofplace', '$landigplace', '$takeofdate', '$takeofhour', '$landighour', '$date')";
mysql_query($query, $connection) or die (mysql_error());
}
?>
<html>
<head>
<title> Samoleti </title>
<body>
<center>
<form action="<?php echo $_SERVER[PHP_SELF]; ?>" method="POST">
<font face="arial" size="3">
<p>Playn type:<input type="text" name="tip">
<br>
Pasangers:<input type="number" name="pasang">
<br>
START destination: <input type="text" name="start">
<br>
END Destination:<input type="text" name="end">
<br>
Take off date:<select name="dataStart" style="width: 100">
<option value="2010-02-05">2010-02-05</option>
<option value="2010-02-09">2010-02-09</option>
<option value="2010-02-15">2010-02-15</option>
<option value="2010-02-23">2010-02-23</option>
<option value="2010-02-28">2010-02-28</option>
<option value="2010-03-08">2010-03-08"</option>
<option value="2010-03-15">2010-03-15</option>
<option value="2010-03-23">2010-03-23</option>
</select>
<br>
take off hour:
<select name="hourStart" style="width: 100">
<option value="6:20:00">6:20h</option>
<option value="10:30:00">10:30h</option>
<option value="12:00:00">12:00h</option>
<option value="14:05:00">14:05h</option>
<option value="17:20:00">17:20h</option>
<option value="20:30:00">20:30h</option>
<option value="22:00:00">22:00h</option>
<option value="23:30:00">23:30h</option>
</select>
<br>
landing hour:
<select name="hourEnd" style="width: 100">
<option value="3:00:00">3:00h</option>
<option value="6:00:00">6:00h</option>
<option value="8:20:00">8:20h</option>
<option value="14:00:00">14:00h</option>
<option value="18:30:00">18:30h</option>
<option value="20:20:00">20:20h</option>
<option value="22:10:00">22:10h</option>
<option value="23:50:00">23:50h</option>
</select>
<br>
<input type="submit" value="submit">
</p>
<p> </p>
</font>
</form>
<table bgcolor ="#AAAAAA" border="0" width="75%" cellspacing="1" cellpading="2">
<?php
$query = "SELECT * FROM samolet ORDER BY date_auto";
$result = mysql_query($query, $connection);
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
$modelplane = mysql_result($result, $i, "modelplane");
$passangers = mysql_result($result, $i, "modelplane");
$takeofplace = mysql_result($result, $i, "modelplane");
$takeofplace = strlen ($takeofplace);
$landigplace = mysql_result($result, $i, "modelplane");
$takeofdate = mysql_result($result, $i, "modelplane");
$takeofhour = mysql_result($result, $i, "modelplane");
$landinghour = mysql_result($result, $i, "modelplane");
$date = mysql_result ($result, $i , "date");
$show_date = date("H:i:s /m/d/y", $date);
echo
<tr>
<td width="50%" bgcolor="#EEEEEE">
<font face="arial" size="5">';
if ($takeofplace > 0)
{
echo '<b>Plane Name:</b> <a href="mailto:'.$landingplace.'>"'.$modelplane.'</a>';
}
else
{
echo '<b>Plane Name:</b>' .$modelplane;
}
echo '
<br>
<b>Pasangers:</b> '.$passangers.
'
<br>
<b>Plane take of From:</b>' . $takeofplace.
'
<br>
<b>Plane lands</b>' .$landigplace.
'
<br>
<b>Date / Take off:</b>' .$takeofdate.
'
<br>
<b>Hour / Take off:</b>' .$takeofhour.
'
<br>
<b>Hour of Landing</b>' . $landinghour.'
</font>
<td>
<td width="1%" valigh="top" nowrap bgcolor="EEEEEE">
<font>
<bg>date:</bg> '.$show_date.'
</font>
</td>
</tr>
';
}
?>
</table>
</center>
</body>
</head>
</html>
