Latest Edition News Sitemap Articles Issues Graphics Forum Contacts Events Frames
History Submissions Subscriptions Editors Admin No Frames
Events Calendar
>
Error somthings wrong with your name I think " . mysql_error() . "

");} //echo $sql; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $password = $myrow['password']; $cid = $myrow['id']; $nametest = $myrow['name']; if (!isset($nametest) || $nametest=="") { $conf= "You must be registered in the contacts system to add an event"; $ok=false; $kid=1;} } if ($ok==true) //insert into Events Table { //insert into Comments Table if (isset($infotex)) { $sql = "INSERT INTO comments (title,infotex,comdate,contact_id,link) VALUES ('$title','$infotex','0000-00-00','$cid','$link')"; //if (mysql_query($sql) ) { echo("");}else { echo("

Error creating comment " . mysql_error() . "

");} } //echo $sql; // run SQL against the DB create message text $result = mysql_query($sql); $conf ="Added $title"; //echo $result; $sql="SELECT id , title FROM comments WHERE title ='$title'"; //echo $sql; //if (mysql_query($sql) ) { echo("");}else { echo("

Error re-reading the comments file " . mysql_error() . "

");} $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $comid = $myrow["id"]; //echo $comid; //$sql="UPDATE comments Set title = 'Calendar Event Added' WHERE id ='$comid' "; //echo $sql; //$result = mysql_query($sql); //echo $result; //if (mysql_query($sql) ) { echo("");}else { echo("

Error reading comment " . mysql_error() . "

");} //$comid = $myrow["id"]; $sql = "INSERT INTO events (title,date1,date2,comment_id) VALUES ('$title','$date1','$date2','$comid')"; //echo $sql; // run SQL against the DB create message text $result = mysql_query($sql,$db); //if (mysql_query($sql) ) { echo("");}else { echo("

Error creating event entry " . mysql_error() . "

");} //echo $sql; //echo $result; $conf ="Added $title"; } } $today =( date("Y-m-d") ); echo $today ; // List if Kid is Nowt Start with the MAIN SQL //echo $kid; if (!$kid) { $result = mysql_query(" SELECT events.id eid, events.title, events.date1, events.date2, events.comment_id, comments.link, comments.id, comments.infotex, comments.contact_id, contacts.id, contacts.name cname, contacts.password, contacts.email FROM events, comments, contacts WHERE (events.date1 > '$today') AND comments.id = events.comment_id AND contacts.id = comments.contact_id AND ( comments.infotex LIKE '%$search_str%' OR events.title LIKE '%$search_str%' ) ORDER BY events.date1 ASC ",$db); echo ""; echo ""; echo ""; echo ""; echo ""; while ( $row = mysql_fetch_array($result) ) { //REPEAT FOR EACH RECORD //assign variables $id = $row["eid"]; $title = $row["title"]; $date1 = $row["date1"]; $date2 = $row["date2"]; $cname = $row["cname"]; $password = $row["password"]; $link = $row["link"]; $email = $row["email"]; $infotex = $row["infotex"]; $comment_id = $row["comment_id"]; //PRINT EACH RECORD echo ("" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . ""); } //END OF LOOP FOR EACH RECORD echo("
$title$date1$date2
$infotex
$link email $cname
_____________________________
"); } else{ ?>
Event Title: the events calander may be searched for in the open events calander so include words that may be of interest such as action - climate - wto etc etc etc
Dates yyyy-mm-dd:
Your Name & Password:
Link to the web:
Event Details:
Latest Edition News Sitemap Articles Issues Graphics Forum Contacts Events Frames
History Submissions Subscriptions Editors Admin No Frames
This is a website from Travatools. Designing I.T. for Action