Wrox Programmer Forums
|
PHP How-To Post your "How do I do this with PHP?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 2nd, 2005, 02:56 PM
Authorized User
 
Join Date: Nov 2005
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default strange output

Hello everyone,
my mysql query output in my IE browser is strange from my mysql table. for example, when I querying a varchar type data, i got 6 for null, 4 for 12340877, and all wrong numbers for all records for this column and all other columns are correct.

Anybody can let me know what's wrong with it and how to fix it?

Thank you all all the time,
Jun

 
Old December 2nd, 2005, 08:09 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

Jun,
Check your table and verify how many numbers was setup.
For example, VARCHAR(6) should be VARCHAR(8) to accept 12340877.
Hope this helps.
John M.

 
Old December 5th, 2005, 11:30 AM
Authorized User
 
Join Date: Nov 2005
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you John for your reply and help.
the field is defined as varchar(9) and it returns 9 numbers when i query it in mysql query browser or command line, but just one number in my IE browser,which is not the first number of the correct data. I don't know why it bahaved like this.

Any idea and solution?

Thank you again,
Jun

 
Old December 8th, 2005, 02:20 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 357
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anshul
Default

There is error in your PHP code and/or your MySQL table definition. Since, machine never errors .. We can help you, but we're not having enough explanation/information from your side, to do so.

If you wanna see it yourself, please see your PHP code. You'd been doing something, that changed your output ..

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances
 
Old December 9th, 2005, 11:20 AM
Authorized User
 
Join Date: Nov 2005
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you John for your reply.
The mistake I made is $ary=array(); ... $ary=something; the correct one should be $ary[]=something. I don't know why php didn't reture any error message but the strange data?

Very appreciate it if you can let me know the reason.

Thank you for you help all the time.
Jun






Similar Threads
Thread Thread Starter Forum Replies Last Post
strange error Iguchi Visual Studio 2008 1 April 11th, 2008 06:21 AM
Really Strange... nooor83 BOOK: Professional Ajax ISBN: 978-0-471-77778-6 7 May 7th, 2006 12:51 PM
Why do my posts look strange? joefawcett Forum and Wrox.com Feedback 2 December 16th, 2004 12:04 PM
Very strange output tdaustin Classic ASP Basics 5 August 2nd, 2004 07:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.