The Joomla! Forum™

SineMacula

Got it!! :D $db = JFactory::getDBO(); $user = &JFactory::getUser(); $sql = "SELECT `fvalue` FROM `jos_juser_extended_data` WHERE `field_id` = '1' AND `user_id` = $user->id"; $db->setQuery($sql); $fvalue = $db->loadResult(); $sql = "SELECT * FROM `lime_surveys` WHERE `attribute1` ...

SineMacula

After playing around with that a bit, some trial and error, and so far, all error... I got an idea on how to do my original approach - but will still need some help sorting it out. I think this time I'm giving you more to work with though ;) So, here's what I've got so far: $sql = "SELECT `fva...

SineMacula

Thanks, Bruce. Well, they're interdependent in a chain kind of way, rather than a "all share one field" kind of way. By that I mean that jos_users has $id which links to $user_id in jos_jusers_extended_data jos_jusers_extended_data has $fvalue which links to $surveyls_title in lime_surveys...

SineMacula

Hi, I know enough about mysql to know about the existence of various ways of making compound queries with JOIN statments and such, but I don't know enough to figure out how to do it... so I'm looking for some help figuring out the best way to set up a query that uses three interdependent tables. Her...

SineMacula

Thanks Amy! That lead me to realize I can also have a "custom" registration page in my template's html directory. :) So, next question(s): How would I make setting the parameter at registration required, like the other fields? It appears the parameter doesn't get included in the 'POST' fu...

SineMacula

Once again, it seems I should learn to trust that I know enough to give it a shot... and with some reading through the developer's wiki, and a lot of trial and error, I figured it out! :D What I don't know is if this is the best way to do it... I added the "study" options to /components/c...

SineMacula

Hi, How difficult would it be to hack the registration process so that some of a new user's details are added to another table in addition to the jos_users table? To make it a bit more complicated, I'd need to choose which table they go in based on one of the registration fields. Basically, what I'm...

SineMacula

Well, in case anyone's wondering, I figured it out. Actually, I've managed to get something beyond what I had imagined - a list of all surveys (done in Chronoforms) associated with the research project the user indicated at registration (using JUserSuite component), in random order, with an indicati...

SineMacula

Using Joomla! 1.5... I'm planning to use Chronoforms to collect data for a research project, creating several instruments as separate forms. I am including user id as one of the fields in each of the forms. What I want to be able to do is create a list of the forms that have already been submitted b...

SineMacula

Thanks, CirTap -- I hadn't thought of adding the ORDER BY and LIMIT elements to the query... that does the trick perfectly.

I haven't tried the $database->insertid() yet -- perhaps I'll play around with that when I get a chance.

Thanks!

SineMacula

It occurs to me that there are two issues here: 1. how to display a report based on the just submitted data 2. how to associate a submission with a particular user I've included the user id pulled from the session in the submitted data - so registered users can access a list of all of their submissi...

SineMacula

Thanks CirTap, I think I'm part way there... What I now have is the username for the currently logged in user automatically added to the database with the submission data. What I don't know how to do is pass the record-id to the user session and then back to the WHERE query. For now I've got a reaso...

SineMacula

Thanks, lobos!!

As it turns out, my original code works too... once I added the closing form tag.

SineMacula

