pelowe

Tried changing the Collation on the MySQL table to utf8_bin And all works well. It's only a development MySql server so I wasn't worried about breaking the live applications. I'm not to familiar with the Collation settings in MySql so I'll need to do some heavy research before make that change across the entire db. Any help on that topic would be greatly appreciated.

The output from var_dump($row) is: PHP4 array(2) { ["yard"]=> string(22) "Chestnut Ridge Transit" ["yard_id"]=> string(1) "5" } PHP5 array(2) { [""]=> string(22) "Chestnut Ridge Transit" ["B"]=> string(1) "5" } Why would I be getting the strange characters for the field values?

I'll have to get further code tonight as this is a side job and I don't have access from my day job. But to answer the operating system question, it is Windows 2003 > Apache 2.x > MySQL 3.x

This is my dev server so I have all error turned on in both PHP4 and 5 configs. I don't have the query right in front of me but from memory I know it's pretty simple. Something like: SELECT yard, yard_id FROM yard; It just grabs the yard names (this is for a bus company) and there respective id's. And as I said it works in PHP4 So I was thinking it was some kind of syntax issue. But I haven't read or seen anything on the web that indicates any syntax backward-compatibility issues. Thanks

After migrating from PHP 4.3.10 to 5.2.8 I'm receiving an "undefined index" error from the following code... <?php while($row = mysql_fetch_array($result)){?> <input id="yard_<?php echo $row['yard_id'];?>" type="checkbox" name="yard_list[]" value="<?php echo $row['yard_id'];?>" checked> <label for="yard_<?php echo $row['yard_id'];?>"><?php echo $row['yard'];?></label><br> <?php }?> I know the mysql result is valid since it works fine in PHP4. I realize this is a little messy and should have been written a little neater. But it is old code that I wrote long ago. My problem is I have this style of coding sprinkled throughout my apps and it would be a real task to find every occurrence of it. Thanks