Picture
";*/ } function process_form() { $username=trim($_POST['username']); $pass=trim($_POST['pass']); $sha_pass=sha1($pass); $db=mysql_connect('localhost:6033','sla','amobea'); $query="SELECT * FROM sla.users WHERE username='$username' AND password = '$sha_pass'"; $result=mysql_query($query); $error=mysql_error(); if($error) { return "Sorry: $query gives an error
$error"; } $affected=mysql_affected_rows(); if(! ($affected)) { return "Invalid username or password"; } } if($_POST['submitted']) { $error=process_form(); if($error) { show_form($error); } else { $user=$_POST['username']; print "

Welcome $user

"; } } else { show_form(''); } ?>
-1 {} else { $SelectedValue = str_replace(" ", ", ", $SelectedValue); } */ if(!$submit) { print "
\n"; include("form.html"); include("form2_search_tips.html"); print "
"; } else { $link=mysql_connect('localhost:6033','sla','amobea'); mysql_select_db('sla'); if(!$link) { print "Can't connect to localhost. The error is
"; print mysql_connect_error(); print"
"; } $error=mysql_error(); if ($error) { print "mySQL error: $error
\n" ; } $field=strtolower($Field); $query="SELECT * FROM sermons WHERE $Field REGEXP '$SelectedValue' ORDER BY $Field ASC"; $result=mysql_query($query); $error=mysql_error(); #if($error) { print "query $query lead to error $error"; #} print '
'; print ''; $Data = ''; $Data = $Data.''; $HasResults = 0; While($count=mysql_fetch_array($result)) { $HasResults = $HasResults + 1; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; } if($HasResults == 0) { print ''; } else { print $Data; } print '
datedayspeakerTitle
 '.$count['date'].' '.$count['day'].' '.$count['speaker'].' '.$count['title'].'
Sorry, no match found.
'; print '
'; print "Go Back"; } ?>

\"Valid