This topic is locked

search values count

3/20/2009 3:57:34 PM
PHPRunner General questions
D
danaci author

hi,
I'm find count from isletme table and showing to button.

before display events is no problem it's regular working.

global $conn;

$sorgu=("select count(u_tc_kimlik) from isletme");

$rs = db_query($sorgu,$conn);

$data = db_fetch_numarray($rs);

$sayac=$data[0];

echo "<input type=button class=button value=\" Toplam Kayıt Sayısı=$sayac\" \">";
My problem is,

if user is searching, how to I want count search values results?

thnx.

J
Jane 3/23/2009

Hi,
use Before SQL query event for this purpose:

$sorgu=("select count(u_tc_kimlik) from isletme where ".$strWhereClause);