fetching values

[skdzines]

How do I grab the values stored in the fields 'startdate' and 'cycle' that belong to the row with OrderID? This is the code I'm using:

<?
$dbh=mysql_connect ("localhost", "whatnott_user", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("whatnott_customer");
?>
<?
if($form=="form1"){
	if(empty($orderID)){
		$error.="You must enter your Order ID number.<br>\n";
	}
$ID=mysql_fetch_row(mysql_query("select ID from customer_info where ID='".addslashes(trim($orderID))."'"));
if ($ID[0]<=0){
		$error.="There is no matching Order ID in our Database.<br>\n";
	}else{
		$startdate=mysql_query("select startdate from customer_info where ID='".addslashes(trim($orderID))."'");
		$cycle=mysql_query("select cycle from customer_info where ID='".addslashes(trim($orderID))."'");
	}
	if(!empty($error)){
		$form="form1";
	}else{
		$form="form2";
	}
}
?>

I can get it to verify that the orderID exist in the database. But from there it isn't grabbing the values stored in 'startdate' and 'cycle' that belong to the supplied orderID.

This is what I get back as my value:
Resource id #4
Resource id #5

Can someone please help me?

[LordShryku]

Well, all of this could be done in one query, you know...

$sql = mysql_query("SELECT ID, startdate, cycle
                    FROM customer_info 
                    WHERE ID = '".addslashes(trim($orderID))."'"); 
if(mysql_num_rows($sql) <= 0) {
    $error.="There is no matching Order ID in our Database.<br>\n"; 
}
else {
    while($row=mysql_fetch_array) {
        $id = $row['ID'];
        $sdate = $row['stardate'];
        $cycle = $row['cycle'];
    }
}

[skdzines]

okay, I tried what you said and I get this error:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/whatnott/public_html/updatebilling.php on line 580

I basically took your code and copied it into my script. Can you help?

Thanks

[LordShryku]

That's a pretty low max execution time. Something is taking a while though. The answer to your original question is that you weren't fetching the rows. You were just performing the queries. Couldn't tell you why it's taking so long though.

[skdzines]

will this pretty much do the same thing, just not perform a while loop?

if($form=="form1"){
	if(empty($orderID)){
		$error.="You must enter your Order ID number.<br>\n";
	}
$ID=mysql_fetch_row(mysql_query("SELECT ID, startdate, cycle FROM customer_info WHERE ID='".addslashes(trim($orderID))."'"));
if ($ID[0]<=0){
		$error.="There is no matching Order ID in our Database.<br>\n";
	}else{
		$row=mysql_fetch_array;
		$startdate=$row['stardate']; 
		$cycle=$row['cycle']; 
	}

Also, I'm getting back 'm' for both values when startdate should be '2003-09-07' and cycle should be 'm1'

Thanks

[LordShryku]

Remove all this

}else{ 
        $row=mysql_fetch_array; 
        $startdate=$row['stardate'];  

        $cycle=$row['cycle'];  

    }

Your stardate will be $ID[1] and your cycle will be $ID[2]. Both were done on your mysql_fetch_row

[skdzines]

okay, changed that now and now I get back 'y' and 's'. I don't know. I know it is validating the order number because if I change it by one number, I get the error otherwise it passes.

I don't know what to do.

Thanks.

[skdzines]

Nevermind, got it.

Thank you very much.