html - How to have title columns for each PHP column result -

-

i individual column titles display each table data column echo'd?

<form> <?php   $numerooption= $_post['numero']; $roomtype= $_post['roomtype']; $selectoption = $_post['parkname']; $query = "select * `rooms` `capacity` < '$numerooption' , `park` '$selectoption%' , `dataprojector` '$proj_check%' , `whiteboard` '$white_check%' , `ohp` '$ohp_check%' , `wheelchairaccess` '$wheel_check%' , `lecturecapture` '$cap_check%' , `style` '$roomtype%'";  $result = mysql_query($query); if ($result == false) die ("could not execute statement $query<br />"); echo "<form action='' method='post'>"; echo "<table>";   while($row = mysql_fetch_array($result)){                                echo "<tr><td>" . $row['roomcode'] . "</td>";     echo "<td>" . $row['style'] . "</td><td>" . $row['dataprojector'] . "</td>";     echo "<td>" . $row['whiteboard'] . "</td><td>" . $row['ohp'] . "</td>";     echo "<td>" . $row['wheelchairaccess'] . "</td>";     echo "<td>" . $row['lecturecapture'] . "</td>";     echo "<td><input type='radio' name='radioselect' value= '". $row['roomcode']."'></td>"; } echo "<input type='submit' name='ttroom' id='ttroom' name='ttroom'>"; echo "</tr>"; echo "</table>";  echo "</form>";

i'm not sure if understand problem, think solution simply, create header row before while condition. it's say:

...     echo "<table>";      echo '<tr>';     echo '<th>title 1</th>';     echo '<th>title 2</th>';     echo '<th>title 3</th>';     echo '<th>title 4</th>';     echo '<th>title 5</th>';     echo '</tr>';     while($row = mysql_fetch_array($result)){                                    echo "<tr><td>" . $row['roomcode'] . "</td>";         echo "<td>" . $row['style'] . "</td><td>" . $row['dataprojector'] . "</td>";         echo "<td>" . $row['whiteboard'] . "</td><td>" . $row['ohp'] . "</td>";         echo "<td>" . $row['wheelchairaccess'] . "</td>"; ...

Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more