پیام حیاتی
سه شنبه 05 مرداد 1395, 14:47 عصر
سلام عزیزان
مشکل این کوئری چیه :
$query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";
خطا :
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Taghvim-2\process.php on line 98
از این خط خطا میگیره (لاین 98) :
while($user=mysql_fetch_assoc($records))
مجموع کدها :
if (isset($_POST["submit3"])) {
$get_date3=$_POST["fdate3"];
$get_date4=$_POST["fdate4"];
echo ' <table border="1" >
<tr>
<th>Row</th>
<th>Persian Date</th>
<th>Milade Date</th>
</tr>
';
mysql_query('set names "utf8"');
$query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";
$records=mysql_query($query);
while($user=mysql_fetch_assoc($records))
{
echo '<tr>';
echo "<td>".$user['t_id']."</td>";
echo "<td>".$user['t_fdate']."</td>";
echo "<td>".$user['t_edate']."</td>";
echo "</tr>";
}
echo '</table>' ;
echo '<br />';
echo '<a href="index.php">Go back</a>';
}
else {
echo "Error in submit-3";
}
تشکر.
مشکل این کوئری چیه :
$query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";
خطا :
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Taghvim-2\process.php on line 98
از این خط خطا میگیره (لاین 98) :
while($user=mysql_fetch_assoc($records))
مجموع کدها :
if (isset($_POST["submit3"])) {
$get_date3=$_POST["fdate3"];
$get_date4=$_POST["fdate4"];
echo ' <table border="1" >
<tr>
<th>Row</th>
<th>Persian Date</th>
<th>Milade Date</th>
</tr>
';
mysql_query('set names "utf8"');
$query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";
$records=mysql_query($query);
while($user=mysql_fetch_assoc($records))
{
echo '<tr>';
echo "<td>".$user['t_id']."</td>";
echo "<td>".$user['t_fdate']."</td>";
echo "<td>".$user['t_edate']."</td>";
echo "</tr>";
}
echo '</table>' ;
echo '<br />';
echo '<a href="index.php">Go back</a>';
}
else {
echo "Error in submit-3";
}
تشکر.