Re: require help to include 2 databases in script

[Peter Brawley]

> 2 databases on the same server

Simple, just qualify table and column names in your queries, eg db1.tblA.columnnameX.

Also ...

- mysqli connection error info is in mysqli_connect_error()

- specify columns in queries, don't rely on column wildcards like *

- your functions getCountry... &c need access to the connection resource reference $con, either by having it passed in, or by having it declared global inside those funcs.

_ in your procedural style, mysqli_error( $con ) expects a param ref to the connection $con

- before referencing $row[area_name], your code needs to verify that it exists

Your code needs to assume that every possible error can and will occur.