php - How to make a table print out the columns that are the same into one row? -

-

What I want to do is shown in the table. I only want to get the math subject and I want to order units from Unit 1 (UI) to the last available unit in the database; Then, within each unit, to show each unit homework related I tried to save it in an array with mysql_fetch_array but it stores the line including a unit I have all those units and only units I want them under their homework. My database is at the end of this post Hope you can help someone 

  & Lt ;! DOCTYPE html public "- // W3C // DTD XHTML 1.0 Transitional // N" "http://www.w3.org/TR/xhtml1 /DTD/xhtml1-transitional.dtd"> & Lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Top & gt; & Lt; Meta http-equiv = "content-type" content = "text / html; charset = UTF-8" /> & Lt; Title & gt; Document Sin Totillo & lt; / Title & gt; & Lt; / Head & gt; & Lt; Body & gt; & Lt; Form action = "" method = "post" name = "form1" id = "form1" & gt; & Lt; The width of the table = "200" range = "1" & gt; & Lt; TR & gt; & Lt; TD & gt; Subject: & lt; / TD & gt; & Lt; TD & gt; Mathematics & lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; UI & lt; / TD & gt; & Lt; TD & gt; UI & lt; / TD & gt; & Lt; TD & gt; UII & lt; / TD & gt; & Lt; TD & gt; UIII & lt; / TD & gt; & Lt; TD & gt; UII & lt; / TD & gt; & Lt; TD & gt; ... & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Td> Home work & lt; / Td> & Lt; Td> Math work 1 & lt; / Td> & Lt; Td> Math work 2 & lt; / Td> & Lt; Td> Math work 3 & lt; / Td> & Lt; Td> Math Work 4 & lt; / Td> & Lt; Td> Math Work 5 & lt; / Td> & Lt; TD & gt; ... & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; / TR & gt; & Lt; / Table & gt; & Lt; / Form & gt; & Lt; / Body & gt; & Lt; / Html & gt;   
 I just about math and wants with homework his units that each unit is under their My database is:  
  - phpMyAdmin SQL Dump - version 4.1.6 - http://www.phpmyadmin.net - Host: 127.0.0.1 - Generation time: July 25, 2014 05:52 AM - server version: 5.6.16 - PHP version: 5.5.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO "; SET time_jon = "+00: 00"; / *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT * /; / *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS * /; / *! 40101 SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION * /; / *! 40101 SET name utf8 * / - - Database: `School '- - ---------------------------------- --- ------------------- - Table structure for table `class` - If the table does not exist then create the table (` id`int (11) zero not AUTO_INCREMENT, `subject` varchar (30) Impedance utf8_spanish_ci not nULL,` unit` varchar (5) utf8_spanish_ci nOT nULL, `homework` varchar (50) nULL juxtaposition not nULL not utf8_spanish_ci, primary key match,` dueDate` date ( `Id`)) engine = InnoDB default charge = UTF8 calllet = UTF8_spanish_a AUTO_INCREMENT = 11; - - Table `putting in data dumping -` class` to Class` (` Id`, `Subject`,` Unit`, `Homework`,` DueDate`) values ​​(1, 'mathematics', 'UI' Math Work 1 ',' 2014-04-04 '), (2,' Math ',' UI ',' Math Work 2 ',' 2014-05-12 '), (3)' Science ',' UI ' , 'Science Work 1', '2014-04-09'), (4, 'Home Economics', 'UII', 'Home Economics Work 1', '2014-04-16'), (5) , 'UII', 'Math Work3', '2014-05-12'), (6), 'Math', 'UII', 'Math Work4', '2014-05-21'), (7) Science 'UII', 'Science Work2', '2014-05-14'), (8) 'Physics',' UI ',' Physics Work1 ',' 2014-05-06 '), (9)' Mathematics ',' UiI ',' Math Work 5 ',' 2014-07-16 '), (10,' Math ',' Uiv ',' Meth Work 6 ',' 2014-07-14 '); / *! 40101 SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT * /; / *! 40101 SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS * /; / *! 40101 SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION * /;    
 
 
 You can use  $ query = mysql_query (where "class Select * subject = 'math');  is that if you like what you are searching for, but you need more help to echo the data, I will answer with more, the topic of mathematics will select everything from the class table with information .

Comments

Post a Comment

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

-
I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
Read more

Matlab transpose a table vector -

-
An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
Read more

c# - Textbox not clickable but editable -

-
I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
Read more