[RESOLVED] values not showing

[SeanKann]

Here is my page

<?php
include('connection.php');

if (isset($_GET['ad'])) {
    $ad = $_GET['ad'];
} else {
    $ad = 'ad';
}

$result=mysql_query("SELECT * from display LEFT JOIN schedule_promotion_queue ON display.display_id = schedule_promotion_queue.display_id WHERE ad_schedule_id IN ( SELECT ad_schedule_id FROM ad_schedule WHERE ad_id = $ad ) AND promoted = \'Complete\'");

echo $ad;
echo "<table>";
echo "<tr><th>MP Name</th><th>StartTime</th><th>StopTime</th><th>Screens</th><th>VenueCode</th><th>PropCode</th>";

while($row = mysql_fetch_array($result))
{

echo "<tr>";
echo "<td>" .$row['name']. "</td>";
echo "<td>" .$row['starttime']. "</td>";
echo "<td>" .$row['stoptime']. "</td>";
echo "<td>" .$row['screens']. "</td>";
echo "<td>" .$row['venue_code']. "</td>";
echo "<td>" .$row['proprietor_code']. "</td>";
echo "</tr>";    

}
echo "</table>";
?>

The $ad file is working as I did an echo and it is pulling the id number from the previous page.
But with my mysq_fetch_array to get the information into a table is not showing.

If my run my $result line in mysql and switching $ad with a number works 100% displays my information correctly. Now I just want to show that information.

Should I be using fetch_array on this or should it be something else?

TIA

[bradgrafelman]

Have you tried doing a [man]print_r/man on $row to see what it contains?

Also, don't use 'SELECT *' - instead, explicitly list the columns from which you need data.

[SeanKann]

bradgrafelman;11000797 wrote:

Have you tried doing a [man]print_r/man on $row to see what it contains?

Also, don't use 'SELECT *' - instead, explicitly list the columns from which you need data.

doing the print_r($row); doesn't display anything like my other queries.

[bradgrafelman]

How did you try to use it? Did you do the print_r() inside the loop or after the loop? (Note that the latter would be inappropriate since $row is likely going to be boolean FALSE - that's how the loop normally terminates in the first place).

Also, have you you verified that [man]mysql_query/man isn't returning boolean FALSE? Do you have error_reporting set to E_ALL and display_errors (or log_errors if in production environment) set to On?

Finally, even if the query is being executed successfully... are you sure it's returning any results ([man]mysql_num_rows/man should help determine that)? In other words, is the loop even being executed at all?

[SeanKann]

bradgrafelman;11000801 wrote:

How did you try to use it? Did you do the print_r() inside the loop or after the loop? (Note that the latter would be inappropriate since $row is likely going to be boolean FALSE - that's how the loop normally terminates in the first place).

Also, have you you verified that [man]mysql_query/man isn't returning boolean FALSE? Do you have error_reporting set to E_ALL and display_errors (or log_errors if in production environment) set to On?

Finally, even if the query is being executed successfully... are you sure it's returning any results ([man]mysql_num_rows/man should help determine that)? In other words, is the loop even being executed at all?

I put the print_r in the loop.

Boolean FALSE. I have no idea what that means.

I just noticed the error in my log file

[Wed Apr 04 11:51:54 2012] [error] [client 127.0.0.1] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/seankann/www/test/run_report.php on line 17, referer: http://localhost/comscore/ad_info.php?ad_info=85

I always have server side logging enable on apache.

[Derokorian]

See the link in brad or my sig about MySQL(i) warnings. You should be checking if the query was successful before trying to use its results (because after all, if its not successful there will be no results to use!)

[SeanKann]

Derokorian;11000806 wrote:

See the link in brad or my sig about MySQL(i) warnings. You should be checking if the query was successful before trying to use its results (because after all, if its not successful there will be no results to use!)

If I run the command in phpmyadmin it displays the information I need

[bradgrafelman]

SeanKann;11000808 wrote:

If I run the command in phpmyadmin it displays the information I need

What "command" are you referring to? Did you echo out the SQL query string exactly as it is defined in your PHP code? If not, then you might not be executing the same SQL query as your PHP script is, thus making your phpMyAdmin results irrelevant.

Either way, did you read Derokorian's post (and mine before his - we both talked about the same issue)? As he points out, the link in my signature gives a full explanation.

If you still can't figure it out, try echo'ing out the SQL query string in your PHP script and post it here for us to see. One problem I now notice is here:

AND promoted = \'Complete\'

What is the purpose of those two backslashes?

[SeanKann]

I did

echo ("SELECT * from display LEFT JOIN schedule_promotion_queue ON display.display_id = schedule_promotion_queue.display_id WHERE ad_schedule_id IN ( SELECT ad_schedule_id FROM ad_schedule WHERE ad_id = $ad ) AND promoted = 'Complete'");

And I got this out on my page

SELECT * from display LEFT JOIN schedule_promotion_queue ON display.display_id = schedule_promotion_queue.display_id WHERE ad_schedule_id IN ( SELECT ad_schedule_id FROM ad_schedule WHERE ad_id = 1046 ) AND promoted = 'Complete'

If I take that command and run it in either mysql or phpmyadmin interface I get results.

I'm still trying to figure out what that boolean error that is in your sig to understand it.

[Derokorian]

SeanKann;11000808 wrote:

If I run the command in phpmyadmin it displays the information I need

By checking the results, I meant in PHP. Such as:

$result = mysqli_query($conn,$query);
if( $result === FALSE ) {
   print_f('Error running query: %s<br>MySQL said: (%d) %s',
      $query, mysqli_errno($conn), mysqli_error($conn));
} else {
   if( mysqli_num_rows($result) == 0 ) {
      print(' MySQL returned no results!');
   } else {
      // Normal looping here
      while( $row = mysqli_fetch_array($result) ) {
         // stuff
      }
   }
}

Also note: You aren't echoing the same statement you are sending to MySQL notice the removal of the backslashes brad mentioned? You should assign your query to a variable first, so you can always echo exactly what is sent. As such your problem must lie in those extraneous backslashes in your original post.

[SeanKann]

Derokorian;11000813 wrote:

By checking the results, I meant in PHP. Such as:

$result = mysqli_query($conn,$query);
if( $result === FALSE ) {
   print_f('Error running query: %s<br>MySQL said: (%d) %s',
      $query, mysqli_errno($conn), mysqli_error($conn));
} else {
   if( mysqli_num_rows($result) == 0 ) {
      print(' MySQL returned no results!');
   } else {
      // Normal looping here
      while( $row = mysqli_fetch_array($result) ) {
         // stuff
      }
   }
}

Also note: You aren't echoing the same statement you are sending to MySQL notice the removal of the backslashes brad mentioned? You should assign your query to a variable first, so you can always echo exactly what is sent. As such your problem must lie in those extraneous backslashes in your original post.

This is the result that I got

MySQL returned no results!

That I know if. That's what I'm trying to figure out.

[SeanKann]

SeanKann;11000814 wrote:

This is the result that I got

MySQL returned no results!

That I know if. That's what I'm trying to figure out.

I double checked my query and made a small change

Made $ad in quotes '$ad'

Seems to be working now 🙂

$query=mysql_query("SELECT * from display LEFT JOIN schedule_promotion_queue ON display.display_id = schedule_promotion_queue.display_id WHERE ad_schedule_id IN ( SELECT ad_schedule_id FROM ad_schedule WHERE ad_id = '$ad' ) AND promoted = 'Complete'");