|
|
Posted by Jerry Stuckle on 08/03/06 21:13
mpar612@gmail.com wrote:
> Hi everyone,
>
> I'm not sure if this is asking too much or not. I am trying to get the
> following PHP code to work on my website. It utilizes PHP 5, MySQL 4.1
> and the PEAR DB module.
>
> I am having issues retrieving data from the form. It won't retrieve
> all of the data only a part of it. All of the code is below and I also
> attached the code for the main file. I seem to understand everything
> except for the last 40 or so lines of code, which is where the SQL
> statements come into play.
>
> If anyone has any helpful hints or tips, I would really appreciate it.
> Or if anyone can make a recommendation for a book or website that might
> help me figure this out, that would be great too. Thanks!
>
<code snipped>
What exactly are you getting? Is the SQL returning no results or
partial results? Are you getting any errors on your SQL?
Also, while I don't use PEAR::DB, I question what you're trying to do in
this statement and others like it:
$artist_name = strtr($artist_name, array('_' => '\_', '%' => '\%'));
I'm not sure why you're replacing the characters. Maybe it has
something to do with how PEAR::DB works.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|