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) .
"<br>" . htmlspecialchars($sql,ENT_QUOTES) . "'}}";
}
else
{
echo "{success: true, total: 1, results:[" . json_encode($cust) . "]}";
}
On Tue, September 22, 2009 22:11, lists-mysql wrote:
> 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 ------------
>> Date: Tuesday, September 22, 2009 10:02:06 PM +0200
>> From: Mogens Melander <mog...@fumlersoft.dk>
>> To: mysql@lists.mysql.com
>> Subject: Wierd PHP/MySQL result
>>
>> 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: 5.1.22-rc-log Source distribution
>> PHP 5.2.9 (cli) (built: Mar 31 2009 18:41:50)
>> Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8k DAV/2 PHP/5.2.9
>>
>> The SQL:
>>
>> select c.id, c.owner, if(c.owner > 0, s.name, 'Unknown') oname
>> , c.fname, c.lname, c.addr1, c.addr2, c.zipcode, c.city
>> , c.phone, c.mobile, c.email, c.web, c.saldo
>> from customer c
>> left join shop s on s.id=c.owner
>> where c.id = 1;
>>
>> Result from PHP:
>>
>> "id":"1"
>> ,"owner":"2"
>> ,"oname":null <======= Problem data
>> ,"fname":"Jane"
>> ,"lname":"Doe"
>> ,"addr1":"Solvej 1"
>> ,"addr2":""
>> ,"zipcode":"1234"
>> ,"city":"Sommerby"
>> ,"phone":"11 22 33 44"
>> ,"mobile":""
>> ,"email":""
>> ,"web":""
>> ,"saldo":"-7500.00"
>>
>> Result from MySQL console/query-browser:
>>
>> 1
>> , 2
>> , 'Long description' <==== Correct data
>> , 'Jane'
>> , 'Doe'
>> , 'Solvej 1'
>> , ''
>> , '1234'
>> , 'Sommerby'
>> , '11 22 33 44'
>> , ''
>> , ''
>> , ''
>> , -7500.00
>>
--
Later
Mogens Melander
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
