Help with CI, PHP & Javscript

[eluser]boltsabre[/eluser]
No worries, you just have to get into the habit and mindset that when pulling info from the db to only retrieve what you need, and nothing else.

And with that in mind, if you're just checking for an instance of something in a table and there could be more than one, use a limit = 1 (or perhaps there is an active records thingie for it, I haven't checked) so that way once it has found a match, it stops there.

Consider this:

Code:

$check = this->model->checkForSubCat($id)
   if ($check->num_rows() > 0{
      ....
  }

And your model function checkForSubCat($id) has one of these two queries:

Code:

"SELECT id FROM yourtable WHERE subcategory = ."$id".";

Or...:

Code:

"SELECT id FROM yourtable WHERE subcategory = ."$id". LIMIT 1";

The first will check the entire table. Even if it finds a match in row 1, it will keep checking, and adding to the result it passes back (there may be a million matches!), all the way down to row 999,999,999,999,999 or however many rows you have in that table. The second, once it finds a match, exits straight away and only returns one row.

Anyway, good luck with it all!