[PHP-DB] searching for zipcode: where to start?

hello, I want to create a database search with php/mysql that searches for zipcodes in a database. of course, there will be other columns/tables and such to be printed, but I only want to search for the zipcodes and have the other cells printed if the following criteria are found: lets say I

RE: [PHP-DB] searching for zipcode: where to start?

full-text index that field in MySQL, - then query ordered by weight with a limit 3. Wonderful stuff. -Original Message- From: dean james Sent: Sat 11/10/2001 7:27 PM To: [EMAIL PROTECTED] Cc: Subject: [PHP-DB] searching for

[PHP-DB] Pulling Zip Codes from USPS

I had a tutorial bookmarked at one point on how to pull zip codes from the USPS search or something like this. There are a couple benefits to this - 1. it's always up to date 2. it's complete and 3. it's free. I would like to use something like this now. Does anyone have a link to tutorial or

[PHP-DB] [php - mysql] create_table

Hi, with the php-command mysql_create_db (my_db); i can create an mySQL-Database. How can I create a table in this database ? I found no command in the php.net-manual. --- H3N --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] Random Row From Database

Hi, I'm trying to pull a random row from my database and display the contents. I know that the code: SELECT * FROM TABLENAME WHERE RAND() LIMIT 1 should work. However, there are 19 rows in the database and only the first row ever shows up. Is there a way to do this to ensure uniqueness? The

[PHP-DB] How do i search my database...

Hi All, I have a database with only three fields FIELD 1 FIELD 2 FIELD 3 I want the user to input into FIELD 3, and then my script to go of to my database and see if it finds a match or something like the input and display it to the screen. Please help as i can't seem to get my brain around

Re: [PHP-DB] XML coming out from MySQL

I've never parsed XML with PHP, but it might help if you can show the document that's breaking the parser, and also let us know if other documents are working fine... -Lorenzo Hi, The document is like this: ?xml version=1.0 encoding=iso-8859-1? articulo volantaSome text/volanta

[PHP-DB] Re: JOIN operations

SELECT table_name.name, table_name.ID_city, table_city.ID, table_city.city, FROM table_name, table_city WHERE table_name.ID_city=table_city.ID Carlo loiudice wrote: Hi, I'm preforming a join between 2 Mysql tables in this way: table_name: ID,name,ID_city table_city: ID,city when I query

[PHP-DB] PHP 4.0.6 InterBase Bug

PHP 4.0.6 reports warning about invalid statement handle after I use ibase_close() to close opened with ibase_connect() database connection. If I comment ibase_close that removes the warning. Please don't forget to fix this in the next PHP release. In the mean time I went back to PHP 4.0.5,

[PHP-DB] odbc_columns() help

Hi, Does anyone manage to get odbc_columns(). If you so, can you give me an example, what version of PHP you are using? I've tried various combination of odbc_columns() and never get it to work. Any help would be greatly appreciated. Thank you, --kent -- PHP Database Mailing List

[PHP-DB] parse-error MySQL - PhP @ win2000

Hi all, I have recently installed an apache server, PhP4 and MySql on my win2000 machine (I know, I should be running linux; That will have to come with time). But now I am trying to learn PhP - MySQL. When running the script below I get the error message: Parse error: parse error in

Re: [PHP-DB] parse-error MySQL - PhP @ win2000

Dag Jelle, Als je printf(); gebruikt moet je dit wel correct doen, met print(); zou het goed moeten gaan. Dus regel 24 wordt: print ($resultaat[0]); (Excuse me muttering Dutch between the two of us :) M.vr.gr. Roel Mulder At 21:32 10-11-2001 +0100, you wrote: Hi all, I have recently

Re: [PHP-DB] parse-error MySQL - PhP @ win2000

Hi Jelle, - Original Message - I have recently installed an apache server, PhP4 and MySql on my win2000 machine (I know, I should be running linux; That will have to come with time). But now I am trying to learn PhP - MySQL. When running the script below I get the error message: Parse

Re: [PHP-DB] parse-error MySQL - PhP @ win2000

Thanks very much for the assistence: The curly-bracket thing did it! Now I finally know the installation has been succesfull! I'll try to start programming less sloppy, and spare you from these silly errors! I'll notify you when the site is up and running. Future site location:

[PHP-DB] trouble with simple logfile-script

Hi all, I use a small php-script for generating some simple weekly weblog for a site with about 3.000 vists / day. I do not want to log IP or dates, I just want to count pageimpressions for all the html/php-files seperately. A friend helped me with the script, but although it does exactly what I