php - How to add BR between mysql record output -


i have php page user can select province (ex. a, b) click search. output coming database. how can group data , add br in between? example:

user choose province: prov_a output: program name: flood control-prov_a-allocation flood control-prov_a-allocation roads-prov_a-allocation roads-prov_a-allocation want seperate flood control roads. btw, i'm using wordpress this. line break between do. also, field 'allocation' excel file contain amounts 7,000,000.00 or 1,000,000.00 after importing phpmyadmin becomes 7.0 , 1.0. data field should use? codes:

$sql = "select * projects province = '$province'";                            //select database                         mysql_select_db('pdmu'); //query counting                         $query="select count(proj_id) 'cnt' `projects` province = '$province'"; $result=mysql_query($query);  $row2 = mysql_fetch_assoc($result, mysql_assoc); print_r($row2['cnt']); print_r('records found'); //echo $row2['cnt'] . 'records found!';                         $retval = mysql_query( $sql, $conn );                          if(! $retval )                         {                           die('could not data: ' . mysql_error());                         }                              echo "<table>";                             echo "<tr>";                             echo "<th>";                             echo "program name";                             echo "</th>";                             echo "<th>";                             echo "province";                             echo "</th>";                             echo "<th>";                             echo "municipality/city";                             echo "</th>";                             echo "<th>";                             echo "no. of project";                             echo "</th>";                             echo "<th>";                             echo "project name";                             echo "</th>";                             echo "<th>";                             echo "allocation";                             echo "</th>";                             echo "<th>";                             echo "physical status";                             echo "</th>";                             echo "<th>";                             echo "financial status";                             echo "</th>";                             echo "<th>";                             echo "remarks";                             echo "</th>";                             echo "</tr>";                             echo $count . $row2;                             while($row = mysql_fetch_array($retval, mysql_assoc))                         {                         echo '<tr>' . '<td>' . $row['prog_name'] . '</td>' . '<td>' . $row['province'] . '</td>' . '<td>' . $row['municipality'] . '</td>' . '<td>' . $row['proj_no'] . '</td>' . '<td>' . $row['proj_name'] . '</td>' . '<td>' . $row['allocation'] . '</td>' . '<td>' . $row['ph_status'] . '</td>' . '<td>' . $row['fin_status'] . '</td>' . '<td>' . $row['remarks'] . '</td>' .'</tr>';}                          mysql_close($conn); 

<?php  $sql = "select * projects province = '$province'";                        //select database                     mysql_select_db('pdmu'); //query counting                         $query="select count(proj_id) 'cnt' `projects` province = '$province'"; $result=mysql_query($query);   ?>  <?php $row = mysql_fetch_assoc($result);     while($row_result = mysql_fetch_array($retval, mysql_assoc))    { ?>  <tr>   <td><?=$row_result['your fields'];?></td> </tr>  <?php } ?>

Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more