Hi
IF I want to crossevaluate two variables (don't know yet how I will do it). Those variables should be in different tables or I could have 'em on the same table.??
Also, (to my best knowledge) I should be able to export the values with phpMyAdmin into csv and evaluate then in an Statistical Analysis software like SPSS. Please clarify how I should manage this.
TIA
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 07:01 AM
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 06:41 AM
- ehdwma created topic »Hide "Register new account" and change template to 3 col« 06:27 AM
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 01:29 AM
- mdee created topic »How to implement returnpage ?« 01:00 AM
- nestormateo responded to »Fillters in Clip« 24. May
- damon responded to »Can the Updated Version Check be Turned Off (Z 1.3)« 24. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
MySQL Question, CrossTabs, Tables
-
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 413
What exactly are you trying to accomplish here?? I guess if you could explain in a bit more detail what you are trying to accomplish we could direct you a bit better. If you are trying to do a compare tabel to table, or count instances of an elment in a table I would suggest using the Perl DBI or as you said pull the data out to a CSV and then parse on that data.
-SUNADMN -
**unknown user**
- Rank: Helper
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 822
Hi
I will be trying to analyze some variables that exists within a table. Hmmm, not clear yet how I will do it. IF I use CSV, it will not be interactive or dinamic. However it will be much easy and practical.
Maybe CSV is the way to go for the short term.
Thanks anyway. -
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 413
I would really look towards using the Perl DBI then ( goto http://search.cpan.org ) load that on your box and the correct MySQL driver and this should make your life easier, and if you get lost check out http://www.perlmonks.org for some help. This is going to be the best way I can think of to do things dynamic.
-SUNADMN
- Moderated by:
- Support
