|
|
Posted by Markus Ernst on 08/09/06 15:27
mpar612 schrieb:
> J.O. Aho wrote:
>
>>mpar612 wrote:
>>
>>
>>>Now I am trying to retrieve the "isbn=987654321" using $_GET and I'm
>>>trying to make that a part of an SQL query using the following code and
>>>I constantly get a "DB Error:
>>>no such field." I could post more code if necessary, I was just trying
>>>to save space:
>>
>>"DB Error: no such field.", sound like you are trying to access a column that
>>isn't there, I do suggest you do echo out your SQL query before you do the
>>query, so that you can see that it's correct.
>>
>>
>> //Aho
>
>
> 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?
>
Is isbn a numeric kind of MySQL field? Otherwise it is necessary to
quote the value: "WHERE isbn='$isbnget'" (which is a good idea anyway).
If this does not solve your problem, you need more information. If you
use PEAR DB you can just add var_dump($rows) to get the PEAR error
message. If you don't find the error yourself, post complete error
messages here.
HTH
Markus
Navigation:
[Reply to this message]
|