Honest, my last question..... for a while. MYSQLIMPORT

2001-02-23 Thread Joe and Nancy M
I have my database created on my ISP's server. I can telnet to it and log in. I have created my table. I inserted 4 test records. I have written my .php3 pages and pull the data and get the results I want. Now I need to populate the table with hundreds of records exported out of Peacht

create table - NEVER MIND

2001-02-23 Thread Joe and Nancy M
Sorry, I tried it several times and kept getting the parse error. It must have been butterfingers, worked ok now. Thanks, Joe.

create table

2001-02-23 Thread Joe and Nancy M
What is wrong with this syntax, it looks like what chapter 7.7 says. mysql> CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7)); I get a parse error. Thanks, Joe.

Mysql Table via php

2001-02-22 Thread Joe and Nancy M
I finally got my ISP to resolve the issues with connecting to my db. I have a test table in the database named test. I have 3 fields; ID(20Char), PRICE(int),QTY(int). I am using php (this is what my ISP supports and suggested). I can connect using: I can draw the data out using this sample

need mysql sample to accomplish existing asp function

2001-02-19 Thread Joe and Nancy
I am in a time crunch to get mysql working on my site. I export inventory records out of my Peachtree software into Excel and planned to use that .xls table to show product pricing and availability on my web pages. Below is sample asp code that works. My ISP had told me they support asp, but af