[fraggle]

I am trying to put a search count on a site. I have created a field to hold the count and then pull back result to display.
How can i increment the count each time a search is done?

All I am getting displayed now is resource id#12
My query is SELECT count FROM tablename

Thanks

[Eclipse]

I don't really work with SQL but this should work anyway, set it as a varialbe for example $count then:

PHP Code:

$count = $count++; 

Then write back to the db. Well hope that works for you.

[hardcoded]

UPDATE tablename SET count = count+1

This query assumes that your table has only one row...

EDIT: Oh, by the way Eclipse. The whole point of using the "++" operator is to avoid using assignations. Thus, it has more class to write "count++;". And though I never coded C, if I recall correctly, "count = count++" wouldn't even work, because the increment would happen AFTER the assignation. You would have to write "count = ++count;". But afterthought, I think that it doesn't matter because the ++ that happens after the assignation would make the count go up anyway. Well, all this to say that the "count = " part is completely useless.

[<?Wille?>]

Originally Posted by fraggle

I am trying to put a search count on a site. I have created a field to hold the count and then pull back result to display.
How can i increment the count each time a search is done?

All I am getting displayed now is resource id#12
My query is SELECT count FROM tablename

Thanks

the reson why your getting resource id#12 it that you probably just echo the query like

PHP Code:

$q = mysql_query("SELECT count from tablename");

echo $q; 

if you want to do something with the values you must fetch them like:

PHP Code:

$q = mysql_query("SELECT count from tablename");

while ($r = mysql_fetch_array) { # if you have only one row its possible to

echo $r['count']; # leave the while part and use only mysql_fetch_array

} 

hope it helps
Wille

[fraggle]

Getting closer now, I have one row to hold the count and the UPDATE is working fine, now all i get is ........

"has been searched $count times"

showing my variable name and not the result?

<?php
$count = mysql_query("SELECT count FROM stats",$dbh);
mysql_query("update stats SET count = count+1",$dbh);
?>
<?php
echo 'has been searched $count times.';
?>

It must be something simple, but Im missing it, please help...

[<?Wille?>]

Originally Posted by fraggle

Getting closer now, I have one row to hold the count and the UPDATE is working fine, now all i get is ........

"has been searched $count times"

showing my variable name and not the result?

<?php
$count = mysql_query("SELECT count FROM stats",$dbh);
mysql_query("update stats SET count = count+1",$dbh);
?>
<?php
echo 'has been searched $count times.';
?>

It must be something simple, but Im missing it, please help...

is this it?? or is there something your not showing us?? if this is it i doubt its updateing becourse the query is never run.. the reson why your getting "has been searched $count times." is becourse your useing single quotes even though your haveing vars inside the echo

heres how you do it:

PHP Code:

<?php

$count = mysql_query("SELECT count FROM stats",$dbh); 

$r = mysql_fetch_array($count); # assuming there is only one row in db

$q = mysql_query("update stats SET count = count+1",$dbh) or die(mysql_error());



// two ways to do

# 1

echo 'has been searched '.$r['count'].' times.';

#2

echo "has been searched $r[count] times.";

?>

[fraggle]

Thanks Willie

[fraggle]

Thanks Willie

"is this it?? or is there something your not showing us?? ," that was it and it is updating just not displaying

I used your last posted code and it's working!! cheers