Hi everyone!,
Everytime I run this script I get a parse error? Does anybody know why (I'm new to PHP, start learning it a week ago)
<?php
if(!isset($_POST['submit'])){
?>
<body>
Check off your web development skills:
<form name="skills" method="POST">
<table width="400" border="1">
<tr>
<td>
<input type="checkbox" name="skills[]" value="1">PHP
</td>
<td>
<input type="checkbox" name="skills[]" value="2">ASP
</td>
<td>
<input type="checkbox" name="skills[]" value="3">Perl
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="skills[]" value="4">JavaScript
</td>
<td>
<input type="checkbox" name="skills[]" value="5">JSP
</td>
<td>
<input type="checkbox" name="skills[]" value="6">Coldfusion
</td>
</tr>
<tr>
<td colspan="3" align="center">
<input name="submit" type="submit" value="Submit">
</td>
</tr>
</table>
</form>
</body>
<?php
if(!isset($_POST['submit'])){
}else{
if(!empty($_POST['skills'])){
$dbcnx = @mysql_connect(
"localhost", "root", "password");
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
}
if (! @mysql_select_db("checksearch") ) {
echo( "<P>Unable to locate the database at this time.</P>" );
exit();
}
$num_skills=sizeof($_POST['skills']);
$query='SELECT DISTINCT members.membername FROM members INNER JOIN lookup_skills ON members.id=lookup_skills.uid '
.'INNER JOIN const_skills ON lookup_skills.skill_id=const_skills.id WHERE const_skills.id IN(';
$query.=join(',',$_POST['skills']);
$query.=') ORDER BY members.membername';
echo$query. , '<br>';// just debugging...
$result=@($query,$con)ordie('Error in query: '.mysql_error());
$numrows=@mysql_num_rows($result);
if($numrows!=0){
while($row=mysql_fetch_assoc($result)){
echo$row['membername'].'<br>';
}
}else{
echo'Sorry, but no matches were found...<br>';
}
}else{
echo'You DO want to see some skills, don\'t you?<br>';
}}
?>
[/SIZE]
Greetz,
Kinob
