mysql - Displaying result of same column but having different values in php -

-

I have the following php code that queries the database of my database according to the place. The table structure is as follows: 

  s / n | List number | No Property. Location ===== +======================================= 1 | 125 A | 5245 | London 2 | 1254b. 7545 | London 3 | 128a. 5645 | New York 4 | 254b. 1545 | Tokyo 5 | 6545 | 1456 | Tokyo   
 and code:  
  $ location = $ _ POST ['loc']; Foreign currency ($ location $ chk1) {echo "
"; $ Sql ​​= "SELECT * from desktop where place = '$ chk1';"; $ Result = mysql_query ($ SQL); If ($ result == zero) {echo '& lt; Script & gt; Warning ("No entry for the place". $ Chk1. 'Anditem' .desktopreturned "); ; Continue;; $ Row = mysql_fetch_array ($ result); if ($ line = = Null) {echo '& lt; script & gt; warning ("no entry for the place. $ Chk1." And the item'. Desktop returned '); ;; Continue; } Mysql_data_seek ($ result, 0);? & Gt; & lt; table limit = '1' id = "desktop" caption = & lt ;? php $ location? & Gt; & gt; & lt; tr & gt;  & gt; & gt; S / N & lt; / th & gt; & lt; th & gt; Inventory Number & lt; / th & gt; & lt; th & gt; Asset Number & lt; / th & Gt; & lt; Place & gt; Place & lt; / th & gt; & lt; / tr & gt; & lt ;? php while ($ row = mysql_fetch_array ($ result)) {? & Gt; tr class = "alt "& Gt; & lt ;? php echo '& lt; Td> ". $ Line ['s / n']" & lt; / TD & gt; "; echo" & lt; Td & gt; ". $ Line ['inventory no']" & lt; / TD & gt; "; echo" & lt; Td> ". $ Line ['asset number']" & lt; / TD & gt; "; echo" & lt; Td & gt; ". $ Line ['place']" & lt; / TD & gt; "; echo" & lt; / Tr> ";} resounds" & lt; / Table> ";}   
  Edit:  CSS code:  
  #desktop {font-family:" Trebuchet MS ", Ariel, Helvetica, Sans Serif; width: 100%; boundary-fall: collapse;} #desktop th {font-size: 1.1em; text align: left; padding-top: 5px; padding-bottom : 4px; Background color: # FFCC 33; Color: #ffffff;} #desktop td, #desktop th {font-size: 1em; boundary: 1 px solid # ffcc 33; padding: 3px 7px 2px 7px;} #desktop tr .alt td {color: # 000000; background color: #FFFFCC;}   
 here, selected as  $ location  html  
 The results of the return of the query should be differently displayed in the form of a table, it is currently displaying the result of different place as well as its There are different tables with table-maters, I have to add the returned query to a variable.   
 
 
 This code Try with, I've changed the location to the default array by London,  
 Ild changed case name should be the first letter capital hope this help :)  
  $ location = array ( 'London', 'Tokyo'); $ Str = '& Lt; Table range = "1" id = "desktop" & gt; & Lt; TR & gt; & Lt; Th & gt; S / N & lt; / Th & gt; & Lt; Th & gt; Inventory Number & lt; / Th & gt; & Lt; Th & gt; Asset no & lt; / Th & gt; & Lt; Th & gt; Place & lt; / Th & gt; & Lt; / TR & gt; '; Foreign currency ($ location $ chk1) {echo "
"; $ Sql ​​= "SELECT * from desktop where place = '$ chk1';"; $ Result = mysql_query ($ SQL); If ($ result == zero) {echo '& lt; Script & gt; Warning ("No entry for the place". $ Chk1. 'Anditem' .desktopreturned "); ; Continue;; $ Row = mysql_fetch_array ($ result); if ($ line = = Null) {echo '& lt; script & gt; warning ("no entry for the place. $ Chk1." And the item'. Desktop returned '); ;; Continue; } Mysql_data_seek ($ result, 0); while ($ line = mysql_fetch_array ($ result)) {$ str. = '& Lt; tr class = "alt" & gt; & lt; td & gt;' $ line [ 'Sr'] '& lt; / td & gt; & lt; td & gt;'. $ Line ['inventory_no'] '& lt; / td & gt; & lt; td & gt;'. ['Asset_no'] '& lt; / td & gt; & lt; td & gt;'. $ Line ['location'] '& lt; / td> gt; & lt; / tr & gt;'; }} $ Str. = '& Lt; / table & gt;'; Copy $ str;? & Gt;

Comments

Post a Comment

Popular posts from this blog

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

php - how to change mysql_result($res, 0, "url"); to mysqli -

-
I do not know how to use mysqli_result like in the past. Is this OK? How is right WHERE status = 'popup' and creditsp> = 1 and (CH) from $ res = mysqli_query ($ con, "SELECT` id`,` usrid`, `url` site Lt; cf || cf = 0) sequence by rand () border 1 "); $ Urll = mysqli_result ($ res, 0, "url"); $ Ownerid = mysqli_result ($ res, 0, "Elixir"); $ Citid = mascile_salt ($ res, 0, "id"); Use fetch_assoc on the results: $ line = $ res-> gt; Fetch_assoc (); $ Urll = $ line ['url']; $ Owner = $ line ['nectar']; $ Site id = $ line ['id']; If there are more than one line, then: while ($ line = $ res-> fetch_assoc ()) {// process $ Line}
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