Welcome Guest, Not a member yet? Register   Sign In
How to write this SQL statement in Active Record
#1

[eluser]Isamtron[/eluser]
Hello,

How to write this SQL statement in Active Record:

Code:
$this->db->query('SELECT a.slogan, a.brief, u.id, u.name FROM example_tbl AS a, users AS u WHERE u.user_id = "' . USER_ID . '"');

Please help. Thanks.


Messages In This Thread
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 08:11 AM
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 08:36 AM
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 09:10 AM
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 09:25 AM
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 10:27 AM
How to write this SQL statement in Active Record - by El Forum - 06-10-2010, 11:03 AM
How to write this SQL statement in Active Record - by El Forum - 06-14-2010, 12:12 PM
How to write this SQL statement in Active Record - by El Forum - 06-14-2010, 05:36 PM
How to write this SQL statement in Active Record - by El Forum - 06-14-2010, 10:01 PM



Theme © iAndrew 2016 - Forum software by © MyBB