PHP-problem: INNER Join and Photo upload

General PHP Help
#21

So in your search field did you type in “Find!”?

Looks like the code is working and it formed the SQL Statement properly…

This kinda means that it's acting according to plan, but what is being faulty is the Showing-part of the php code. Or am I entirely wrong?

What part of the PHP code is it showing, just the $SQL statement out-putted to the screen? We did that on purpose to make sure the SQL Statement is correct.

If you can run that SQL Statement against your database directly and it executes, that means everything is perfect.

#22

the “Find!”-string is the value of the find-button that you press when you want to search.

This is weird. It seems as if the error comes from
[php] {
$sql .= " AND Object LIKE ‘%{$search}%’ ";
}[/php] on line 101

Also I think it has to do with these tags (maybe the name?)

Search:
...

and the search-button looks like this:


#23

Yeah you can’t have them both named the same…

Change…

[php][/php]

to

[php][/php]

#24

That did it! Thanks a lot! 8)
I think however i need to change something because I still get no result.

#25

I just solved it. The problem was in the input. I had mistakenly specified the option value as 0. I’m a moron! 8/

By the way, can I ask a couple of other php-questions such as thumbnails showing next to the ads on the search result? I’ve been meaning to implement a couple of things but I’d love to have someone to play it through/with

Take care and thank you so, so much! :smiley:

#26

Just start new topics for different questions… Sounds like your a pro now!! Hopefully, you can answer some other peoples questions now!

#27

Haha, thanks a lot for the confidence boost!
I will definitely name this community (and you of course) as helpers on the site (if i get it running).

Sponsor our Newsletter | Privacy Policy | Terms of Service