i have 2 error, help me please

peter_kung · November 16th, 2009, 01:06 PM

hi i new on this codeigniter so i still dont know what the problem of this error
so help me to resolve it please, thank

A PHP Error was encountered

Severity: Notice

Message: Undefined index: id

Filename: controllers/welcome.php

Line Number: 15

for the database

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `status` = 'active' ORDER BY `category_id` asc LIMIT 100' at line 4

SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `id` != AND `status` = 'active' ORDER BY `category_id` asc LIMIT 100

myerman · November 17th, 2009, 12:45 PM

Okay, here's the function in the Welcome controller:

Code:

  function index(){	
  	$this->output->cache(30);
	$data['title'] = "Welcome to Claudia's Kids";
	$data['navlist'] = $this->MCats->getCategoriesNav();
	$data['mainf'] = $this->MProducts->getMainFeature();
	$skip = $data['mainf']['id'];
	$data['sidef'] = $this->MProducts->getRandomProducts(3,$skip);
	$data['main'] = 'home';
	$this->load->vars($data);
	$this->load->view('template');
  }

It appears that the $this->MProducts->getMainFeature() function isn't returning a value. Which means that the products db table is empty.

This probably means that you've jumped ahead :) and are looking at the code before you go through the book. That's okay. Just enter a product into the database table using PHPMYADMIN, it can be anything you want.

peter_kung · November 17th, 2009, 01:03 PM

it's work, thank you, i thought just simply create the database only, and i didnt insert any data on it,