Using Databases with Array Problem

molson4u

I was wondering if it possible to pull information from a database using an array (not even sure if this is the best method of doing this), but what my problem is I have 2 database's one for contacts and one with event information, I need the pull the contact name from the contact database (Each contact has an ID NUMBER) and put it into the event page with the corresponding event (Each event has a field for the contact ID NUMBER). Eg
Name1-Event1
Name2-Event2
Name3-Event3

yelvington

Do you REALLY have the information in two different databases? Or do you mean two tables in one database?

What database are you using?

And did you read the corresponding section of the manual?

molson4u

I accually do have 2 different Database's. The contact information has multiple use's, they are both using MYSQL, I don't think the problem isn't In the database portion what I need is some sort of sample code so I can have a command like

$sql = "select * from contact where id='1' or '2' or '4'";

I want to pull out the Numbers there Dynamically from the event database(you probably know a better way to code the SQL as I'm fairly new to databasing and PHP)
what I am wondering how to code "'1' or '2' or '4'...(and so on)" into a variable, so it will pull out the proper information from the database.

sepodati

Hmm...you want to pull the contact numbers 1,2,3... out of one table/database, and then look up the events with those same numbers?

$db = mysql_select_db("contact");
$result = mysql_query("SELECT contact_id FROM contacts");
while($row = mysql_fetch_row($result))
{
$contact_array[] = $row[0];
}
$contact_string = implode(",",$contact_array);
$db = mysql_select_db("events");
$result = mysql_query("SELECT events FROM events WHERE events_id IN ($contact_string)");
while($row = mysql_fetch_row($result)
{
echo "Event: $row[0]";
}

Adapt to your needs, you might need to use $db in the mysql_query() to make the change take affect... 🙂

---John Holmes...

yelvington

The right way to deal with this is to fix your data model, which ought to have two tables in the same database. That allows you to perform a join between the tables and pull out your information with one SQL statement.

If for some reason you can't do that, then you can hack around the problem by creating two database connections in PHP and coding around the problem.

molson4u

Thank's You saved me alot of time on this one... What I did was joined the tables and it worked perfect, Thank you very much... For reference for other people to connect multiple databases you can use the databasename.table command in your SQL Statment and it can join 2 databases together. I figured that out after I merged my database's together.