john ackers

You have to use a stylesheet or add some additional styling to the theme style.css file. For example to set the width of the 1st and 3rd columns.

.dbview td:nth-child(1)
{
  width : 50px ;
}

.dbview td:nth-child(3)
{
  width : 300px ;
}

OK!

You can link one view to another view. But I think you want a non tabular single row view. Sorry that’s not available. Also there is no row editing. Think you should look at the more comprehensive form management plugins. Apols.

OK that SQL generates two columns and the PHP is expecting one column containing both the image URL and the link URL separated by a comma. I have updated the FAQ with the same example from further up this thread and retested it. I would try creating a new DBView (refresh the page) and add just the SQL alone which should give you:

https://www.google.co.uk/images/srpr/logo11w.png,https://www.google.com

then add the PHP snippet.

Replace DBView::linkToView() with DBView::link(), same arguments as per FAQ

re:Column name update, press F5 to reload javascript, it worked for me.

Thanks again slevit.

Fixed by slevit. Thank you.

Far too late but … you can now enable/disable individual column sorting.

Fixed by slevit. Thank you.

Too late i know but you can use execute a PHP snippet (using another plugin) which gets the current user and then calls do_shortcode(dbview…). I have updated the FAQ.

Passing arguments to embedded views on public pages now supported.

You can pass arguments to queries on public pages in 0.5.5 (and jump from one table to another).

You can load another table in 0.5.5.

Yes sorry, the snippet update bug is a typo bug which i just saw today and have just fixed in 0.5.5.

I have just committed a small change so that you can pass two arguments (arg1, arg2) from dbview on a public page to MySQL. So you can use the dbview shortcode like this:

[dbview name='show user' arg1=1 pagesize=10]

which runs the query associated with ‘show user’ and shows data for the user with the ID of 1.

To show the current user detail, you’d need to get the current user and so you’d need to run some PHP e.g. by using a PHP snippet and invoke the shortcode.

If you want to create links on one table that, when clicked, loads another table, let me know. It’s not currently supported apart from inside the dashboard.