|
|
Posted by J.O. Aho on 08/10/06 03:07
mpar612 wrote:
> 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:
You still didn't echo out the query from php.
> 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 ;
Here you use isbn as a numerical value while in the above "example" you treat
it as a string.
//Aho
Navigation:
[Reply to this message]
|