MySQL issue

Posted on 16th Feb 2014 07:03 pm by admin

I am taking sentences through a form on page. Then checking some condition and trying to insert them in database. I have issues while inserting...

foreach ($sentences as $final) {
......
else {
if(strlen($final) <= 120){
echo $final.'.<br />';}
else
echo substr($final,0,120). '.<br />';

//Inserting of final(sentences) in database starts
$sent = mysql_real_escape_string($_POST ['$final']);
$error= "Error while inserting, either User present or other. Please check database";
$inserted= "sentences inserted";
$result = mysql_query("SELECT sent FROM sentences WHERE sent='{$final}' ");
if($result)
{
$num = mysql_num_rows( $result );
if ($num == 0) {
$querypost = mysql_query ("INSERT INTO sentences (sent) VALUES ('$final')");
echo $inserted;
}
else echo $error;
}
}
}

Please correct my logic error.

Your Answer:

Login to answer

Other forums

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Asset Transfer from One plant to another within same company code
Hi,

Please advise how to transfer one asset from one plant to another plant within same c

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R

want a code for uploading and downloading
i m trying to upload and download to my site..i need upload and download code ...i use a code for up

Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..

Lets say you h

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall