Re: [PHP-DB] MySQL Query Weirdness

2001-09-20 Thread Steve Cayford
When you use mysql_fetch_array you're actually retrieving an array with two copies of the value you're looking for. One is indexed by the column number and one indexed by the column name. So it looks like you're looping through them both and printing each out. You might want mysql_fetch_assoc

Re: [PHP-DB] mysql query problem

2001-07-26 Thread Paul Burney
on 7/26/01 11:11 AM, Steve Fitzgerald ([EMAIL PROTECTED]) wrote: ran the query in the MySQL client and got the ERROR 1054: Unknown column '$ContactID' in 'where clause'. I know the column ContactID exists. Of course it did. It can't find the text $ContactID in the table. Try putting in a

[PHP-DB] MySQL Query structure

2001-05-16 Thread Shannon Doyle
Hi people, I was approached by my boss today to construct a page to draw out the data from a recent survey that was conducted via the web. The data is stored in a mysql database by fieldname and the data that the user entered. The problem lies in the way that he wants the page constructed. The

<    1   2