Announcement

Collapse
No announcement yet.

Loop thru records

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Loop thru records

    Hi, I'm new to scriptcase I trying to get all the record from database and display them in a multiselecttext field, I was successfully to do it on but for some reasons keep printing the field title in the first row.
    What I want to do its get access to single field of my database ( ex. Message), in order to insert an space in between and be able to format it like a real Chat window

    $varSQL = "SELECT fecha,message FROM chat where name = 'Alma' order by fecha desc " ;
    sc_select(mydata,$varSQL);
    if({mydata} ===false)
    {
    echo "Access error";
    }
    else
    {
    $i=1;

    while(!$mydata -> EOF)
    {

    {chate_area} = $i.$mydata;
    $mydata ->MoveNext();
    $i++;

    }
    $mydata->close();
    }

    It give me the following output of the picture.




  • #2
    hello, you found a way to create a CHAT project within scriptcase? Can you send some screenshot and some code?

    Comment

    Working...
    X