left join where item in right table is null
"Chris" [EMAIL PROTECTED] 10/3/2007 10:32:01 PM
Aleksandar Vojnovic wrote: I would also suggest to limit yourself to things you actually need not to select the whole table.In this case you can't because you're looking for records that exist in
On my choices page, there are only 3 radio buttons and a Submit button.
The page calls itself and runs a query on the database, displaying results. But the
criteria buttons are still at the top of the page above the results. Before, I had a
combo box for certain choices and I just did an If
people involved providing this stuff to our counties.
tia
John Davis
IIS State of Oregon
Drinking Water Program
[EMAIL PROTECTED] 11/12/02 09:12PM
On Tue, 12 Nov 2002, John A DAVIS wrote:
Want to give the user the ability to download a dynamic Access.mdb file
that has a table and linked
Is there anyway to take a resultset and cram it into an array?
In VB it would be the GetRows function:
myArray = rs.GetRows
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Want to give the user the ability to download a dynamic Access.mdb file that has a
table and linked report formatted for Avery 5160 labels. Know how to create all this
stuff in VBA code, but not using PHP.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
on
a wild journey to who knows where.
A working example would be acceptabale too!!
tia
John A. Davis
Information Systems Specialist
State of Oregon DHS DWP
State of Oregon
If you had to identify in one word, the reason why the human race
has not achieved and never will achieve its full potential
;
$fields=odbc_num_fields($data2);
for($i=3 ; $i=$fields ; $i++)
echo td nowrap.odbc_result($data2,$i)./td;
echo /tr\n;
} while(odbc_fetch_row($data2));
echo /table;
John A. Davis
Information Systems Specialist
OHD DWP
State of Oregon
--
PHP Database Mailing List (http://www.php.net
THE SQL STATEMENT:
$data = odbc_do($connection, "Select Distinct [ActivityStatus],
[WaterSystemStateCode], [WaterSystemName], [PopulationServed], [SeasonBegins],
[SeasonEnds], [SystemType], Contact, Phone, County, Connections, Address, CityStateZip
From viewInventory Where