php code to rearrange row order in database on update of selected row -

-

tablename: news

column:

headline, send_sub_top, sub_top_priority.

below table structure in database.

i need when update selected row form. updates send_sub_top = "inactive" in database , rearrange order of sub_top_priority column in database.

for example:

if delete row 3 in database update send_sub_top = "inactive" of row 3 , sub_top_priority = 0 of row 3 , rearrange order of sub_top_priority column in ascending order 1,2,3,4.

i create code update send_sub_top column = inactive in database not rearrange sub_top_priority order...

my code example -- code update send_sub_top = inactive , keep sub_top_priority column order like...

after deleting 3rd row 1,2,4,5. need 1,2,3,4.

id  headline            send_sub_top               sub_top_priority   1                    active                            1  2    test                active                             2  3    nice                active                             3   4    great               active                             4  5    demo               active                              5

plz me....thanks in advance..

below code...

<?php                                   foreach($sub_top_select $sub_top)                 {                                        ?>             <li><a href="javascript:return(0);" remove_sub_top_news="<?php echo $sub_top['id']; ?>">                 <img src="img/error.png" height="14px" width="14px" /></a></li>                 <?php } ?>

php code update inactive in database...

but need rearrange order of sub_top_priority column in ascending order 1,2,3,4.

<?php if(isset($_post['remove_sub_top_news']))     {            $id = mysql_real_escape_string(trim(htmlspecialchars($_post['remove_sub_top_news'])));               $sql = "select id,send_sub_top news id='$id'";         $result = mysql_query($sql);                 $row = mysql_fetch_assoc($result);               mysql_query("update news set send_sub_top='inactive' id=".mysql_real_escape_string(trim(htmlspecialchars($_post['remove_sub_top_news']))));                if(mysql_affected_rows() > 0)         {                        $_session['message'] = "news removed subtop successfully";             header("location:sethomepage.php");             exit;         }            } ?>

first update send_sub_top value.

then select data table condition set_sub_top = 'active' , order sub_top_priority ascending.

then looping whole data of select query update sub_top_priority increment of 1.

nb : method if there not data in table.


Comments

Post a Comment

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

-
i getting error message , further 1 here: failed read artifact descriptor org.apache.maven.plugins:maven-install-plugin:jar:2.4: even though when go .m2 repository path c:\users\a591024.m2\repository\org\apache\maven\plugins\maven-resources-plugin\2.4 the maven-resources-plugin-2.4.jar file there , maven-resources-plugin-2.4.pom there. have tried delete .m2 repository no luck. far maven not build project desperately need to. any ideas? it seems proxy issue please aad following in setting.xml grabbing lan setting , proxy information. <proxies> <proxy> <id>proxy</id> <active>true</active> <protocol>http</protocol> <host>hostname</host> <port>port</port> </proxy> </proxies> this frequent issue, please see below link well. plugin org.apache.maven.plugins:maven-clean-plugin:2.5 or 1 of dependencies not resolved maven: failed ret...
Read more

Round ImageView Android -

-
Image
i working on android application in doing rounded image view. working fine images, images 160x120 resolution shows oval shaped. code custom imageview given below, please me out here: public class roundimage extends drawable { private final bitmap mbitmap; private final paint mpaint; private final rectf mrectf; private final int mbitmapwidth; private final int mbitmapheight; public roundimage(bitmap bitmap) { mbitmap = bitmap; mrectf = new rectf(); mpaint = new paint(); mpaint.setantialias(true); mpaint.setdither(true); final bitmapshader shader = new bitmapshader(bitmap, shader.tilemode.clamp, shader.tilemode.clamp); mpaint.setshader(shader); mbitmapwidth = mbitmap.getwidth(); mbitmapheight = mbitmap.getheight(); } @override public void draw(canvas canvas) { canvas.drawoval(mrectf, mpaint); } @override protected void onboundschange(rect bound...
Read more

How can I utilize Yahoo Weather API in android -

-
Image
i want develop app using yahoo weather api android. want current , forecast weather details. i have tried different sources (e.g.: https://github.com/survivingwithandroid/weatherlib , getting error weatherlib api android , unable execute activity in android weatherlib ) , getting different errors m unable resplve. there can proper tutorial or guide! error: -17 08:50:48.961 3168-3168/com.survivingwithandroid.weather e/androidruntime﹕ fatal exception: main process: com.survivingwithandroid.weather, pid: 3168 java.lang.runtimeexception: unable start activity componentinfo{com.survivingwithandroid.weather/com.survivingwithandroid.weather.mainactivity}: java.lang.nullpointerexception: attempt invoke interface method 'boolean java.util.list.isempty()' on null object reference @ android.app.activitythread.performlaunchactivity(activitythread.java:2298) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2360) @ android.app.activi...
Read more