[RESOLVED] Value Cut Short From Query Result

[obrienkev]

Hi all,

I want to pass results from db query into textfield.

However, for the spin_offs it is passed in as this:
<input type="checkbox" name="file[]" id="file[]" value="spin_of,test" />

Why is the end fs cut off??

Code...

$query = "SELECT 'mergers' AS tbl, name FROM centralised_archive.mergers ".
         "UNION SELECT 'rights' AS tbl, name FROM centralised_archive.rights ".
         "UNION SELECT 'spin_offs' AS tbl, name FROM centralised_archive.spin_offs ".
         "UNION SELECT 'splits' AS tbl, name FROM centralised_archive.splits ".
				 "UNION SELECT 'mergers' AS tbl, name FROM mergers ".
         "UNION SELECT 'rights' AS tbl, name FROM rights ".
         "UNION SELECT 'spin_offs' AS tbl, name FROM spin_offs ".
         "UNION SELECT 'splits' AS tbl, name FROM splits";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{    

   echo '<tr><td><input type="checkbox" name="file[]" id="file[]" value="' . $row['tbl'] . ',' . $row['name'].'" /></td><td>'.$row['name'].'</td></tr>';
}

Thanks.

[Roger_Ramjet]

Because, as I mentioned the first time, early versions of mysql take the length of the literal in the first select and apply that as the column length to all the selects that follow. In this case, the column length of tbl is set as 7 chars, the number of chars in 'mergers', and so anything over 7 chars is truncated (spin_offs = 9 chars becomes spin_of = 7 chars). Simple fix is to put the longest table name in the first select. Better would be to upgrade to version MySQL 4.1.1 or later as they do not behave like that, ie no truncation.

[obrienkev]

Hi Roger,

Thanks for that.

I am certain that I installed version 4.1 but in my phpinfo it is down as 3.23.49

PHPMyAdmin tells me it is MySQL 4.0.23.

Why is this??

How easy is it to upgrade?

Thanks.

[Roger_Ramjet]

No idea - I use shared hosting so I've never had to, or been able to, upgrade.