Welcome Guest, Not a member yet? Register   Sign In
new user help
#3

[eluser]Pascal Kriete[/eluser]
I don't really know how to do it with adodb (have you tried ActiveRecord?).

For a normal sql query I would do:
Code:
$sql = "SELECT article.headline, article.description, category.name
FROM article, category
WHERE article.category_id = category.category_id";

Or using ActiveRecord:
Code:
$this->db->select(article.headline, article.description, category.name);
$this->db->from('article, category');
$this->db->where("article.category_id = category.category_id");
$query = $this->db->get();


Messages In This Thread
new user help - by El Forum - 04-16-2008, 06:49 PM
new user help - by El Forum - 04-16-2008, 07:05 PM
new user help - by El Forum - 04-16-2008, 10:58 PM



Theme © iAndrew 2016 - Forum software by © MyBB