note 43422 rejected from function.empty by betz
| From: | betz@php.net | Date: | Mon, 21 Jun 2004 06:56:05 +0000 |
| Subject: | note 43422 rejected from function.empty by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-71422@lists.php.net to get a copy of this message | ||
Note Submitter: aini@hpj.gov.my
----
How to repair this bug? I think something wrong in the mySQL part! Thanx..
$mangkuk = "SELECT id FROM ".SQL_PREFIX."events\n"
."WHERE eventtype = '$eventtype'\n"
."AND startdate = $startdate\n"
."AND starttime = '$starttime'\n";
$ion = $db->Execute($mangkuk);
if(!empty($mangkuk['events']))
{
$id = $db->GenID(SQL_PREFIX . 'sequence');
$query = "INSERT INTO $table\n"
."(id, uid, startdate, enddate, starttime, duration,"
." subject, description, eventtype, calendar)\n"
."VALUES ($id, '$uid', $startdate, $enddate,"
."'$starttime', '$duration', '$subject',"
."'$description', '$typeofevent', '$calendar_name')";
}
else
{
$row = $ion->FetchRow();
echo $row['eventtype'];
soft_error( 'The room has already been booked.');
}
}