Home > Archive > PHP DB > December 2005 > Re: [PHP-DB] Minor Change
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] Minor Change
|
|
| Micah Stevens 2005-12-12, 6:59 pm |
|
You're getting an error, after the query, put:
echo mysql_error();
to find out what's happening.
On Monday 12 December 2005 11:05 am, kc68@cornell.edu wrote:
> I made tiny changes to my php file and sql table and the table won't come
> up. I updated the table name (and php file name) from 109fh5 to 109fh6.
> In the table, I changed 6 cells, leaving a couple blank. Then I changed
> only the digit "5" to make it a "6" (109fh6) in the following:
>
> $get_data_query = "select rep, party, state, cd, minority, afr_am, asian,
> am_indian, hispanic, med_hsehold_income, poverty from 109fh6 order by
> $sort_field $sort_order";
>
> Now I get "Warning: mysql_fetch_assoc(): supplied argument is not a valid
> MySQL result resource in" etc.
>
> I've done this many times without a problem (this is the 6th time in this
> sequence). What could be wrong after such a minor change?
>
> Ken
| |
| kc68@cornell.edu 2005-12-12, 6:59 pm |
| After adding echo mysql_error(); I get the same result. I tried changing
the query to include 109fh7 (a table which doesn't exist) and got the same
result as with 109fh6. Changing to 109fh5 does pull up that table. The
line to which the error message refers is while ($row = mysql_fetch_assoc
($data_set)) That is what always come up when there is an error in the
query.
**************
On Mon, 12 Dec 2005 14:13:10 -0500, Micah Stevens
<micah@raincross-tech.com> wrote:
>
> You're getting an error, after the query, put:
>
> echo mysql_error();
>
> to find out what's happening.
>
> On Monday 12 December 2005 11:05 am, kc68@cornell.edu wrote:
>
|
|
|
|
|