In my query, is it possible to echo out a php value? If not, is there any way just to pass in the value of the id player_id?
<?php
$New = '<p id="player_id"></p>';
// This outputs the correct value. How can I output
// what is inside of the <p> tag into the SQL Query?
echo $New
$A = 'LRAR';
$Class_Data = $wpdb->prepare("
SELECT FLA, Date, Location_Name FROM Class_Date
INNER JOIN Class_Location
ON Class_Date.Location_ID =
Class_Location.Central_Location_ID
INNER JOIN Course
ON Class_Date.CourseID = Course.CourseID
WHERE FLA = %s", $A);
$Class_Data_Results =$wpdb->get_results( $Class_Data );
Outputting $A works fine, but I want to be able to output $New. How can I set my query to be equal to a value with HTML tags included?
$wpdb::prepare()
and read through the WPDB Dev page