HOW to echo New record with selected old record in PHP Mysql? -

-

i new in php. have query

"select r.client_id,c.id,t.id,a.id,o.id,c.name cname,t.title ttitle,a.title atitle,o.title otitle, l.title ltitle, s.title stitle og_ratings r  left join og_companies c on r.client_id = c.id left join og_rating_types t on r.rating_type_id = t.id left join og_actions on r.pacra_action = a.id left join og_outlooks o on r.pacra_outlook = o.id left join og_lterms l on r.pacra_lterm = l.id left join og_sterms s on r.pacra_sterm = s.id c.id= 338 order r.id desc limit 2";

result of query is

query

now want print first row of of resulted query , success. want echo 2 columns ltitle , stitle second row. here failed.

here code

<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "pacra1";   $conn = new mysqli($servername, $username, $password, $dbname); //$id2 = $_get['id']; $sql= "select r.client_id,c.id,t.id,a.id,o.id,c.name cname,t.title ttitle,a.title atitle,o.title otitle, l.title ltitle, s.title stitle og_ratings r  left join og_companies c on r.client_id = c.id left join og_rating_types t on r.rating_type_id = t.id left join og_actions on r.pacra_action = a.id left join og_outlooks o on r.pacra_outlook = o.id left join og_lterms l on r.pacra_lterm = l.id left join og_sterms s on r.pacra_sterm = s.id c.id= 338 order r.id desc limit 1"; $result = $conn->query($sql); //$array = array('1','2','3');  while ($row = $result->fetch_assoc()){  ?>  <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>untitled document</title> </head>  <body>  <table border="1">         <tr>             <td> id </td>             <td> <?php echo $row['client_id'] ?> </td>         </tr>          <tr>              <td>name </td>             <td><?php echo $row['cname'] ?> </td>         </tr>          <tr>             <td>rating type </td>             <td><?php echo $row['ttitle'] ?> </td>         </tr>         <tr>             <td>action </td>             <td><?php echo $row['atitle'] ?> </td>         </tr>         <tr>             <td>outlook </td>             <td><?php echo $row['otitle'] ?></td>         </tr>         <tr>             <td rowspan="2">long term rating </td>             <td>current (<?php echo $row['ltitle'] ?>) <tr><td>previous (<?php echo $row['ltitle'][0] ?>)</td> </tr></td>         </tr>          <tr>             <td rowspan="2">short term rating </td>             <td>current (<?php echo $row['stitle'] ?>) <tr><td>previous (<?php echo $row['stitle'][0] ?>)</td> </tr></td>         </tr>   </table>  </body> </html>  <?php }?>

result of code is

result

in previos column of code want print second row data of db table. can see result wrong. can guys please me?

modify sql "order r.id desc limit 1,1" second row directly :)


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile:
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo
Read more