Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
Yes, you are right. It's the json_encode that fail. It's strange though. The data that fail is "Humlebæk". Another query, in another form, returning "Værksted" don't fail in json_encode. echo $cust['oname'];give the correct value. On Tue, September 22, 2009 22:56, Mark Goodge wrote: > Mogen

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mark Goodge
Mogens Melander wrote: Well, no typos. The relevant piece of code: if (! $cust = mysql_fetch_assoc($res)) { echo "{success: false, errors: { reason: 'Fetch Customer failed: " . htmlspecialchars(mysql_error(),ENT_QUOTES) . "" . htmlspecialchars($sql,ENT_QU

Re: Wierd PHP/MySQL result (Solved)

2009-09-22 Thread Mogens Melander
t; You didn't show your php code, but I'd bet you have a typo, likely >> in assigning the returned value to the variable, or in the name of >> the variable you're printing. >> >> - Rick >> >> >> >> Original Message --

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
the returned value to the variable, or in the name of > the variable you're printing. > > - Rick > > > > Original Message >> Date: Tuesday, September 22, 2009 10:02:06 PM +0200 >> From: Mogens Melander >> To: mysql@lists.m

Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
Hi guys I'm getting rather confused on this thing. Results returned from mysql console/query-browser is different from what's returned from same query in PHP. Maybe someone smarter than me could shed some light on what's going on. I'm clueless :( Environment is as follow: Mysql Server version: