Jump to content


Photo

Report generation


  • Please log in to reply
6 replies to this topic

#1 jana

jana
  • Members
  • PipPipPip
  • Advanced Member
  • 35 posts
  • LocationIndia

Posted 09 October 2006 - 10:23 AM

How to generate reports by getting the data from mysql? any idea
Jana

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 09 October 2006 - 10:25 AM

The question is too non-specific for anything other than a general answer.

1. Retrieve the information you want to display (SELECT query, etc.)
2. Loop through the retrieved information and display it as you see fit


Legend has it that reading the manual never killed anyone.
My site

#3 brown2005

brown2005
  • Members
  • PipPipPip
  • Advanced Member
  • 943 posts

Posted 09 October 2006 - 10:26 AM

can u post the table structure and what sort of report u want?

#4 jana

jana
  • Members
  • PipPipPip
  • Advanced Member
  • 35 posts
  • LocationIndia

Posted 09 October 2006 - 11:51 AM

i hav a table emp_master as

emp_id
emp_name
tittle
sex
dept_id
active

and i want a report in a a4 paper who are all active.
Jana

#5 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 09 October 2006 - 11:57 AM

$query = "SELECT * from emp_master WHERE active = 'something that means active'";

And how your report will look when printed depends on your printer settings, i.e. nothing to do with php.
Legend has it that reading the manual never killed anyone.
My site

#6 jana

jana
  • Members
  • PipPipPip
  • Advanced Member
  • 35 posts
  • LocationIndia

Posted 10 October 2006 - 04:58 AM

can i integrate crystal reports with php and mysql?
Jana

#7 php_coder_dvo

php_coder_dvo
  • Members
  • PipPip
  • Member
  • 18 posts
  • LocationPhilippines

Posted 10 October 2006 - 05:43 AM

can i integrate crystal reports with php and mysql?


No.... I dont think so, why not format your page in a descent view...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users