NeoAshura
asked on
help with error please php
hi experts, im trying to insert some data into the database but keep getting errors ive attached the code im trying to execute and it returns "ERROR" you can see why when it echo's it on fail.
any help is appricated in debugging it thanks again.
code is attached
any help is appricated in debugging it thanks again.
code is attached
<?php
session_start();
ob_start();
?>
<?php
error_reporting(E_ALL);
$last_spoke_to = $_POST['last_spoke_to'];
$notes = $_POST['notes'];
$val= $_REQUEST['val'];
var_dump($val);
var_dump($notes);
include 'myphp.php';
//update the database with the set variables recoverd from the form from the other page.
$query = "INSERT INTO `notes` (customer_name, notes) VALUES (".$val.",".$notes.");
$result=mysql_query($query);
if($result){
header("location:mobilenum.php?val=".$val);
}
else{
echo "ERROR";
}
mysql_close();
?>
data is sent from this form below
-----------------------------------
<form name="register" method="post" action="edituploadednotes.php">
<input type="hidden" value="<?php echo $_GET['val']; ?>" name="val" >
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="14" bgcolor="#ffffff"><strong>Edit Notes</strong></td>
</tr>
<tr>
<td width="249" bgcolor="#ffffff">Last spoke to</td>
<td width="7" bgcolor="#ffffff">:</td>
<td width="393" bgcolor="#ffffff"><textarea name="last_spoke_to" cols="40" rows="10">
Enter your last spoke to here....
</textarea>
<br /></td>
</tr>
<tr>
<td width="249" bgcolor="#ffffff">Notes</td>
<td width="7" bgcolor="#ffffff">:</td>
<td width="393" bgcolor="#ffffff"><textarea name="notes" cols="40" rows="10">
Enter your notes here....
</textarea>
<br /></td>
</tr>
<td wdith="1298" bgcolor="#ffffff">
<input type="submit" name="Submit" value="Update" /></td>
</tr>
</table></td>
</form>
ASKER
Hi there sadly
VALUES ("'".$val."','".$notes."'" );
is incorrect and is not correct syntax i tried to change the " and the ' but nothing worked.
VALUES ("'".$val."','".$notes."'"
is incorrect and is not correct syntax i tried to change the " and the ' but nothing worked.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok the insert works but when i try to query the database to get the output i get errors.
here is my query to try and get output stored in two tables.
can you help me please? im trying to extract all data from both tables. based on the variable passed.
$sql = "SELECT * FROM customer, notes WHERE customer_name = '" . $val . "'";
it says my query is ambiguous. any ideas?
here is my query to try and get output stored in two tables.
can you help me please? im trying to extract all data from both tables. based on the variable passed.
$sql = "SELECT * FROM customer, notes WHERE customer_name = '" . $val . "'";
it says my query is ambiguous. any ideas?
ASKER
Answered the bug error i was having.
Should be
VALUES ("'".$val."','".$notes."'"
And really should wrap Val and notes in mysqlrealescapestrig