Query returning no results

[deleted]

I'm having a problem with the following code:

<?php
$qGetWorkoutDate = "SELECT workoutdate FROM tblworkouts WHERE workoutdate between curdate() and date_add(curdate(),interval 7 day) limit 1";
$rGetWorkoutDate = mysql_query($qGetWorkoutDate) or die ("Error in query: $qGetWorkoutDate. " . mysql_error());

if (mysql_num_rows($rGetWorkoutDate)>0)
{

	while ($WorkoutDate_row = mysql_fetch_array ($rGetWorkoutDate));
	{
		$workoutdate = $WorkoutDate_row['workoutdate'];

?>
<html>
<head></head>
<title></title>
<body>
<table width="800px" cellpadding="0" cellspacing="0">
<tr>
<td width="800px" style="background-color: white; font-family: arial; color: black; font-weight: bold; height: 25px;padding-left: 5px;">
This Week's Workout: <?php echo formatDate($workoutdate);?>
</td>
</tr>
<?php
}
}
?>

I know that the SQL query is valid because I have run it in MySQL Studio without any problems. Also, I know the formDate function works because I substituted $workoutdate with the value '2003-03-26 19:00:00' with success.

The only errors I receive relate to the function and as I have said this is because the variable $workoutdate is empty.

Any suggestions?

PHPgimp

What are you using to get the information you want ie dates to the query. I may be off base here. However it looks to me as though your information is not making it from your form.

might need to do something along the lines of a $POST or $GET

I am still learning so if I am wrong someone please let me know. I am only trying to help.

WinterDragon

I believe they are talking about Database Queries... not the actual QUERY_STRING information.

PHPgimp

What I saw at the bottom was that the Variable $workoutdate is undefined. looks to me as though the date requested via the form is not getting passed.

EDIT------

could also be where in PHP.ini if globals are on and off. Depends on what version of PHP you are using.

[deleted]

I was referring to the SQL query not the query string.

[deleted]

The variable $workoutdate is undefined in the sense that there is no value associated.

[deleted]

I should also add that there are no forms involved. This is a straight query and display of results.

amchargue

One thing I find a little odd is you have

<html> 
<head></head> 
<title></title> 
<body>

inside the while loop, thus that html is getting repeated, which could cause you some problems depending on browser, I imagine. And the <table> tag is getting repeated over and over. I KNOW that's a problem in some browsers esp. NN 4.x

Seems to me the only HTML that should be inside the while loop is the table row -- <tr> ... </tr> and everything in between.

[deleted]

I resolved the error with the following code:

	while ($GetWorkoutDate = mysql_fetch_array ($rGetWorkoutDate))
	{

?>
<tr>
<td width="800px" style="background-color: white; font-family: arial; color: black; font-weight: bold; height: 25px;padding-left: 5px;">
This Week's Workout: <?php echo formatDate ($GetWorkoutDate['workoutdate']);?>
</td>
</tr>
<?php
}

Thanks for everyone's suggestions.