MySQL Field Type Plugin

10 years 5 months ago #159641 by palden
Replied by palden on topic Re: MySQL Field Type Plugin
thanks for this great plugin.. I've been trying this plugin a while and would love to explore more from this.

I am using the latest version of this plugin. I understand it can retrieve one coloum data( e.g. id ) from mulitple rows like below.
select id from #__poll_data
return => 1|*|2|*|3|*|4|*|5|*|6|*|7|*|8|*|9|*|10|*|11|*|12

However, can I retrive muiltple column data from multiple row ?
e.g. select id, text from #_poll_data

Is there any limitation from maximum number of row to display ?

Thank you in advance !

Please Log in to join the conversation.

10 years 5 months ago #161260 by teddybear
Replied by teddybear on topic Re:MySQL Field Type Plugin
Hi.

Im trying to get 1 result out of this:

SELECT * FROM rp_1.darkrp_wallets where steam = '[cb_steam}'

and the result i want as output is:

rp_1.darkrp_wallets.amount

How do i build this query?

Best regards
Claus

Please Log in to join the conversation.

10 years 5 months ago #161263 by NickOg
Replied by NickOg on topic Re:MySQL Field Type Plugin
a very quick reply - try
SELECT rp_1.darkrp_wallets.amount FROM rp_1.darkrp_wallets where steam = '[cb_steam}'

Nick Ogbourne

Please Log in to join the conversation.

10 years 4 months ago - 10 years 4 months ago #161735 by NickOg
Very odd. I have two copies of the same site. I have used this plug in for some months but now, having re-installed the plugin on my main site, I have duplicated the code from test site. While the test site works fine the main site will not. I still get the field warnings discussed earlier on both sites. Any ideas why this might be? How do I go about debugging this plug in?

Puzzled - because on the test site it works fine and is a veryuseful plugin. :unsure:

Regards

Nick

PS on April 26th I have copied the code from the working test site to the non-working production site and Eureka - it is working again. No idea why - I haven't looked as yet but just a warning before upgrade. Keep a copy of the previous version.

Nick Ogbourne

Please Log in to join the conversation.

10 years 4 months ago - 10 years 4 months ago #161992 by softforge
Replied by softforge on topic Re:MySQL Field Type Plugin

NickOg wrote: a very quick reply - try
SELECT rp_1.darkrp_wallets.amount FROM rp_1.darkrp_wallets where steam = '[cb_steam}'


In this example there are a mixture of square and curly brackets in the placeholder, they should both be square.

If you like our plugins, please consider writing a review on the Joomla Extension Directory or the Community Builder Directory ...
The following user(s) said Thank You: pepperstreet

Please Log in to join the conversation.

10 years 3 months ago #164560 by whiteviper
Replied by whiteviper on topic Re:MySQL Field Type Plugin
I just wanted to say thankyou, softforge, for this plugin. It really is a lifesaver. :cheer:

Cheers!:cheer:

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.219 seconds

Facebook Twitter LinkedIn