Nope, I was wrong... I've now got it so that the username is included in the submission to Chronoforms, and the script that Chronoforms redirects to after submission queries the database based on username... so what it's doing is displaying ALL submissions for the logged in user, in record order (wh...

SineMacula

OK, figured that part out.

Now my problem is that if a user submits more than once, it's always the first one that gets displayed.

So, I'm trying to create a submission list that will link to full reports. No luck yet.

See: http://forum.joomla.org/index.php/topic,232848.0.html

SineMacula

I'm creating a script that will query the database and present a list of records for the logged in user. I want the user to be able to click on a record to go to a full report for that particular instance. So far I can't get it working - no matter what record you click, the last record is the one th...

SineMacula

I'm using Chronoforms with Joomla! 1.5 to allow users to submit some data for an assessment. I've also created a php script that will "score" the submission and display a customized report based on the scoring. The problem is, I haven't figured out how to get Chronoforms to add the submitted data to...

SineMacula

Woohoo!!!

I'm sooooo happy!! I've been developing a couple of sites using the nightly builds, hoping for an RC release before I was ready to go live... and here it is, a few weeks before I need it!

Great work folks!!

SineMacula

What are the changes to the "madeyourweb" template, and are they important? Are there any good reasons to not use the older one I'm currently using? Changed 1.0.1: # Fixed artf1033 : madeyourweb template logo path m Thanks Rey... I must be using a much older/different version then, because there ap...

SineMacula

What are the changes to the "madeyourweb" template, and are they important? Are there any good reasons to not use the older one I'm currently using?

SineMacula

Excellent!

Congrats to all!

I never had any doubt that following the team was the right move... this just goes to prove it!

SineMacula

Love the logo (I voted for it myself), Brand Manual is excellent and well done. Tagline? Blechhh! Says absolutely nothing about the product. Great name for the organization, but unsuitable for a tagline. I tend to agree... I love the logo, and I certainly agree with the sentiment of the tagline, b...

SineMacula

Congrats Alan! Your logo was in my personal top 5 of all the pre-vote submissions (as was another of the finalists), and it got my vote. I work solely on Macs, so the MSO logo issue didn't even occur to me... and now that the Windows version of Office logo has been pointed out, it still doesn't part...

SineMacula

So there's my story behind the logo. Is there some deep thought behind the meaning of the logo, like the fish and the bird logo? No. I think is pretty straight forward...A community intertwined and linked together as one. That's a big part of what I like about yours - straight forward and directly ...

SineMacula

the hearth of joomla! is the community, so what do you think about this slogan: Joomla! Ccms (Community Content Management System). This community is great (logo competition is an example) so i think we have to exalt this project's side. The heart behind the development of Joomla! is certainly the ...

SineMacula

the hearth of joomla! is the community, so what do you think about this slogan: Joomla! Ccms (Community Content Management System). This community is great (logo competition is an example) so i think we have to exalt this project's side. The heart behind the development of Joomla! is certainly the ...

SineMacula

I think it's a real shame that the then name "JoomlaFish" is really hurting this logo. I didn't even notice the fish connotation until I looked up at the name. I just saw a piece of paper with an exclaimation mark on it, and though that looks nifty! Just my 2c. Interesting... I hadn't seen it as...

SineMacula

eyezberg wrote:Heard about Mercede's new bionic car design copied from a fish? http://news.mongabay.com/2005/0710-DaimlerChrysler.html

shudder

SineMacula

Two of my top 5 made the cut... so at least the decision was easier for me than it would have been than if they'd all made it! What I found frustrating was that I loved some of the graphics but the text didn't appeal. This then compromised what I would have voted for. My understanding is that ...

SineMacula

ratlaw wrote:Joomla, no you can’t smoke it!

The Joomla! Forum™

Search found 77 matches

[SOLVED] Re: Need mysql statement help

Re: Need mysql statement help

Re: Need mysql statement help

Need mysql statement help

Re: Registration hack question - put user details in a 2nd table?

Re: Registration hack question - put user details in a 2nd table?

Registration hack question - put user details in a 2nd table?

Re: Code to create list of completed forms based on User id?

Code to create list of completed forms based on User id?

Re: How to get userid and query database table?

Re: How to get userid and query database table?

Re: How to get userid and query database table?

Re: Need php/mysql help -- I think I need a "foreach" -- how to do it?

Re: How to get userid and query database table?

Re: How to get userid and query database table?

Need php/mysql help -- I think I need a "foreach" -- how to do it?

How to get userid and query database table?

Re: Discuss: Austin ... the Joomla! has Landed

Re: Discussion about Joomla! 1.0.7 Release

Re: Discussion about Joomla! 1.0.7 Release

Re: Discussion on: Trusted Joomla! Wins... Twice!

Re: Discussion about: Joomla! Brand Guide & Logo Usage Released

Re: Discussion : Logo Winner Annoucement

Re: Background information?

Re: New slogan

Re: New slogan

Re: Discussion about: Logo Competition - Community Vote begins

Re: Discussion about: Logo Competition - Community Vote begins

Re: Discussion about: Logo Competition - Community Vote begins

Re: New slogan