Do you have an example for that? I'm not sure I know how to do what you are talking about.

ok, is this code ok now? will it work? $con = mysqli_connect("host", "user", "pass", "db"); $query = mysqli_query($con, 'SELECT * FROM `jaralele` ORDER BY `index` DESC LIMIT 3'); $response = mysqli_fetch_assoc($query); $response[success] = false; while($row = mysqli_fetch_array($query)){ $response["success"] = true; $response["index"] = index; $response["title"] = title; $response["comment"] = comment; } echo json_encode($response);

I'm not sure why, but I'm getting a warning saying "mysql_fetch_assoc" is "deprecated in the current version of PHP". also how the array will look like when it gets back? I don't really sure how to behave with him in my java code.

Hi, first of all thank you! just to be sure, what are these lines do? $statement = mysqli_prepare($con, "SELECT * FROM jaralele ORDER BY index DESC LIMIT 3); mysqli_stmt_bind_param($statement, "iss", $index, $title, $comment); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_stmt_bind_result($statement, $index, $title, $comment); $response = array(); $response["success"] = false; I found them in the internet and used them with the login system.. also I need all rows to be returned like this: while(mysqli_stmt_fetch($statement)){ $response["success"] = true; $response["index"] = $index; $response["title"] = $title; $response["comment"] = $comment; } echo json_encode($response); getting them inside a variable and then returning the variable at the end. is that possible like you did just splitting it and using a variable instead of echo?

thank you! I will try and get the parts I understand to a code and then I hope things will get clearer.

OK, so I have a table that has 3 Variables: int index (auto increment), String title, String comment. I want the PHP code to take the last 3 rows of the table (the rows with the biggest indexes), and return them to the java code I already built to use them. I dont know how to code PHP and therefore I don't know what to do after the "import" of the variables from the MySQL table. And thank you vary much for doing this!

ok, can you guide me though it? also, what do I need to change in my code after adding a Query for the code to work and return me those 9 variables at the end?

ok, I changed it in my code, but I still don't get how to continue this afterwords, I want to get those int and 2 strings from every raw in the 3 and return them in the end.. how do I do it?

I have another code in java that calls this PHP code. it's going back to the code there, and I want 9 of them to go back instead of 3, just don't know how..

OK, if I do, my problem is I don't know how to get them to work at the end of the code. I have this old code that I did to get one row and it worked fine. but I'm not sure how to do the same but with multiple rows.. Old Code: <?php $con = mysqli_connect("", "", "", ""); $index = $_POST["index"]; $statement = mysqli_prepare($con, "SELECT * FROM jaralele WHERE index = ?"); mysqli_stmt_bind_param($statement, "iss", $index, $title, $comment); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_stmt_bind_result($statement, $index, $title, $comment); $response = array(); $response["success"] = false; while(mysqli_stmt_fetch($statement)){ $response["success"] = true; $response["index"] = $index; $response["title"] = $title; $response["comment"] = $comment; } echo json_encode($response); ?>