gaan we dan geen vergelijking maken tussen een integer en een string? (ik kan ook fout zijn hoor, ben nog maar net bezig met php)
als ik dit in het script plaats krijg ik de volgende melding:
Fatal error: function name must be a string in c:xamp....
het volledig script ziet er ondertussen zo uit:
<?php
include 'DB_connect.php';
if (isset($_POST['submit'])){
//create a validation
$errors = array();
$required_fields= array('content', 'category_id');
foreach ($required_fields as $fieldname){
if(!isset($_POST[$fieldname]) || empty($_POST[$fieldname])){
$errors[] = fieldname;
}
}
//prep data for sql.. strip tags or other.. do some research on that?
global $connection;
if(empty($errors)){
$message = "the submission was a succes";
$content = strip_tags($_POST['content']);
$id = $_POST['catgory_id'];//this is wrong!!
$query = "INSERT INTO messages (content, category_id)
VALUES
('" . ($content) . "','" . ($id) . "')";
$result = mysql_query($query, $connection);
if (mysql_affected_rows()==1){
//succes
$message = 'the submission was a succes';
}else{
$message = 'there was a problem';
}
}
}//END!(isset($_POST['submit']))
if (!empty($message)){echo $message;}
echo "<div id=\"form\">";
echo "<form action=\"form2.php\" method=\"post\">";
echo " <p>";
echo "<input type=\"text\" size=\"100\" name=\"content\" value=\"\">";
echo " <select name=\"category\"\">";
// making the select box dynamic
$sql = "SELECT menu_name, id FROM categorys ";
$rs = mysql_query($sql);
if ($rs){ //everything is fine... proceed
while($row = mysql_fetch_assoc($rs)){
echo '<option';
// IS SELECTED
if($_POST($row['id']) == $_POST['category']){ //hier moet een juiste vergelijking komen!!!!
echo ' selected= \"selected\" value="'. $row['id'].'">'.$row['menu_name'].'</OPTION>';
}
//NOT SELECTED
echo' value="'. $row['id'].'">'.$row['menu_name'].'</OPTION>';
}
}else{//$rsfailed
$message = "the query failed";
}
//--------TESTER--------------------------------------------
//--------------------------------------------------------
echo " </select>";
echo "<input type=\"submit\" value=\"Submit quote\" name=\"submit\"/></p>";
