php - i want to split data from database into three columns of table -



php - i want to split data from database into three columns of table -

i want split info database 3 columns of table don't how have tried it's not working please help me in advance

<?php $count=1; $query1=mysql_query(" select *,category.id ids category inner bring together products on category.`cid`=products.`cid` category.id='$id' ") or die ('product query problem'); while($row1=mysql_fetch_array($query1)) { $count++; ?>

i want split info database 3 columns of table don't how have tried it's not working please help me in advance

<div class="main_content"> <div class="featured-items clearfix"> <div class="items clearfix"> <table border="0"> <tr> <td><div class="item-block-1"> <div class="image-wrapper"> <div class="image"> <div class="overlay"> <div class="position"> <div> <p><?php echo $row1['description']; ?></p> <a href="pandora-homepage.html#" class="quickshop">quick shop</a> </div> </div> </div> <a href=""><img src="products/images/photos/photo-2.jpg" style="margin: -27.5px 0 0 0;" alt="" /></a> </div> </div> <h2><a href=""><?php echo $row1['product']; ?></a></h2> <p class="price"><?php echo $row1['price']; ?></p> </div> <?php if($count%3==1) { ?></td></tr> </table> <?php }}?> </div> </div> </div>

you find clear illustration of creating html table php here. re-create few relevant lines:

if(mysql_num_rows($result2)) { echo '<table cellpadding="0" cellspacing="0" class="db-table">'; echo '<tr><th>field</th><th>type</th><th>null</th><th>key</th><th>default<th>extra</th></tr>'; while($row2 = mysql_fetch_row($result2)) { echo '<tr>'; foreach($row2 $key=>$value) { echo '<td>',$value,'</td>'; } echo '</tr>'; } echo '</table><br />'; }

it echoing columns in table - if want different can alter inner foreach loop. hope helps!

php mysql

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more