|
|
Posted by mpar612 on 08/09/06 17:07
Markus Ernst wrote:
> 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
I am not familiar with var_dump, but I inserted var_dump($rows) into my
code and this was returned: array(0) { }. I'm not sure what that
means.
Thanks!
Navigation:
[Reply to this message]
|