Programming & Design - July 2006

Okay I have a database of people that work in certain cities. I have a second database with other (secondary) cities (near by) that they work in. What I want to do is go into the first database and see if there is no one listed for that city. If so, go into the other database and find those who have that city listed as a secondary city. Then get their ID and go back into the first database and get their info (using ID).

Code:
check for primaries
if($cat_rows == 0)
{
$cat_altresult = DatabaseSelect(MY FUNCTION.. ITS FINE searches for secondary cities get array??);
$cat_rows = sizeof($cat_altresult);

if($cat_rows != 0)
{
$alt_msg = "blah";
}
else
$alt_msg = "blah blah";
}

Take IDs from secondary cities, go into primary table and gather info for EVERYONE who has that city listed as a secondary.

Getting the multiple rows is my problem... i think... someone recommend a join, but I am not sure how to do this on two databases. Thanks

Someone recommend a join, but Im n

2006-07-26 04:52:58 · 3 answers · asked by Duds331 5

2006-07-26 04:35:23 · 4 answers · asked by **Semaj Love** 1

2006-07-26 04:29:58 · 1 answers · asked by Sal 1

How do I change my age in my profile?

2006-07-26 04:24:52 · 1 answers · asked by Anonymous

2006-07-26 04:24:33 · 4 answers · asked by Caesar Alejandro B 1

The polling system should be idiot proof, easy to use and for beginners.

It should also enable me to enable more details on the answers

2006-07-26 04:13:19 · 3 answers · asked by Bluez 1

In C programming on Dos operating system an intiger number will take two bytes. The lefter most bit is using for storing a sign. For negative numbers it will be 1 and for positive nubers it will be zero. Is it symbly changing the value in that field or will there be any difference in other bits.

2006-07-26 04:07:24 · 3 answers · asked by kunjan 1

The mail is successfully sent to other email providers such as Yahoo Mail.

2006-07-26 03:57:15 · 4 answers · asked by Alan 1

the computer is a compaq it only has windos 98 and i cant even get the defrag to do anything
if you have a messenger you can buz me
thank you

2006-07-26 03:50:06 · 2 answers · asked by edward b 3

I want it to be in source/c:
Createing a MenuBAR and a Menu.
Toolbars and button creation.
Labels.
WebBrowser.
Textboxs
Buttons.
I want the code for these.

2006-07-26 03:34:37 · 3 answers · asked by loopy_and_yoshi 3

What web pages, books and other resources are available?

2006-07-26 03:25:38 · 2 answers · asked by Shaula 7

i have a dell xpi laptop with no cd-rom...is it possible to install windows by floppy?

2006-07-26 03:21:33 · 7 answers · asked by Anonymous

after i display my form it will disappear after a few seconds. how do i do that? :)

2006-07-26 03:07:52 · 2 answers · asked by reenz 1

2006-07-26 02:56:54 · 5 answers · asked by m ilham m 1

What is the best software development methodology

2006-07-26 02:56:34 · 6 answers · asked by Manu 1

2006-07-26 02:45:38 · 1 answers · asked by Anonymous

2006-07-26 02:16:05 · 6 answers · asked by pennywise 1

hi i want' to make project on c sharp.net and i learn it can you give me link,e-book ya book name which i refer from initially plz. help me

2006-07-26 01:51:30 · 1 answers · asked by ketan patel 2

2006-07-26 01:47:39 · 3 answers · asked by jerry F 1

2006-07-26 01:35:31 · 5 answers · asked by nisha k 1

2006-07-26 01:26:39 · 3 answers · asked by Anonymous

Hi everyone, I have an HTML form with a file uploader, but i want to allow file uploads without any file size limits.

People should be able to upload a file no matter what the file size is. It could go in Gigabytes.

Is it possible? if so how?

I am using PHP and MySQL.

2006-07-26 01:18:51 · 5 answers · asked by Manish 5

im totally sick of windows movie maker and i need something better

2006-07-26 00:49:06 · 4 answers · asked by fatgoldfish91 2

2006-07-26 00:45:51 · 3 answers · asked by ramya 1

i need a program that will out put a slant * (asterisk line).... and a triangle line of asterisk....

2006-07-26 00:34:13 · 2 answers · asked by irisalcanices 1

2006-07-26 00:33:43 · 14 answers · asked by lana 1

and name of prgm and location

2006-07-26 00:25:38 · 8 answers · asked by toni 1

2006-07-26 00:20:23 · 3 answers · asked by Steph^_^ 1

ams assembly language compiler

2006-07-26 00:18:37 · 1 answers · asked by vikash2429 1

2006-07-26 00:04:07 · 2 answers · asked by vidyadhar k 1