Re: Mysql Table via php

2001-02-23 Thread Steve Edberg
At 12:48 PM -0500 2/22/01, Joe and Nancy M wrote: >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 co

Re: Mysql Table via php

2001-02-22 Thread Atle Veka
On Thu, 22 Feb 2001, Joe and Nancy M wrote: > $query = "SELECT ID, PRICE, QTY > > FROM test > > where PRICE=3"; I would first of do this instead, your query otherwise looks good: $query = "select ID, PRICE, QTY " . "from test " . "where PRICE=3"; ... Atle --

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