Joetabush

Hey-
this was working just fine… I’m not sure what change I made, but now when I click the link, it opens a new tab but loads up the SAME page I was on, on my site when I clicked… Any idea what could have caused this change?

Thanks.

So I’ve made some progress here…

I’ve changed the WHERE clause of the Query to read:
where x=%s

Now, I’ll use the shortcode [dbview=’nameofview’ arg1=’page_title’].

I’ve confirmed this works.

Problem: When I save this DB View, which DOES work for me, I don’t seem to have the option to insert the PHP snippet (in the second row, below the headers).

awesome!! works perfect. thank you.

Thanks for the quick reply…

I’ve revised my database so it now includes just the Link Address. If you use the same link above to my site, you will see that the table displays the link address. (if you click the link in my original post, you will see that it now displays the text of the link address).

Ideally, I would like it to display clickable TEXT which reads “open on Amazon”, and has the target attribute for new window, to open to the link from the database. Also, if the field is in the database in blank, do not display anything.

If possible, please provide me PHP snippet to insert in the header.

Thanks very much,
Joey