i need help, how to merge ... newbie :)

[eluser]hvalente13[/eluser]
Hi,

What you want to do is like to put a pulley to make things go faster!

Active record it's capable of assist you to make what you want to do! And what I understood is that you want an header with user info and below the user actions!

1. Simple: Make two queries! I've read somewhere that separate queries give faster results! Give it a try.

2. Complex: Subqueries! This way you have to make sql string by hand and then you can retrieve it by:

Code:

$sql_strin = "SELECT * FROM ..." // you know what you want to do
$query = $this->db->query($sql_string);

This way the results will be all in the same row.

Hope this helpS