[Resolved] mysql ?

gunhoe86

i have a table called 'hits' with a column named for each page on my site. whenever a page loads, i'd like the script to get the number of 'hits' stored in the table for that page, add one to it, then replace the previous entry, so that i have a table with all the hits for each page. there's only 1 row in the table. here's what i have so far for the page called works2:

(all of the or dies are for debugging)

$query_hits = "select works2 from hits"
or die("error01"); 

$result_hits = mysql_query($query_hits)
or die("error02");  

$row_hits = mysql_fetch_row($result_hits);

echo ("$row_hits[0]")
or die("error07");

while ($row_hits = mysql_fetch_row($result_hits)) 
{ 
$new_row_hits = $row_hits[0]++
or die("error04");
$query_hits2 = "update hits set works2='$new_row_hits' where works2='$row_hits[0]'"
or die("error05"); 
$result_hits2 = mysql_query($query_hits2)
or die("error06"); 
} 
echo ("$new_row_hits")
or die("error08");

right now i'm getting error07 which is the echo("$row_hits[0]") line.

is this the right way to do this? any suggestions?

~JOSH

weekender

when you're embedding an array in a string, you have to put it in {}

echo ("{$row_hits[0]}")

this also goes for your sql UPDATE statement

$query_hits2 = "update hits set works2='$new_row_hits' where works2='{$row_hits[0]}'"

adam

gunhoe86

hhhhhmmmm....

i added the brackets, but i'm still getting the same error......

thanks for the help though.

redrabbit

you dont need any brackets to echo a variable/array.

echo $row_hits[2];

is fine.

gunhoe86

ya thats what i thought, but i'm still getting

error07

which is at the beginning of my code.

any ideas????

weekender

sounds to me like you're not returning any rows from the db

put in

echo mysql_num_rows($result) . " rows returned";

gunhoe86

i am returning one row....

i dont think the returned value is being is being incremented, its just returning it to the table with no increase.

is there any way to make sure the returned value is a number?

once again here is my code:

$query_hits = "select works2 from hits" 
or die("error01");  

$result_hits = mysql_query($query_hits) 
or die("error02");   


while ($row_hits = mysql_fetch_row($result_hits))  

{  

echo("just a test");
echo mysql_num_rows($result_hits) . " rows returned";

$new_row_hits = $row_hits[0]++ 
or die("error04"); 

$query_hits2 = "update hits set works2='$new_row_hits' where works2='$row_hits[0]'" 
or die("error05");  

$result_hits2 = mysql_query($query_hits2) 
or die("error06");  

}

thanks ~JOSH

gunhoe86

in case anyone is interested, here's the final code i ended up with:

$query_hits = "select contact2 from hits";


$result_hits = mysql_query($query_hits);   


while ($row_hits = mysql_fetch_assoc($result_hits))  

{  

$new_row_hits = $row_hits[contact2];
$new_row_hits++;


$query_hits2 = "update hits set contact2='$new_row_hits'";  

$result_hits2 = mysql_query($query_hits2); 
}

i changed

$new_row_hits = $row_hits[contact2]++

$new_row_hits = $row_hits[contact2];
$new_row_hits++;

and it worked.

~JOSH