How to seperate the datas when jquery get them from mysql?

ChkNewRspLive.php

<?php
    $query3 = "SELECT msgid, id FROM rspnotificationlive WHERE username='{$username1}' ORDER BY id LIMI开发者_StackOverflow中文版T 99";
    $result3 = mysql_query($query3,$connection) or die (mysql_error());
    confirm_query($result3); 
    $numrspmsg = mysql_num_rows($result3);
    echo $numrspmsg . "|";
    while($userinfo3 = mysql_fetch_array($result3)){
        $rspmsgid= $userinfo3['msgid'];
        $msgid= $userinfo3['id'];
        echo $rspmsgid . ", ";
    }
?>

index.html

<script type="text/javascript">
$.get("ChkNewRspLive.php?username=" + username, function(newrspmsg){
        var mySplitResult = newrspmsg.split("|");
        var rspMsgCount = parseFloat(mySplitResult[0]);
        var rspMsgids =(mySplitResult[1]);
        var Msgids = ??//how to get this result from ChkNewRspLive.php ?
});
</script>

As you can see, I used "|" to separate $rspmsgid and $numrspmsg. I also use "," to separate multiple $rspmsgid. How if I want to separate another data $msgid? How to do that?

If I use | to separate $rspmsgid and $msgid, there will be many sign of | because they both are in the while loop.

---

JSON encode your content.

In your php, change your code to something like:

  $json = array();
    while($userinfo3 = mysql_fetch_array($result3)){
        $rspmsgid= $userinfo3['msgid'];
        $msgid= $userinfo3['id'];
        $json[] = array($rspmsgid,$msgid);
    }
  echo json_encode($json);

and then use $.getJson in your javascript.

You won't have to define the number of mysql_rows either, as you can just get that in javascript by using .length on the json data.

edit and escape your string before using it in your SQL!

---

You are already using the .split() method to seperate the other string. Apply it to the other part and let it split by ", " or just use another | instead of the , and you will have it split into three parts instead of two.

However I suggest you have a look at JSON. This should be the better solution if it gets more complicated.