One query works, one doesn't. Need a second set of eyes

[beanfair]

I have tested both of these queries in PHPMyAdmin and they work great. When I try to call those queries and data bind, one works and one doesn't. I can't see where the problem is.

This works

<?php $meeting = $wpdb->get_row("SELECT *, date_FORMAT(startDate, '%M %e, %Y') as newDate FROM sfa_meetings WHERE meetingID = 163");?>

<h3><?php echo $meeting->newDate; ?></h3>
<h2><?php echo $meeting->title; ?></h2>

This does not

<?php $location =$wpdb->get_row("SELECT locID, locName, address, city, zip, drive, locDesc, comments FROM locations WHERE locID =7 ");?>
<h3><?php echo $loc->locName; ?> </h3>

I am stumped. 

Both code blocks appear on this page http://174.123.219.170/~romancew/meeting-test but I have also tried the code blocks on separate pages to make sure they weren't interfering. The first code block works whereever I put it but not the second.

Any assistance is appreciated!

[trq]

The results of the get_row() method is being stored in an object called $location, you are then trying to echo a property of an object called $loc. Where is $loc defined?

[beanfair]

That was a typo after too many hours staring at the code. Here is the code as it appears on the test page

This works

[/<?php $meeting = $wpdb->get_row("SELECT *, date_FORMAT(startDate, '%M %e, %Y') as newDate FROM sfa_meetings WHERE meetingID = 163");?>

<h3><?php echo $meeting->newDate; ?></h3>
<h2><?php echo $meeting->title; ?></h2>php]
This does not 
[code=php:0]<?php $location =$wpdb->get_row("SELECT locID, locName, address, city, zip, drive, locDesc, comments FROM locations WHERE locID =7 ");?>
<h3><?php echo $location->locName; ?> </h3>

 

Here is subsequent code on that page

<table>
<tr><td>Registration Begins</td><td><?php echo $meeting->regTime; ?></td></tr>
<tr><td>Business Meeting Begins</td><td><?php echo $meeting->busTime; ?></td></tr>
<tr><td>Feature Begins</td><td><?php echo $meeting->featureTime; ?></td></tr>
<tr><td>Adjourn</td><td><?php echo $meeting->adjournTime; ?></td></tr>
<tr><td>Location</td><td><?php echo $location->locName; ?></td></tr>
<tr><td>Address</td><td><?php echo $location->address; ?></td></tr>
<tr><td></td><td><?php echo $location->city; ?>, CA  <?php echo $location->zip; ?></td></tr>
<tr><td>Directions</td><td><?php echo $location->drive; ?></td></tr>
<tr><td>Questions?</td><td><?php echo $meeting->email; ?></td></tr>
</table>

The test page is at http://174.123.219.170/~romancew/meeting-test

Thank you!

[Buddski]

Have you checked to see if the query is returning any results in PHP or produced any errors?

try var_dump($location) and see what that has to say...

[beanfair]

No errors and the var_dump works, returning all expected values.

This is driving me crazy.

[RussellReal]

if the var dump returns the values then maybe you're calling the object's parameters the wrong way. check the names.

[kalidossmm]

Can u print the VAR_DUMP output here.