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

pop3 and fsockopen
So I am able to connect to the pop3 server, log in, and check how many messages there are. I am hav

timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service