DaniWeb Forum Index > Web Development > PHP

json and multi-dimensional array

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2009

Posts: 25

Reputation: garcon1986 is an unknown quantity at this point

Solved Threads: 0

garcon1986 garcon1986 is offline

Offline

Light Poster

json and multi-dimensional array

20 Days Ago

Hello everyone,

I have a problem when i use json and array. And i need your help.

Here is my code:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
		while($row = mysql_fetch_assoc($result)){
			echo json_encode($row);
		}
		while($row = mysql_fetch_assoc($result)){
			echo json_encode($row);
		}

The result is:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null}{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}
{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null}{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}

But i want the result is like this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 [{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null},{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}]
 [{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null},{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}]