Having trouble with a Mysql query

[swatmo]

I admit I have no idea what im doing...

 

I need to increment a field in a Mysql table based on matching another field. Here is my code.

 

		$increment_count = 'UPDATE '.$this->tablename.' SET count = count + 1 Where confirmcode = '."$referid";  


	if(!mysql_query($increment_count , $this->connection))
	{
		echo 'TRIED AND FAILED AGAIN AND AGAIN';
	}

 

when I echo $increment_count i get:

UPDATE emailtab SET count = count + 1 Where confirmcode = 48032da2db11eff6a851f0c3279424fd

 

I am not sure what is wrong here. My other queries are working fine. Please help.

[fugix]

so what exactly is wrong here..your echo looks like everything is working fine

[swatmo]

Nothing changes all the count fields just sit at 0 and do not increment. Every time i run it it makes the attempt and the gives the error statement.... I have no idea why this wont work. It is probably something really simple that I am overlooking... but its been like 3 hours on this issue, and im about to rip my eyes out of my ears.

[PFMaBiSmAd]

The 48032da.... value is a string and must be enclosed by single-quotes in the query statement.

 

 

[fugix]

PFM is right, try this

$increment_count = "UPDATE $this->tablename SET count = count + 1 Where confirmcode = '$referid'";

 

[swatmo]

Thank you SO much... i know i know im dumb... but thanks so much for taking the time time to help me out... you saved my eyes, and my ears

[swatmo]

yes that totally worked... thanks again guys... how to i mark this as solved and give credit where its due on this site ?

[fugix]

there is a button in the bottom left hand of this page.