0

Hello. I have a simply php script for my school project that checks books back into a library database. What I was trying to accomplish was when you checked in the book for it to check and see if the book has been requested and notify the librarian that there is someone waiting for the book. I thought it was working fine but if my query of the request table returns an empty set things seem to stall.

<?php
		//ini_set('session.cache_limiter','private');
		session_start();
		@mysql_connect($_SESSION['hostname'],$_SESSION['username'],$_SESSION['password']) or die(mysql_error());
		@mysql_select_db($_SESSION['db']);
		
			
		$libraryID = $_POST['libraryID'];
		$query="update checkout set checkinDate = CURDATE() where libraryID = '$libraryID'";
		$result=mysql_query($query) or die(mysql_error());
	
		$query = "SELECT status FROM holdsrequests WHERE libraryID = '$libraryID'";
		$result = mysql_query($query) or die(mysql_error());
		$number = mysql_numrows($result) or die(mysql_error());
		
		if($number > 0){
			$row = mysql_fetch_array($result) or die(mysql_error());
			
			$status = $row['status'];
			if($status == "request"){
				$_SESSION['held'] = $row['cardNumber'];
				
				header('Location:http://localhost/Library/php/checkIn.php?q=request');
				
			}
		}
		else{
			header('Location:http://localhost/Library/php/checkIn.php?q=checkedin');
			
		}*/
	?>

If I take out the $number variable and all reference to it the code works fine. But with it there it simply stops working. I don't get any errors just a blank page. I added in some print statements to see where it was failing and it seems that anything after the $number variable is not getting executed.

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by dyingatmidnight
0

and nevermind, the or die statement I had after the $number was messing things up. All fixed now/

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.