Upgraded to php 4.2.1, broke a script

Kevin Brown plug-discuss@lists.plug.phoenix.az.us
Wed, 15 May 2002 18:19:11 -0700


> % Kevin Brown (kevin_brown@qwest.net) wrote:
> > [ script broke on upgrade from 4.1.2 ]
> >
> 
> php finally get to the magic combination of numerals for an upgrade?  ;)
> 
> psycho.
>
> > show_image.php:
> >
> > <?
> > include("movie_conf.php");
> > dbConnect();
> >
> > $get_image = "select binary_junk, filetype from images where img_id = '$imgid'";
> > $get_image_result = mysql_query($get_image);
> >
> 
> // May i suggest incrementing by one?
> > $binary_junk = mysql_result($get_image_result,0,"binary_junk");
> $binary_junk = mysql_result($get_image_result,1,"binary_junk");
> > $filetype = mysql_result($get_image_result,0,"filetype");
> $filetype = mysql_result($get_image_result,1,"filetype");
> 
> Possibly the indexing scheme went from array to count in the newer
> versions?

Same thing:

Warning: Unable to jump to row 1 on MySQL result index 2 in
/home/httpd/html/movies/show_image.php on line 8

Warning: Unable to jump to row 1 on MySQL result index 2 in
/home/httpd/html/movies/show_image.php on line 9

I can perform the select statement manually in mysql and it does return a valid
result back.