Welcome Guest, Not a member yet? Register   Sign In
Database troubles
#8

[eluser]Maglok[/eluser]
Interesting development. I have decided to put a forum and the application in the same database, for easier management. The forum is prefixed 'smf_' while the application is prefixed '_phpci'. I have done that through the config.php.

All my queries convert nicely, I don't need to change any code, it will translate it. BUT:
Code:
$this->db->where('inschrijvingen.persoon_id', 'personen.persoon_id', FALSE);
It doesn't put the prefix in front. If I put it to TRUE it does work, but once again the query is not valid and will select 0 rows.

So I either put at FALSE and it errors or on TRUE and it can't select anything. A way around this one?


Messages In This Thread
Database troubles - by El Forum - 06-23-2009, 05:56 AM
Database troubles - by El Forum - 06-23-2009, 06:13 AM
Database troubles - by El Forum - 06-23-2009, 06:15 AM
Database troubles - by El Forum - 06-23-2009, 06:17 AM
Database troubles - by El Forum - 06-23-2009, 06:43 AM
Database troubles - by El Forum - 06-23-2009, 06:48 AM
Database troubles - by El Forum - 06-23-2009, 06:58 AM
Database troubles - by El Forum - 06-24-2009, 07:55 AM



Theme © iAndrew 2016 - Forum software by © MyBB