[RESOLVED] No data displayed

reflash

I'm having a bit of a problem: I've loaded my database with data, and I'm trying to run a query to display all data that matches the criteria that I input, but all I get is a blank page. Can anyone help?

Here's the code:

pull.php:

<HTML>

<HEAD>

<BODY>

<?php

if (isset($HTTP_POST_VARS['xadd']))
{

// Set Mysql Variables
$host='localhost';
$user='xxxxxx';
$pass='xxxxxx';
$db='xxxxxx';
$table='xxxxxx';

$mon=$POST['mon'];
$day=$POST['day'];

mysql_connect($host, $user, $pass) or die('Connection died!');

mysql_select_db($db) or die('Selection died!');

$get_all = "SELECT * FROM $table WHERE month='$mon' AND day='$day'";

$myquery = mysql_query($get_all);

while ($row = mysql_fetch_array($myquery)) {
echo $row['one'];?><BR><?php
echo $row['year'];?><BR><?php
echo $row['month'];?><BR><?php
echo $row['day'];?><BR><?php
echo $row['event'];?><BR><BR><?php

}

}
else
{

include 'xpull.inc.php';

}

</BODY>

</HTML>

xpull.inc.php:

<HTML>

<HEAD>

<BODY>

Input the values you wish to search by:

Month: <INPUT TYPE="text" NAME="mon" ID="mon"><BR><BR>

Day: <INPUT TYPE="text" NAME="day" ID="day"><BR><BR>

</FORM>

</BODY>

</HTML>

The page displays the form and seems to accept the input, but then just gives a blank page.

dalecosp

Try changing this:

$myquery = mysql_query($get_all);

to this, instead:

$myquery = mysql_query($get_all) or die("query failed! query was $get_all and sql returned error message ".mysql_error());

Perhaps some insight will be available then.

reflash

Thanks for the reply, dalecosp. I did what you suggested, and I'm still just getting a blank page.

reflash

OK, I made some other changes to pull.php:

<HTML>

<HEAD>

<BODY>

<?php

include 'xpull.inc.php';

if (isset($HTTP_POST_VARS['xadd']))
{

// Set Mysql Variables
$host='localhost';
$user='xxxxxx';
$pass='xxxxxx';
$db='xxxxxx';
$table='xxxxxx';

$mon=$POST['mon'];
$day=$POST['day'];

mysql_connect($host, $user, $pass) or die('Connection died!');

mysql_select_db($db) or die('Selection died!');

$get_all = "SELECT * FROM $table WHERE month='$mon' AND day='$day'";

$myquery = mysql_query($get_all) or die("query failed! query was $get_all and sql returned error message ".mysql_error());

while ($row = mysql_fetch_array($myquery)) {
echo $row['one'];?><BR><?php
echo $row['year'];?><BR><?php
echo $row['month'];?><BR><?php
echo $row['day'];?><BR><?php
echo $row['event'];?><BR><BR><?php

}

</BODY>

</HTML>

And now it gives me the input form again, but the echo statements are not running...

dalecosp

What is your error_reporting set to? A blank page can indicate errors.

If it's not that, then a logic issue, most likely. Can you post your current code in

 tags, if this is the case?

reflash

Do you mean the color coded tags? I don't know how to do that...

reflash

Basically, what I'm trying to do, is pull data from the database, and display it on the page. More specifically, I'll be pulling the date off of the client machine, and using the day & month portions to query the database and display that on the calling page. Any ideas?

Houdini

Look at this section of your code

<FORM METHOD="post" ACTION="<? echo $HTTP_SERVER_VARS['PHP_SELF']; ?>"

Instead change that to this which will process the pull.php

<FORM METHOD="post" ACTION="pull.php">

Now run your script and see if it needs further debugging. And just for the heck of it to see that xadd was set with the submit add this right behind it before your sql connection parameters.

echo $_POST['mon'];
echo $_POST['day'];

msk_1980

The other thing i would suggest would be checking if the database is returning any rows or not. try

$no_rows = mysql_num_rows( $myquery );
echo 'no of rows returned is '. $no_rows;