how can i select this item in array?

Question

Hello i made this query for wordpress plugin

$anyOne = $wpdb->get_results("SELECT MAX(id) as idlastest FROM " . $table_name_for_select . " WHERE drJlDate='".$dkdrbooking_for_compare."'");

the value in $anyOne is

Array ( [0] => stdClass Object ( [idlastest] => 32 ) )

I need to get 32 to use it in another query, but i can't select that. How can I get idlastest from this array ? I tried this code, but it didn't work

echo 'lastestID is : '.$myIds[0]['idlastest'];

http://stackoverflow.com/questions/5156841/stdclass-object-and-array-how-to-using-php here, I hope it helps. — Danielius, Jul 27 '16 at 06:47

score 1 · Answer 1 · answered Jul 27 '16 at 06:53

1

As you want to fetch single record use get_row function instead of get_results. And if you want to get results in array instead of object you can pass argument "ARRAY_A" in function as below.

//Change in query

$anyOne = $wpdb->get_row("SELECT MAX(id) as idlastest FROM " . $table_name_for_select . " WHERE drJlDate='".$dkdrbooking_for_compare."'",ARRAY_A);

//Fetch result

echo 'lastestID is : '.$anyOne['idlastest'];

answered Jul 27 '16 at 06:53

Rahul Patel

5,248
2
14
26

hi tnx for ur answer acutyl i need run this quary $anyOne = $wpdb->get_results("SELECT drTurn FROM ".$table_name_for_select." WHERE id = (SELECT MAX(id) as lastestid from ".$table_name_for_select." WHERE drJlDate ='".$dkdrbooking_for_compare."')"); – A.imahrap Jul 27 '16 at 07:00
but it show me nothig and i chose write it some part – A.imahrap Jul 27 '16 at 07:01
@A.imahrap Ok got it. – Rahul Patel Jul 27 '16 at 07:03
Yes, if you want to fetch only one record then get_row is better choice than get_results. – Rahul Patel Jul 27 '16 at 07:08
tnx so much Rahul , i useing get_row , and my long qury work too , i new in stackoverflow , for show tanx to u just can give u vote ? or i can do anythig ? – A.imahrap Jul 27 '16 at 07:11
and can i use get_var too ? – A.imahrap Jul 27 '16 at 07:13
Your welcome :) your vote is enough my friend.. you can accept my answer as well but you have done it already by accepting Rakesh's answer so that's ok. No problem. – Rahul Patel Jul 27 '16 at 07:13

score 0 · Accepted Answer · answered Jul 27 '16 at 06:45

0

This is an object in your array, so use -> to get object value

echo 'lastestID is : '.$myIds[0]->idlastest;

answered Jul 27 '16 at 06:45

Rakesh Sharma

13,680
5
37
44

2

11.3k. don't you think it will be good to give comment rather than answer this type of question? but no offense, the green numbers shown by stack attracts every one. – Alive to die - Anant Jul 27 '16 at 06:48
@Anant If comment can describe answer, why here answer option? i really appreciate your word and thanks to show me my position – Rakesh Sharma Jul 27 '16 at 06:50
sorry need w8 for 6 min to chose this answer currect – A.imahrap Jul 27 '16 at 06:54
@Anant It's only help to OP whether you give comment or answer it's your opinion. You can dislike if not agree – Rakesh Sharma Jul 27 '16 at 06:58
@Anant Thanks let's move forward – Rakesh Sharma Jul 27 '16 at 07:02

how can i select this item in array?

2 Answers2