I need my php to call certain parts of a table from mysql

**Aimee Bailey** · Apr 12 '11, 03:58 PM

Instead of giving you the answer which wouldnt really teach you much, here is a link to a very popular tutorial on the matter:

MySQL Tutorial - Introduction

http://www.tizag.com/mysqlTutorial/

Learn how to use MySQL with PHP in Tizag.com's MySQL and PHP lesson.

I encourage you to read it, as it will show you everything you need to know.

Aimee.

**liosbeg** · Apr 12 '11, 07:23 PM

Thanks Aimee.
I have looked at this and started over again using code.
Still having some problems although smaller now!

Here is my new code. If it is something small I am doing can you let me know? Really appreciate your help.

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> 
<title>Album</title> 
<link rel="stylesheet" type="text/css" href="homework.css"> 
</head> 
<body>  
<?php  
// get form selection  
$day = $_GET['day']; 
      // check value and select appropriate item 
      if ($day == 1) { 
$album = 'James Taylor'; 

// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxx"; //your ID number here
      $pass = "xxxx"; //your password here
      $db = "xxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='1'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>

<?php 
}  
elseif ($day == 2) { 
$album = 'The Rolling Stones';  

// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxxxx"; //your ID number here
      $pass = "xxxxxx"; //your password here
      $db = "xxxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='2'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>


<?php  
}  
elseif ($day == 3) {  
 $album = 'Sting';  

// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxxxx"; //your ID number here
      $pass = "xxxxxxx"; //your password here
      $db = "xxxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='3'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>

<?php  
 }  
elseif ($day == 4) {  
$album = 'Bob Dylan'; 

// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxxx"; //your ID number here
      $pass = "xxxxx"; //your password here
      $db = "xxxxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='4'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>

<?php  
}  
elseif ($day == 5) {  
$album = 'Robert Plant and Jimmy Page';  

// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxx"; //your ID number here
      $pass = "xxxxxx"; //your password here
      $db = "xxxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='5'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>

	    <?php  
	   
	      }  
	elseif ($day == 6) {  
	        $album = 'Eric Clapton'; 
			
// set database server access variables: 
      $host = "testweb2.csis.ul.ie"; //localhost on your home PC/laptop
      $user = "xxxxxx"; //your ID number here
      $pass = "xxxxxx"; //your password here
      $db = "xxxxxx"; //your ID number here

      // open connection 
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 


// Get a specific result from the "Tracks" table
$result = mysql_query("SELECT * FROM Tracks
 WHERE album_number='6'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['track_number']." - ".$row['track_title'];
?>
			<?php   
	      }
		 ?>   
	</body>  
</html>

**Dormilich** · Apr 12 '11, 11:50 PM

Still having some problems although smaller now!

what smaller problems do you have? from my personal point-of-view there is a lot to do (starting with not using the outdated mysql functions), but that’s not something to throw at you yet.

I need my php to call certain parts of a table from mysql

I need my php to call certain parts of a table from mysql

Comment

Comment

Comment