Welcome Guest, Not a member yet? Register   Sign In
Multi Table Select (Active Records)

I am trying to check multiple databases with user given string. But SQL query always returns true. It must return false, if phone number exist in individual or corporate databases.

Individual Users Database:

| id |     name     |     phone       |     gender     |
| 1  |     John     |     5551928321  |     male       |
| 2  |     Michael  |     5553270543  |     male       |

Corporate Users Database:

| id |     name     |     phone       |     company    |
| 1  |     Megan    |     5553748594  |     demo1      |
| 2  |     Ethan    |     5559182012  |     demo2      |


PHP Code:
$phone '5551928321'// $this->input->post('phone', true);
$query $this->db->select('individual.id, corporate.id')
get('individual, corporate');

if (
$query->num_rows() > 0) echo 'FALSE';
else echo 

I will be very pleased if someone light me up for see how it will be work.

Thank you so much.

Why did you save data in different databases? You can create a single database with two tables. One for "Individual Users" and other for "Corporate Users ". then you do a join. Sorry for my poor english Big Grin

(This post was last modified: 12-01-2014, 03:47 AM by Rufnex.)

You have to use the database names for your tables like db1.individual and db2.corporate
And you have to connect to both of course Wink


A model's method (returns boolean) that includes two separate queries?

(This post was last modified: 12-01-2014, 07:07 AM by bclinton.)

Assuming you meant different tables, not different databases...

Have you tried to debug by using the profiler  $this->output->enable_profiler(TRUE) or sending $this->db->last_query() to the log?

Does the query shown by one of the above commands work if you run it manually at the command line or in something like PhpMyAdmin?

Theme © iAndrew 2016 - Forum software by © MyBB