[PHP-DB] [PHP] Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?
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 one table that don't exist in another.Apart from looking at the whole table in each case how else would you do that?-- Postgresql php tutorialshttp://www.designmagick.com/-- PHP General Mailing List (http://www.php.net/)To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how do I use same page for submit and results?
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 (!$ComboBoxName) { yada yada} die;. But now I'm not using anything that I can check except for the button click. Any ideas how to do this? echo form action=\/inventorylist.php3\ method=POST\n; echo div align=left; echo table cellpadding=12 bgcolor=lightblue\n; //search page title echo trfont size= +1bnbsp;nbsp;Inventory List/b/fontbr/tr; echo tdnbsp;nbsp;nbsp;nbsp;input value=\Show List\ type=\submit\; echo /td; echo td; echo bActivity Status/bbr; echo nbsp;nbsp;input type=\radio\ name =\actstat\ value=\A\ checkedActive br; echo nbsp;nbsp;input type=\radio\ name =\actstat\ value=\I\ Inactive br; echo nbsp;nbsp;input type=\radio\ name =\actstat\ value=\ALL\ Both brbr; echo (takes a while to build complete inventory); echo /td; echo /tr; echo /table; echo /div; echo brbr; die; -query and display code down here -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] can i create an Access table or mdb with PHP?
I'm trying to supply our Contract Counties with mailing labels, already formatted. They log on to our website and PHP will hit our SQL Server and return a list of Public Water Systems for the County chosen. I would like a link on this page that says something like Send me an Access .mdb with mailing labels for these systems. PHP would delete whatever is in stock Access .mdb table somewhere on our system and replace the rows with newer, current ones, specific to the County chosen(same query that displays the systems in HTML). The Access .mdb that gets downloaded will have a report formatted for Avery 5160 labels, bound to the newer table that was filled. All they have to do is adjust their printer settings. Does anyone have an easier way of supplying data formatted for mailing labels? If they do, I'm all ears(eyes). Since this is a bonus service, we don't want to have to have 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 report formatted for Avery 5160 labels. Know how to create all this stuff in VBA code, but not using PHP. It is better to give too much information than not enough. You are trying to generate a dynamic Access.mdb file on the fly, using PHP? Or you are trying to deliver this already existing file that changes sometimes with PHP? Or you are trying to do something else? If the first option, where is your data coming from? If the second, why are you trying to use PHP instead of just linking to the Access.mdb file via the web server? Peter --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how to put all rows into an array
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
[PHP-DB] can i create an Access table or mdb with 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: http://www.php.net/unsub.php
[PHP-DB] Need security advice/direction.
We have plenty of PHP pages that select and display data (read: SELECT permissions only). Looking to have laboratories submit their samples via browser/PHP (read: INSERT permissions). SQL Server 7.0 back end. Need some direction here on security where to's and how to's before I take off 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, that word would be meetings. -- Dave Barry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need syntax for conditional in recordset loop
How would I code IF .odbc_result($data2,$i) = 'SOX' THEN make it a link? By link I mean that I want the word SOX highlited in blue and underlined and referencing a webpage that explains SOX verbosefully. Don't know PHP IF THEN syntax too well. /* fill table with data */ do { echo tr; $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/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Code bombs connecting to MSSQL 7
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 [WaterSystemStateCode]=\"OR4100100\"");BOMBS HERE THE ERROR: Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'OR4100100'., SQL state S0022 in SQLExecDirect in C:/Program Files/Apache13 14/Apache/htdocs/sdwis/inventry.php3 on line 21 VERIFICATION: the field value "OR4100100" exists in the table TINWSYS in the "Number0" column(alias: "WaterSystemStateCode"). The same query works in Access linked to the MSSQL 7 server. . . THIS WORKS: $data = odbc_do($connection,"Select * From viewInventory"); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]