whats wrong with this code?

[inspireme]

Some of my listigns dont have websites. If they dont I have the default address : http://www.mysite.com/nosite.php added in the DB. This link will go to a page saying the site has no webpage etc. I want to display graphics depending on if the site has a webpage, if the do it will come up with a button saying "Visit Site" if not a button saying "No Website Available"

I have the following code, but it ALWAYS comes out displaying the "yessite.jpg"

I cannot see whats wrong with the logic. no site url is identical to what is stored in the database so it should work

Content visible to License Owner only.

the plan is to use
<a href=<%url%>> <img src=<%displaysite%>border=0></a> to display if a site exists, and make a clickable button.

Im sure this is a simple problem, im new to php. I try for an hour and then i post. thats my rule!!!

[inspireme]

ok if i declare $url = www.mysite.com/nosite.php it works. SO, the problem must be the way im getting the url fromt he database into the variable $url ... its obviously not working.

Im actually using : $url = $links_obj->url

not what i used in the first post... so how would i do it?

[esm]

the following should work:

Content visible to License Owner only.

I'm not to sure about the value of

Content visible to License Owner only.

whether its works depends on where you are at in the code.



.

[inspireme]

I did a few tests and the problem is that i cannot get the url fromt he database to do any comparing. Im using your hits mod I found in the forums (counts hits to the details page rather than external site) and adapted the way you did it, this works but im not sure if its the best way :

Content visible to License Owner only.

I dont really understand why it is necessary to query the database again once a query to :

Content visible to License Owner only.

has already happened, surely the url field is available... anyway it works now so im happy!!

[esm]

Content visible to License Owner only.

I'm not sure which code it is that is working for you but if it works...

depending on where you are at in the code, any one of these three could work:

Content visible to License Owner only.

Content visible to License Owner only.

Content visible to License Owner only.

I don't think the following will ever work since id is not a valid field name in the SQL table idx_link

Content visible to License Owner only.

.

[inspireme]

the database query was my short hand im using link_id really. I was just wondering why I needed to query the database again, because the indexu (unchanged code!) already selects everything from idx_link, therfore I should be able to get the url from the returned array...

But as you said, its working so lets not worry about it !!