I want to create a database of office locations that can be searched based on zip codes. Does anyone know where I can get zip code and/or longitude/latitude data, and how to process it.
I got a free zip code file from the US gov. It is from the 1990 cencus. I want to offer a search on my site quite abit wider than most zipcodes, say 30 miles from the zip. All the searches would be in the US, and the file has the longitude and latitude for each zipcode. This looks like it sh...
What are the main advantages / disadvantages of using XML as a means of datastore over say Mysql?or have I missed the XML point? I have read a few articles about it and can parse the a document etc but I cann't see any advantage over a database app.please helpa rather confused XML Converte...
Hello!!!!I'm searching a program to convert XML files into a database of Access.Also, i'm searching for a program to know if a XML file is correct.Thank's for your help!!!...
Hello!!!! I'm searching a program to convert XML files into a database of MySQL. Also, i'm searching for a program to know if a XML file is correct. Thank's for yours help!!!...
Does someone know how to read a xml file and then put the information into a database (eg. mySQL).eg:<?xml version="1.0"?><backslash xmlns:backslash="blaat.dtd"> <story> <title>Blaat</title> <url>http://www.blaat.com</ur...
Database & Application Miscellaneous New questions
I am seeking to xml_parse_into_struc and XML file, but the file is printing to standard out. Is there anyway to prevent this from occuring?can I have it print to a file? /dev/null?...
Hi,I want to parse a XML files and put the contents of the tags in the database.But I am facing a lot of problems.As tags even have attributes.Currently I am trying to use expat, but some how it divides the tags if the size of the tag is more than 1 kb.Please help me.If you can give me a small e...
Hope someone can help me out here!I'm new to all this mysql and php stuff, and have a large database of information to access.I can write a query to access All from TABLE X WHERE Y="a specific value" and Z="another option", but how can I write the query, or php script so that if the Y input...
Hi,I've moved some of my code from Windows NT4(SP6a) to Windows 2000(SP1) and now I'm getting the next errors, my code worked fine on my NT box.code.$db_query = "SELECT UserId, Name, Type, Active FROM UserInfo WHERE Account='$accountname'"; $db_result = odbc_exec($db_con...
I am getting this message when i try to run the connect string...Fatal error: Call to undefined function: mssql_connect()I am wondering if PHP 4.0.4 supports SQL2k and if not when it is expected to....
my php program is show below<?php putenv("ORACLE_SID=hi"); putenv("ORACLE_HOME=/opt/oracle"); putenv("LD_LIBRARY_PATH=/opt/oracle/lib"); putenv("ORA_NLS=/opt/oracle/ocommon/nls/admin/data"); putenv("ORA_NLS32=/opt/oracle/ocommon/nls/admin/data"); $handle=ora_logon("hi","hi") or di...
$stmt=OCIParse($conn,"BEGIN pkg_test.dbp_sale_test('999',$bb_no,:freq,:addr_num);END;"); the procedure like this:PROCEDURE dbp_sale_test (i_radio in char, i_bb_no in number, freq1 in out char, addr_num out char)if I set freq="001" in my program ,but in the...