search query

[eluser]Gavin Blair[/eluser]
There you go. If $_POST is empty, then num_rows will always give you the total number of records in your table. You'll have to change your query:

Code:

$query = $this->adminmodel->search_query('user', array('username' => $_POST['username'], 'password' => $_POST['password']));

Then, when $_POST is empty, your query will look like this:

Code:

SELECT * FROM user WHERE 'username' = '' AND 'password' = ''

...instead of this:

Code:

SELECT * FROM user WHERE '' = ''