How to split query results

-

does if there method split results of query based on specific number stop , split at?

 

for example, want pull out of these numbers database....say 1 - 20. want show them on page in order, want stop once hit preset number, 12.5, continue on.  need way show this:

 

my numbers:

1,2,3,4,5,6,7,8,9,10,11,12,.5

total equalling 12.5

 

numbers after split:

.5,14,15,16,17,18,19,20

total above 12.5

 

i'm adding numbers in database, need cut off @ predetermined point (in example 12.5) , start rest after point.

 

right i'm using coding tries split results users input , insert them database. i'm running problems displaying data correctly though. seems make more sense input normally, display , spit there.

 

any in right direction appreciated. i'm stumped on this!

query of queries work.



More discussions in Advanced Techniques


adobe

Comments

Post a Comment

Popular posts from this blog

Help with codes to add 1 more shift register and add more to matrix LED

-
hi im working on 8x10 matrix leds , successful @ using guide http://www.instructables.com/id/810-led-matrix-with-4017/ using 4017 , 74hc595 now want expand matrix 16x10. i connected , worked added 74hc595 control second 8x10. my problem want display text using both 8x10 im using code guide , modified think doesnt work code: [select] #define someshape    {b0100001001000010,b1110011101000010,b0100001001000010,b0000000001000010,b0001100001000010,b0001100001000010,b1000000101000010,b1000000101000010,b0100001001000010,b0011110001000010  }    #define all     {b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111,b1111111111111111  }                        #define someshape2   {b0100001001000010,b1110011101000010,b0100001001000010,b0000000001000010,b000110000100001...
Read more

tcp client

-
i'm using arduino uno , w5100 ethernet shield. i'm trying connect ethernet shield software downloaded ( sockettest v3.00) communication between server (sockettest) , shield (client).the shield jack connected router. created server under ip address of laptop. uses telnet client example can't connect server on sockettest. first time i'm doing tcp/ip , had done similar project or guide me on this. sockettest - http://sockettest.sourceforge.net/ uno - https://store.arduino.cc/arduino-uno-rev3 ethernet shield - http://www.hobbytronics.co.uk/arduino-wiznet-shield here code -------------------- code: [select] #include <spi.h> #include <ethernet.h> byte mac[] = {   0xde, 0xad, 0xbe, 0xef, 0xfe, 0xed }; ipaddress ip(192, 168, 1, 220);// shield ip ipaddress server(192, 168, 1, 37); // computer ip ethernetclient client; void setup() {   // start ethernet connection:   ethernet.begin(mac, ip);// open serial communications , wait port open: ...
Read more

Can't read sms using Thinker A7 communicate with Arduino

-
Image
hi guy i'm trying communicate ai thinker a7 module. on arduino uno r3 im using pin 7,pin 8 connect utxd & uaxd. when send sms phone module thinker 7, use arduino read sms. my code bellow code: [select] #include <softwareserial.h> #include <string.h> char incoming_char = 0; softwareserial cell(7, 8); //my shield uses these pins software serial. void setup() {  serial.begin(115200);  cell.begin(115200);  delay(2000);  serial.print("starting modem communication...");  delay(12000);  serial.print("ok\nintroduce @ commands:\n"); } void loop() {  if(cell.available() > 0)  {    incoming_char=cell.read();        if(incoming_char=="a"){      serial.println("content of sms a"); //if sms contains "#" arduino looks commands follow.      serial.println(incoming_char);    }    else    { ...
Read more