PHP MySQL Query Syntax

I asked a very similar question earlier and I thought I had it working.  However, I have come up with a new error and I'm not sure how to fix it:
$check_alt  = 	"SELECT meta_value
					FROM wp_woocommerce_order_itemmeta
					WHERE (meta_key = 'Bicycle Info - Primary Operator First Name'
					OR meta_key = 'Bicycle Info - Primary Operator Last Name'
					OR meta_key = 'Bicycle Info - Bicycle Serial Number'
					OR meta_key = '_line_total'
					OR meta_key = 'Select My Deductible'
					OR meta_key = 'Type of Bicycle'
					OR meta_key = 'Bicycle Info - Liability Amount'
					OR meta_key = '_subscription_status')
					AND order_item_id = :order_id ";
 

		
		$checking_alt = $pdo->prepare($check_alt);		
		$checking_alt->execute(array(':order_id' => $order_id)) or die(print_r($checking_alt -> errorInfo()));
		$res_alt = $checking_alt->fetchAll();	
				
				if ($res_alt) {
					
					echo "<pre>";
					var_dump( $res_alt );
					foreach ($res_alt as $rows)  {
						if($rows->meta_key == "_line_total") { 
							$total = $rows->meta_value;
						}				
						elseif($rows->meta_key == "Bicycle Info - Bicycle Serial Number") {
							$sn = $rows->meta_value;
						}
						elseif($rows->meta_key == "Bicycle Info - Primary Operator First Name") {
							$fn = $rows->meta_value;
						}
						elseif($rows->meta_key == "Bicycle Info - Primary Operator Last Name") {
							$ln = $rows->meta_value;
						}		
						elseif($rows->meta_key == "Bicycle Info - Deductible Amount") {
							$deduc = $rows->meta_value;
						}
						elseif($rows->meta_key == "Bicycle Info - Type of Bicycle") {
							$bike_type = $rows->meta_value;
						}
						elseif($rows->meta_key == "Bicycle Info - Liability Amount") {
							$liabil = $rows->meta_value;
						}
						elseif($rows->meta_key == '_subscription_status') {
							$status = $rows->meta_value;
						}                
					}		
				}	
			}					

Open in new window

The Var_Dump gives me all of the proper strings  But I get the error:
Undefined variable: meta_key in ... and the line above is line 24.
LVL 7
rgranlundAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GaryCommented:
SELECT meta_value,meta_key
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rgranlundAuthor Commented:
OK, That was a DUHHH moment.  Thank you again.
0
GaryCommented:
I have them all the time.
0
Ray PaseurCommented:
No points for this, please.  Anything not in the SELECT list is not in the results set.  You do not have to put columns into the SELECT list if you only want to use them in other clauses (WHERE or ORDER BY, for example), but if you want the query to return columns in the results set, they have to be listed in SELECT.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.