Need some serious help

[Cerial_Killer]

Hello there I have this script

<?PHP
// include the class
include ('class.label.php');
if ($start > 1){
$info=array(1=>array('line1'=>' ','line2'=>' ','line3'=>' ','line4'=>' '));

if ($start > 2){
		$info.=array(2=>array('line1'=>'       ','line2'=>'      ','line3'=>'      ','line4'=>'     '));
		}  	   
if ($start > 3){			
		$info.=array(3=>array('line1'=>'       ','line2'=>'      ','line3'=>'      ','line4'=>'     '));
	    }
if ($start > 4){
		$info.=array(4=>array('line1'=>'       ','line2'=>'      ','line3'=>'      ','line4'=>'     '));
	    }
if ($start > 5){			
		$info.=array(5=>array('line1'=>'       ','line2'=>'      ','line3'=>'      ','line4'=>'     '));
	    }
		}

$startdate = $SYear . $SMonth . $SDay . '000000';
$enddate = $EYear . $EMonth . $EDay . '999999';

$db = mysql_connect("localhost", "boostaroo", "ambdbs7");
if (!$db) {
printf("MySQL Error %s<br/>\n", mysql_error());
}
mysql_select_db("boostaroo",$db);
$sql = "SELECT * FROM orders WHERE dateadded >= '$startdate' AND dateadded <= '$enddate'";

$result = mysql_query($sql,$db);
if ($myrow = mysql_fetch_array($result)) {
// choose a labeltype
$labeltype="allmedia";
// create a new instance of the class of that labeltype
$label= new Clabel($labeltype);
do {
$line1 = $myrow['shiptofirstname'] . ' ' . $myrow['shiptolastname'];
$line2 = $myrow['shiptoaddress'];
$line3 = $myrow['shiptoaddress2'];
$line4 = $myrow['shiptocity'] . ', ' . $myrow['shiptostate'] . ' ' . $myrow['shiptozip'];
$info.=array($start=>array('line1'=>$line1 ,'line2'=>$line2 ,'line3'=>$line3 ,'line4'=>$line4));
$start++;
}while ($myrow = mysql_fetch_array($result));
}
// make the labels! its that simple!

$label->makeLabel($info);
?>

and I keep getting this error

Call to a member function on a non-object in /usr/local/etc/httpd/htdocs/boostaro/public_html/admin/pdf/Clabel_sample.php on line 45

I am so lost I have been working on this for a week and am geting no where any help would be much apprechiated ..

[tsinka]

Hi,

please post class.label.phpas attachment. Where does $start come from ?

Thomas

[ahundiak]

The basic problem is that your SQL statement is not returning any rows and thus, $label is never getting created.

1. Troubleshoot your query. Add some error checking. Make sure you get some rows.

2. I'd suggest getting rid of the do/while construct. Just have a
   while( $myrow = mysql_fetch_array($result)
   loop. They tend to be easier to understand.