Posted by mpar612 on 08/09/06 19:18

J.O. Aho wrote:
> mpar612 wrote:
> > J.O. Aho wrote:
> >> mpar612 wrote:
> >>> J.O. Aho wrote:
> >>> Thanks! I ran the SQL query in phpmyadmin and everything before the
> >>> WHERE works. I also tried to print the $_GET['isbn'] and that worked.
> >>> The two are not working together. Any ideas?
> >>>
> >> Did you print out the SQL query from your PHP script? or did you just use the
> >> query you based your php code on?
>
> > I copied everything before the WHERE in my query from my PHP script and
> > pasted it into phpmyadmin and it worked.
>
> This isn't a "valid" test, do print the whole query from php including the
> WHERE statement and then try that in phpmyadmin.
>
>
> //Aho

Thanks! This didn't make much sense to me. I ran the following query
in phpmyadmin:

SELECT isbn, artist_name, album_title,
date_format(release_date, '%M %d, %Y') as release_date,
date_format(add_date, '%M %d, %Y') as add_date, description, price
FROM lounge WHERE isbn = '$isbn';

I received errors. Phpmyadmin is not going to know the values of
$isbn. I tried the following query in phpmyadmin with an isbn value
that I know existed in the database and it worked just fine:

SELECT isbn, artist_name, album_title,
date_format(release_date, '%M %d, %Y') as release_date,
date_format(add_date, '%M %d, %Y') as add_date, description, price
FROM lounge WHERE isbn =123456789 ;

Does anyone have any other thoughts or troubleshooting steps that they
can suggest?

Thanks for all of your time and help!

• Next in forum: Re: LAMP and PHP EVANGALISTS NEEDED IN SEATTLE!!!!
• Prev in forum: Re: MySQL/PHP5 $_GET issue
• Thread view: Re: MySQL/PHP5 $_GET issue

[Reply to this message]