Help with very small script. . .Thanks

Aliz__

Hey, first I will kinda explain what this script is supposed to do.

right now it is very small but im sure I will have to make it a little bigger to do what I want.
What I want it to do is this --
People will search for a keyword using our search engine. That keyword will then go into a mysql database. If it is the first time that term has been searched for it will get the value 1 in the quantity field. Each time it is searched for the value will go up.
I have another program that will display the top 5 terms searched which is working fine.

But this program is just supposed to add the search term to the database and keep upping the quantity by 1 each time it is searched for.
Right now the only thing this will do is add the search term to my database.

How can I get it to check the current value and up it by 1.
Thanks

<?
    $quantity = 1;
    mysql_connect("","l","");
    mysql_select_db("");
    $result=MYSQL_QUERY("INSERT INTO stats (word,quantity)".
    "VALUES ('$q', '$quantity')");
?>

I have placed this code in my search program and it will add the term fine. I can also get it to add the value 1 for the first time it is searched from the first line of the code above. But it always just stays 1 no matter how many times it is searched for. . .
Please help.

Thanks!

zylden

all you do is do a select in the table to see if the searched word is there... if it returns a result... take the quantity in a variable and add 1 and update the table... If it dusnt return a result insert it with a value of 1..

$mysql = "select 'word','quantity' from table where word='x'";
$result = mysql_query ($mysql, $conn) or die(mysql_error());
if ($newArray = mysql_fetch_array($result))
{
$newArray[1]++;
$mysql = "update table'........;
$result = mysql_query ($mysql, $conn) or die(mysql_error());
}
else
{
$mysql = "insert new in table'........;
$result = mysql_query ($mysql, $conn) or die(mysql_error());
}

Aliz__

thanks, I will try that. but what am I supposed to put where you said

$mysql = "update table'.........;

and

$mysql = insert new in table'........;

Thanks

tsinka

Hi,

do something like

$mysql = "SELECT word,quantity FROM table WHERE word='x'";
$result = mysql_query ($mysql, $conn) or die(mysql_error());

if (mysql_num_rows($result)) {
  $mysql = "UPDATE table SET quantity=quantity+1 WHERE word='x'";
  mysql_query($mysql,$conn);
} else {
  $mysql = "INSERT INTO table (word,quantity) VALUES ('x','1')";
  mysql_query($mysql,$conn);
}

Thomas

Aliz__

awesome. Thanks guys it is working EXACTLY how I want it to. Thanks for all the help. You have saved me a lot of time. 🙂