[Resolved] quick retrieval from mysql database question

[kfresh]

I just want to view one record from this query on a page. it's a listing of concerts coming up and the one i want to have viewing is the next show by the date. so what do i have to change in this while loop to view the next date. i already have a script that will delete the records once it gets past the date.

<?PHP
	$result = mysql_query("SELECT who1, when1, where1, city, cover, ages, time, info, fullimage FROM events                  ORDER BY when1 asc", $link_id);
	while($query_data = mysql_fetch_array($result)) {
    	$who = $query_data["who1"];
    	$when = $query_data["when1"];
    	$where = $query_data["where1"];
		$city = $query_data["city"];
    	$cover = $query_data["cover"];
    	$ages = $query_data["ages"];
		$time = $query_data["time"];
		$info = $query_data["info"];
    	$fullimage = $query_data["fullimage"];
		list($Year,$Month,$Day) = split('-',$when);
		$stampeddate = mktime(12,0,0,$Month,$Day,$Year);
		$date = date("F j Y", $stampeddate);
		echo "<tr><td align=\"center\" class=\"home\" valign=\"middle\">\n";
		if ($fullimage == NULL)
		{
		echo "";
		} else {
		echo "<a href=\"javascript:PopupPic('images/$fullimage')\"> <img src=\"images/$fullimage\" border=\"0\" height=\"75\" width=\"50\" ></a>\n";
		}
		echo "<br>$who<br>$date<br>$where<br>$city<br>$cover / $ages / $time<br>$info</td></tr> \n";
	}
?> 

[Gibb_Boy]

Not sure if this is what you're asking, but you can limit the number of results using the LIMIT claus in the SQL statement

just add

LIMIT 1

on the end of the SQL statement

[kfresh]

Originally posted by Gibb Boy
Not sure if this is what you're asking, but you can limit the number of results using the LIMIT claus in the SQL statement

just add

LIMIT 1

on the end of the SQL statement [/B]

that worked!! thanx... i feel so retarded now that was so easy...

k

[kfresh]

actually one more thing....

at times... there might not be any records in the database after the date has passed... i know this might be simple, but i was having some trouble with this...

what do i need to add to this so that it will read "No events scheduled at this time" if the query returns no results....

i tried adding something like

if (!$query_data)
{
     echo "No events scheduled at this time";
} else {

before the while loop, but it wasnt working. anyone else have any suggestions...

K

[laserlight]

You can check the number of rows returned with mysql_num_rows()

[Gibb_Boy]

yes as laserlight stated, check the number of rows. If you run a query that returns 0 rows, but ran successfully, then $query_data will still be true. You need something like this:

$query = "SELECT * FROM TABLE";

$results = mysql_query($query);

if(mysql_num_rows($results) != 0) {
   // do your normal stuff here

} else {
   echo 'No results found';
}