Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Database query

Comment:

I have a table with roll num,name,games. Roll num is primary key, I am able to store the data in mysql table and able to retrieve it back using PHP. I enter the details through the form using php script. 01 A Tabletennis 02 A Cricket 03 B Tabletennis 04 B Cricket 05 C Tabletennis 06 C Cricket I am able to get this using php script ROLLNUM NAME GAMES 01 A Tabletennis 02 A Cricket 03 B Tabletennis 04 B Cricket 05 C Tabletennis 06 C Cricket. But I need like Name TableTennis Cricket A 1 1 B 1 1 C 1 1 Total 3 3 How TO approach this issue? If any one has the query to process this please let me know… Thanks in Advance, its Urgent.

Schedule emails from Wind...

wipe out hard drive

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query? Life's more painless for the brainless....

Summary: http://www.amazon.com/gp/product/0596000847/103-4718587-9818261?v=glance&n=283155 I like this one. Since you can't beat Access for cross database queries, I've had to use it a lot... This helps Just i...

Summary: Hi I have form for searching one of four types here is my syntax for select : $query = "SELECT * FROM '$jobs' WHERE location ='$search'"; $jobs should show one of this: <select name="jobs" class="...