insert and match query help, please

[paulmo]

attempting db connect, insert user text field ('message') values AND match 'message' values against 'terms' db field (keywords), then echoing matched terms field (from db table). am getting t-string errors; i know my multiple $query(ies) for one $result can't be right...help please? thank you!

 

<?php
mysql_connect("xxxx", "xxx", "xxx") or die(mysql_error()); 
mysql_select_db("xxx") or die(mysql_error()); 
$name = mysql_real_escape_string($_POST['name']);
$message = mysql_real_escape_string($_POST['message']);

mysql_query("INSERT INTO beta (name, message, created) VALUES ('$name', '$message', NOW()) ") or die(mysql_error());
$row_id = mysql_insert_id(); //Put it in a variable for later 
$query = mysql_query("SELECT terms FROM beta") WHERE MATCH (message) AGAINST ('terms' //table field);
$query  = "SELECT name, message FROM beta";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{
    echo "Name :{$row['name']} <br>" .
         "Message : {$row['message']} <br>";
"Terms: {$row{'terms']}<br>";
} 

?>

[ratcateme]

this line i am no pro at mysql but i can see this is wrong

$query = mysql_query("SELECT terms FROM beta") WHERE MATCH (message) AGAINST ('terms' //table field);

 

Scott.

 

[paulmo]

the //table field is a note for display purposes here only.

[Rushyo]

"the //table field is a note for display purposes here only. "

 

That is not the problem. The problem is your SQL query ends here:

 

mysql_query("SELECT terms FROM beta")

 

Anything else is not being executed as a query and will cause a parse error (except the obligatory ; in the latter case)

[paulmo]

i'm sorry, i'm not following your analysis. might you please show me the solution? thanks in advance.

[ratcateme]

i am not a mysql expert so i dont know how the query is meant to look but

$query = mysql_query("SELECT terms FROM beta") WHERE MATCH (message) AGAINST ('terms'3

is wrong see how only "SELECT terms FROM beta" is red that is because that is the only part of the line enclosed inside the ""

i am guessing it should look like

$query = mysql_query("SELECT terms FROM beta WHERE MATCH (message) AGAINST `terms`";

but then this is point less because the next line you overwrite this so any information gained from this query is lost when you go

$query  = "SELECT name, message FROM beta";

i am not sure what you want but if the second line is right then the first line is point less

 

Scott.

 

[paulmo]

I appreciate your input; I'll clarify: there is both an echo of name/message (user form) AND a match of 'message' against 'terms' table in database, which will be echoed. thanks for input 

[ratcateme]

insted of

$query = mysql_query("SELECT terms FROM beta") WHERE MATCH (message) AGAINST ('terms' //table field);
$query  = "SELECT name, message FROM beta";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

should it be

$query = "SELECT terms FROM beta WHERE MATCH (message) AGAINST `terms`";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

i don't really understand but would that work?

 

Scott.