hilltopper06

Bump. I still have not figured this out. Anyone? Thanks.

Ok, I did some messing around in the MySQL Console and this command is returning what I am looking for: It returns a long list of the total hours for each teacher. Now I am not sure how to take that information and have it update the appropriate field in the pdedu table. Any ideas?

I am trying to update records using the SUM function, but NULL is being returned (even though I know that values should have been found). Here is my code: The first query sets the field PDHours (in table pdreg) to the appropriate number of hours as seen in the pdprog table. The second query is supposed to total the hours in the pdreg.PDHours table and have pdedu.PDHours equal to it, where the TeaSSN's match up. The problem is that I cannot get the SUM function to work right with the WHERE statement. Can anyone shed any light on this problem? Thanks.

That worked great. I guess I needed to define both tables first. Thanks a bunch.

I have a form that sends data to a mysql database. From there it is processed using a PHP script. I use ID numbers to identify individual records (think peoples names). I have a placeholder field set up that I want to contain their actual name, but I do not know how to set a field to the value of a CONCAT statement. For example, I am wanting to do the following: This is returning NULL for fullname. How do I set fullname to the value of the concat statement? Thanks.

Just to give a better idea of what I am trying to do, and where I am at with it. I am using the same code the kickstart helped me with before and it works beautifully (thanks kickstart). Now, I am wanting to alter it a little to perform one more mundane function for me. I would like for it to store a teachers full name into a hidden field for me. This way I can pull that field later for reports, instead of having to use the Teacher ID. Here is the code I have. It isn't working for me (that is to say nothing gets changed or updated in fullname but the proc flag does get set to 'yes' so I know it was finished. Any ideas? Thanks.

Guess who is back? I just need a little more help, and then I will really be done. Right now my teacher name has a CONCAT label of LastName, FirstName , but a key value that is tied to an ID. When I lookup teachers for reports, it only shows the key value (id numbers and not names). Is there a way to change the key value of TeacherSelect to be LastName, FirstName other than ID? Like I mentioned, this is functionality I need for reports. Thanks.

That worked! Thanks again for all your help, this puppy is solved!

My setup is at work so I will try that out on Monday as soon as I get it, thanks so much for all your help.

Something still isn't right. I tried running one of the queries through mysql console and it spit back an error: So it is not liking the apostrophies? Or does that only apply to the console query?

Maybe I spoke too soon. When I run a console query it works: Here is my most recent code as well. So now we are really, really, really, close. Maybe a typo on my part?

I think I figured it out. It is a bug in fabrik I have decided. On the screenshot I posted notice where it allows me to select a field and key from tea_tbl OR the concat string. Well the value still goes to the field you select and the concat string is just the label. To work around this I tried setting the value to fabrik_internal_id (which it wouldn't let me do earler when the concat string was empty). Now I can change my code to read IF TeacherSelect = a.fabrik_internal_id and everything will be peachy. I will respond again once I have it working.

Thanks for your help, I am having some trouble registering over at the fabrik forums, so I will probably make a new topic over here shortly. I installed firebug and found something interesting. That is how my TeacherSelect is being displayed when I look at it in Firebug. So I take it that my value is not being set the right way somewhere. I will have to play around with it a bit. Thanks for all your help.

I do not have the code as I am using a built in feature in the joomla component fabrik. Attached is a screenshot of the page where I set the database join. It doesn't use normal CONCAT syntax (from what I can tell from the popup window). [attachment deleted by admin]

I found the problem, now I need your help to fix it (sound familiar ) Ok, I did a query on tea_tbl from the mysql console. I did And it returned my teacher names properly formated. ie. Smith, John Then I tried a query on TeacherSelect using the following And it only returned the last names. ie. Smith. The form that feeds tea_tbl allows an end-user to input a First Name, and a Last Name. The form that feeds attn_track uses a database join and a concat function to join the two. They show up properly in all of my tables and forms, but apparently the query doesn't like the comma inbetween the two. Any ideas on how to fix this?