[Textahead]

I need to search "visitornumber column" to find row thatr matches varible '$hits". when found input data from varible "$state" into "state column"

this is what I have sofar

$connect=mysql_connect("localhost", "*******","*******");
mysql_select_db("peoplecounter",$connect);

$sql = mysql_query("SELECT * FROM userslocation WHERE visitornumber='$hits'")or die(mysql_erorr());

$sql =mysql_query("INSERT INTO userslocation SET('$state', '', '', '')") ;




any help much appreciated

[de.monkeyz]

So what doesn't work so far? All I can see is that you've overwritten $sql with the insert statement.

[Textahead]

I dont understand what You mean by "overwritten sql" should I be doing this in an IF ELSE statement or something? when i look in my SQL_ADMIN the data Im trying to input is not there

[de.monkeyz]

You've made a variable called $sql in your code, and saving the result of the select statement (will be a mysql_resource). But right afterwards, you are saving the result of the update into it as well which will delete the select data result. As well as using a variable called state which does not exist.

If you wish to grab the state from the select statement you do:

PHP Code:

$connect=mysql_connect("localhost", "*******","*******"); 
mysql_select_db("peoplecounter",$connect);

$sql = mysql_query("SELECT * FROM userslocation WHERE visitornumber='$hits'")or die(mysql_erorr());

$res = mysql_fetch_assoc($sql);
$state = $res['state']; //state is the column name

$update =mysql_query("INSERT INTO userslocation SET('."mysql_real_escape_string($state)."', '', '', '')") ; 

[Textahead]

I understand now what you mean about redoing the $sql variable

ok ill explain it a different way.
i have table with 4 columns
STATE CATAGORY VISITORNUMBER PAGECOUNT

VISITORNUMBER is already set as=$hits
now i need to search VISITORNUMBER row until it finds $hits then ineed to put into STATE column results of varible $state

[de.monkeyz]

So you want to edit the row which has that hitcount?

[Textahead]

No I want to put new info into the state column

[de.monkeyz]

So what's the point of the select statement? As it seems to do nothing whatsoever. And inserting a row just to store data in one column is pretty pointless as well. You're gonna have to clarify what you want it to do exactly

[Textahead]

table with 4 columns
STATE CATAGORY VISITORNUMBER PAGECOUNT

Each new visitor is asigned a number IE: $hits
the visitor then clicks on a link with the $state varible embedded in it. I then need search VISITORNUMBER to find one that matches $hits and inputs the varible $state into the STATE column so I have a database record of Visitor number ($hits) and what link they clicked on ($state)

They will later click on a catagory link which will put into CATAGORY acording to thier $hits number ect ect so I can build up a profile of where they are and where they have been

they may also later click on link changing $state again so it will have to find thier $hits number again and change the STATE catagory to a new $state again.



i hope this explains it well enough

[Jcbones]

PHP Code:

<?php



//assign visitor number by his IP address

$visitor = $_SERVER['REMOTE_ADDR'];



$state = 'string';  //populate by a $_GET or $_POST



//build an UPDATE query

$query = "UPDATE `userslocation` SET `state`='$state' WHERE `visitornumber`='$visitor' ";



//execute query

mysql_query($query);





?>