Fork me on GitHub

MySQL Question, CrossTabs, Tables  Bottom

  • 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
  • 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
  • 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.
  • 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
  • PHP will parse a csv file. Don't really understand the initial post, maybe so you don't have another DB connection? Anyway PHP works well with csv files.

This list is based on users active over the last 60 minutes.