PHP - Php-mysql: Compare Records In A Table And Joints Matched Results As A Single Row

Hey Everyone,
I'm creating a site that will show images uploaded for certain days working on a job site. Kind of a day-to-day photo journal for the customer. On the site, the user gets here, sees 3 large images, and a series of thumbnails if more than 3 images exist for that day (works fine).
However, underneath that I want to display a 3-4 column setup of "Archived Dates" that provide a link to the images of the other dates. I have this working correctly, but the results are displayed as follows:

Date 1: Date 2: Date 3:

etc....

I want them to display like this;
Day 1 Day 4
Day 2 Day 5
Day 3 Day 6

and so on..... in a 3 column format. Here is the code I have right now just looping through to display these link results, not the rest of the page. I am trying to do it tableless right now, but if that isn't the right way to go, please let me know.
Thanks to anyone in advance,
Nick

 $SQLRowe = "SELECT DISTINCT RoweImgDate from tblRowe WHERE RoweImgDate !='" . $_GET['date'] . "' Order by RoweImgDate DESC Limit 0, 30";
        //echo $SQLRowe;
        $rsSQLRowe = mysql_query($SQLRowe);

<span class="rowe">Archived Photos:</span><br/>
                    <div id="archive">
                    <?php
                    
                        while($row = mysql_fetch_array($rsSQLRowe)){

                            //echo "<a href='index.php?id="' . $row[RoweImgID] . '"' class='link'>$row[RoweImgDate]</a></br>";
                                    echo "<div id='archivedates'>";
                                    echo "<a href='index.php?date=" . $row[RoweImgDate] . "' class='link'>$row[RoweImgDate]</a>";
                                    echo "</div>";
                                    //echo "<img src='images/$row[RoweImage]'/><br/>";
                                    //echo "<span class='FeatDesc'><p>$row[RoweImgDesc]</p></span><br/>";
                                }
                    ?>
                    </div>

Hello,
Please excuse me if this sounds like a bit of a newb question.
If I have a link to a users profile and use GET to pull information about that user from various tables using something like this:

Code: [Select]
<?php
{
$id = $_GET['id'];
$user = mysql_query("SELECT * FROM users,tbl1,tbl2,tbl3,tbl4,tbl5 WHERE $id=tbl1.user_id AND tbl1.user_id=tbl2.user_id AND tbl2.user_id=tbl3.user_id ANDtbl3.user_id=tbl4.user_id AND tbl4.user_id=tbl5.user_id");
$user=mysql_fetch_assoc($user);
}
?>
<h3>Table 1</H3>
<?php echo "<b>".$user['tbl1_title']."<br>"; ?><br />

<h3>Table 2</H3>
<?php echo "<b>".$user['tbl2_title']."<br>"; ?><br />

<h3>Table 3</H3>
<?php echo "<b>".$user['tbl3_title']."<br>"; ?><br />

<h3>Table 4</H3>
<?php echo "<b>".$user['tbl4_title']."<br>"; ?><br />

<h3>Table 5</H3>
<?php echo "<b>".$user['tbl5_title']."<br>"; ?><br />

Why does it only show the 1st record for that user from each table?
And mostly, how do I change it to show all or a certain number of records from each table?

Any help would be greatly appreciated.
Thanks in advance 

I have the following code that searches my database and displays results in a table:

$fields = array("field1", "field2", "field3")
$cols   = implode (', ', $fields); 

$result= mysql_query 
(" SELECT $cols FROM tablename  WHERE ................... ");

if (!$result) {die('Could not search database: ' . mysql_error());}

if($result)
{   
    
    if(mysql_num_rows($result) == 0)
    {
        return "Sorry. No records found in the database";                       
    }
    else 
    {
        $table = "<table border='1' cellpadding='5' cellspacing='5'>";
        while($arr = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            $table .= "\t\t<tr>\n";
            foreach ($arr as $val_col) 
            {
                $table .= "\t\t\t".'<td>'.$val_col.'</td>'."\n";
            }
            $table .= "\t\t</tr>\n";  
        }
        $table .= "</table>";
        echo $table;
    }
    mysql_free_result($result);       
}

As you can see each of the MySQL table fields specified by $fields is displayed in a new column in the html table.
I want to change this so that e.g. "field3" is displayed in a new row instead.

So, instead of the html table looking like:

| "field1-result1" | "field2-result1" | "field3-result1" |
| "field1-result2" | "field2-result2" | "field3-result2" |
| "field1-result3" | "field2-result3" | "field3-result3" |

I want it to look like:

| "field1-result1" | "field2-result1" | 
| "field3-result1" |                          |
| "field1-result2" | "field2-result2" |
| "field3-result2" |                          |
| "field1-result3" | "field2-result3" |
| "field3-result3" |                          |

I guess this is quite straightforward, but I can't work it out! Pls help!

Thanks.

It's pretty simple to see what I am trying to do here. For some reason all results in the table are the same exact cityName replacing all existing records. The echoed results are correct. I've include a small dump of my table as well.

$query = "SELECT cityName FROM sys_city_dev_2";
      $resource = mysqli_query($cxn, $query) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query");
      
  while($result = mysqli_fetch_assoc($resource)) {

          $nox = $result['cityName'];

          $toUpper = ucfirst($nox);
  echo "$toUpper" . "<br />";

          $setString = "UPDATE sys_city_dev_2 SET cityName = '" . $toUpper ."' WHERE cityName != ''";
          mysqli_query($cxn,$setString);


      } 

100 Records of table dump (pre running my script above):

--
-- Table structure for table `sys_city_dev_2_backup`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev_2_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev_2_backup`
--

INSERT INTO `sys_city_dev_2_backup` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'dothan', 0, 0, 0),
(84011, 1, 'alabaster', 0, 0, 0),
(84012, 1, 'birmingham', 0, 0, 0),
(84013, 2, 'flagstaff', 0, 0, 0),
(84014, 1, 'auburn', 0, 0, 0),
(84015, 1, 'florence', 0, 0, 0),
(84016, 1, 'gadsden', 0, 0, 0),
(84017, 1, 'huntsville', 0, 0, 0),
(84018, 1, 'mobile', 0, 0, 0),
(84019, 1, 'montgomery', 0, 0, 0),
(84020, 1, 'tuscaloosa', 0, 0, 0),
(84021, 2, 'mohave valley', 0, 0, 0),
(84022, 2, 'phoenix', 0, 0, 0),
(84023, 2, 'prescott', 0, 0, 0),
(84024, 2, 'sierra vista', 0, 0, 0),
(84025, 2, 'tucson', 0, 0, 0),
(84026, 2, 'yuma', 0, 0, 0),
(84027, 3, 'bakersfield', 0, 0, 0),
(84028, 3, 'chico', 0, 0, 0),
(84029, 3, 'fresno / madera', 0, 0, 0),
(84030, 3, 'gold country', 0, 0, 0),
(84031, 3, 'humboldt county', 0, 0, 0),
(84032, 3, 'imperial', 0, 0, 0),
(84033, 3, 'inland empire', 0, 0, 0),
(84034, 3, 'los angeles', 0, 0, 0),
(84035, 3, 'alhambra', 0, 0, 0),
(84036, 3, 'merced', 0, 0, 0),
(84037, 49, 'fayetteville', 0, 0, 0),
(84038, 49, 'fort smith', 0, 0, 0),
(84039, 49, 'jonesboro', 0, 0, 0),
(84040, 49, 'little rock', 0, 0, 0),
(84041, 49, 'arkadelphia', 0, 0, 0),
(84042, 49, 'texarkana', 0, 0, 0),
(84043, 3, 'modesto', 0, 0, 0),
(84044, 3, 'alta sierra', 0, 0, 0),
(84045, 3, 'alpine', 0, 0, 0),
(84046, 3, 'pedley', 0, 0, 0),
(84047, 3, 'redding', 0, 0, 0),
(84048, 3, 'alondra park', 0, 0, 0),
(84049, 3, 'sacramento', 0, 0, 0),
(84050, 4, 'canon city', 0, 0, 0),
(84051, 3, 'san luis obispo', 0, 0, 0),
(84052, 3, 'santa barbara', 0, 0, 0),
(84053, 3, 'stockton', 0, 0, 0),
(84054, 3, 'aliso viejo', 0, 0, 0),
(84055, 3, 'visalia', 0, 0, 0),
(84056, 3, 'yuba city', 0, 0, 0),
(84057, 4, 'boulder', 0, 0, 0),
(84058, 4, 'colorado springs', 0, 0, 0),
(84059, 4, 'denver', 0, 0, 0),
(84060, 4, 'applewood', 0, 0, 0),
(84061, 4, 'pueblo', 0, 0, 0),
(84062, 4, 'air force academy', 0, 0, 0),
(84063, 5, 'avon', 0, 0, 0),
(84064, 5, 'hartford', 0, 0, 0),
(84065, 5, 'new haven', 0, 0, 0),
(84066, 5, 'ansonia', 0, 0, 0),
(84067, 5, 'fairfield', 0, 0, 0),
(84068, 7, 'daytona beach', 0, 0, 0),
(84069, 7, 'sebastian', 0, 0, 0),
(84070, 5, 'wallingford center', 0, 0, 0),
(84071, 8, 'belvedere park', 0, 0, 0),
(84072, 7, 'sarasota springs', 0, 0, 0),
(84073, 7, 'sandalfoot cove', 0, 0, 0),
(84074, 7, 'san carlos park', 0, 0, 0),
(84075, 7, 'st. augustine', 0, 0, 0),
(84076, 7, 'tallahassee', 0, 0, 0),
(84077, 7, 'safety harbor', 0, 0, 0),
(84078, 7, 'ruskin', 0, 0, 0),
(84079, 8, 'athens-clarke county', 0, 0, 0),
(84080, 8, 'atlanta', 0, 0, 0),
(84081, 8, 'augusta-richmond county', 0, 0, 0),
(84082, 8, 'brunswick', 0, 0, 0),
(84083, 8, 'columbus', 0, 0, 0),
(84084, 8, 'americus', 0, 0, 0),
(84085, 8, 'acworth', 0, 0, 0),
(84086, 8, 'valdosta', 0, 0, 0),
(84087, 10, 'boise', 0, 0, 0),
(84088, 10, 'ammon', 0, 0, 0),
(84089, 10, 'moscow', 0, 0, 0),
(84090, 10, 'blackfoot', 0, 0, 0),
(84091, 10, 'twin falls', 0, 0, 0),
(84092, 10, 'meridian', 0, 0, 0),
(84093, 10, 'jerome', 0, 0, 0),
(84094, 10, 'idaho falls', 0, 0, 0),
(84095, 11, 'addison', 0, 0, 0),
(84096, 10, 'garden city', 0, 0, 0),
(84097, 10, 'eagle', 0, 0, 0),
(84098, 10, 'chubbuck', 0, 0, 0),
(84099, 10, 'caldwell', 0, 0, 0),
(84100, 12, 'bloomington', 0, 0, 0),
(84101, 12, 'evansville', 0, 0, 0),
(84102, 12, 'fort wayne', 0, 0, 0),
(84103, 12, 'indianapolis', 0, 0, 0),
(84104, 12, 'muncie / anderson', 0, 0, 0),
(84105, 12, 'lafayette / west lafayette', 0, 0, 0),
(84106, 12, 'south bend / michiana', 0, 0, 0),
(84107, 12, 'terre haute', 0, 0, 0),
(84108, 12, 'northwest indiana', 0, 0, 0),
(84109, 13, 'ames', 0, 0, 0);

I have two arrays, X and Y, which contain names. The arrays are of the same size. The arrays are related to each other such that for each pair

X[n] , Y[n]

X is friends with Y.

For example:
X[0,1,2] = [Link, Cloud, Cloud, Mario, Mario, Luigi]
Y[0,1,2] = [Zelda, Barrett, Tifa, Luigi, Bowser, Mario]

Link is friends with Zelda
Cloud is friends with Barrett and Tifa
Mario is friends with Luigi and Bowser
Luigi is friends with Mario

I want to loop through these arrays and, for each unique name, find all of that person's friends.

I then want to print the results to a text file, like so:

Link, Zelda
Cloud, Barrett, Tifa
Mario, Luigi
Luigi, Mario

I know how to do this theoretically, but I just need help with the PHP syntax. Thanks very much.

Hi again everyone,

I am trying to compare a php variable to the value of a row in mysql, but keep getting the following error:

Code: [Select]
Wrong perameter count for mysql_result()

What syntax would I use to accomplish this?

Here is my code:


// connects to server and selects database.
include ("../includes/dbconnect.inc.php");

// table name
$table_name = "availability";

// split up date into 3 separate fields
$date = "12/25/2010";
$date_split = explode("/", $date);
$month = $date_split[0];
$day = $date_split[1];
$year = $date_split[2];

// check if earth room is already reserved
$taken = "Reserved";
$sql = "SELECT earth_room FROM $table_name WHERE month='$month' AND day='$day' AND year='$year' LIMIT 1";
$result = mysql_query($sql) or trigger_error("A mysql error has occurred!");
$row = mysql_result($result);

if($row == $taken){
echo "Room Already Reserved";
}
else{
echo "Room Available";
}


Thanks for the help,

kaiman

need a little help guys! I use the script below to display profile images, trouble is it shows 1 on top of the other, and i need it to double up 2 profile images on top of 2 profile images ect any ideas how i can do this. 



require("./include/mysqldb.php");

$con = mysql_connect("$dbhost","$dbuser","$dbpass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$dbame", $con);
$result = mysql_query("SELECT * FROM Search_profiles_up WHERE upgrade_one ='1' ORDER BY RAND() LIMIT 40");


print "<table width=\"293\" height=\"111\" border=\"0\">
  <tr>\n";

while($row = mysql_fetch_array($result))
  {
print "<td width=\"142\"><img src=" . $row['search_small_image'] . " width=\"144\" height=\"169\" /></td>\n";
print "  </tr>\n";
print "  <tr>  \n";
print "<td>" . $row['star'] . "</td>\n";
print "  </tr>\n";
print "  <tr>\n";
print "<td>" . $row['username_search'] . "</td>\n";
print "  </tr>\n";
print "  <tr>  \n";
print "<td>" . $row['phone_search'] . "</td>\n";
print "  </tr>   \n";

  }
print "</table>";

mysql_close($con);
?>


 

Hey, I'm new to this stuff. But I'm calling a Table with a list of products, I want people to be able to compare the products they checked. what is the best way of doing this with the code below?
I put "blah" for everything except for the compare table and calls. This code seemed to work the best for the look I wanted for it. They all call the checkbox from 'Compare' in the mysql table.

Thanks!

$result = mysql_query("SELECT * from Compare_Tool ORDER BY Blah ASC");
//Table starting tag and header cells

echo "<table border='1'><tr><th>Compare</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th></tr>";

while($row = mysql_fetch_array($result)){

?>

<tr>

<td align="center"><input name="checkbox[]" type="checkbox" Compare="checkbox[]" value="<? echo $row['Compare']; ?>"></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

</tr>

<?php }  echo "</table>";

?>

Guys,   How can I compare two values in same table.

servis.kalkulacija_stavke (
  id BIGINT(255) NOT NULL AUTO_INCREMENT,
  id_kalkulacija INT(255) NOT NULL,
  id_cjenika INT(255) NOT NULL,
  vrijeme TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  kataloski_broj VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  kategorija_artikla VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  grupa_proizvoda VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  podgrupa_proizvoda VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  cijena_EUR DECIMAL(20, 6) NOT NULL,
  cijena_KN DECIMAL(20, 6) NOT NULL,
  carina DECIMAL(20, 6) NOT NULL,
  spediter DECIMAL(20, 6) NOT NULL,
  banka DECIMAL(20, 6) NOT NULL,
  transport DECIMAL(20, 6) NOT NULL,
  nabavna_cijena DECIMAL(20, 6) NOT NULL,
  drezga_marza_po_grupi DECIMAL(20, 6) NOT NULL,
  drezga_zarada DECIMAL(20, 6) NOT NULL,
  neto_VPC DECIMAL(20, 6) NOT NULL,
  neto_MPC DECIMAL(20, 6) NOT NULL,
  trosak_firme DECIMAL(20, 6) NOT NULL,
  trosak_firme_p DECIMAL(20, 6) NOT NULL,
  diler_marza_po_grupi DECIMAL(20, 6) NOT NULL,
  preporucena_VPC DECIMAL(20, 6) NOT NULL,
  preporucena_MPC DECIMAL(20, 6) NOT NULL,
  zarada_diler_kn DECIMAL(20, 6) NOT NULL,
  zarada_diler_post DECIMAL(20, 6) NOT NULL,
  zarada_za_nas_kn DECIMAL(20, 6) NOT NULL,
  zarada_za_nas_post DECIMAL(20, 6) NOT NULL,
  brutto_zarada_za_nas_kn DECIMAL(20, 6) NOT NULL,
  brutto_zarada_za_nas_post DECIMAL(20, 6) NOT NULL,
  godina YEAR(4) NOT NULL,
  PRIMARY KEY (id),
  INDEX id (id),
  INDEX kat_br (kataloski_broj),
  INDEX kataloski_broj (kataloski_broj, kategorija_artikla, grupa_proizvoda, podgrupa_proizvoda)
)
ENGINE = MYISAM
AUTO_INCREMENT = 1119990
AVG_ROW_LENGTH = 264
CHARACTER SET utf8
COLLATE utf8_general_ci;

I want to compare field nabavna_cijena in last year and this year. How can I achieve that?
Edited by budimir, 15 December 2014 - 08:12 AM.

Hi All,

I'm working on PHP scripts to interact with a web hosted MySQL DB for an Android Application.

Simply what I am trying to do is in the PHP script is run a SELECT statement which will return the value of a column, UserType, and compare the result of this to a string, which will then execute code depending on it's value. This user type can only be either 'student' or 'lecturer'. Any help with this would be much appreciated. 

<?php

    require "init.php";
	
	$user = $_GET["userID"];
	
	#Selects column account type where the idNum equals $user which is passed from my app.
	$sql1 = "select accountType from user_info where idNum = '$user'";
	$result1 = mysqli_query($con,$sql1);
	$row1 = mysqli_fetch_assoc($result1);
	
	#This is where I am stuck. Simply, I am trying to run the code in the loop where the result of $sql1 equals 'Student'. The else will run if it is not 		#student and therefore is 'Lecturer'. I'm also not sure if my code inside the IF is fully correct either as it's not running that far.

	if($row1['accountType'] == 'Student')
	{
		$sql2 = "select courseCode from user_info where idNum = '$user'";
		$result2 = mysqli_query($con,$sql2);
		$row2 = mysqli_fetch_assoc($result2);
		
		$sql3 = "select * from module_details where classListCourseCode = '".$row2['courseCode']."'";
		$result3 = mysqli_query($con,$sql3);
		$response = array();
		
		while($row = mysqli_fetch_array($result3))
		{
			array_push($response,array("moduleID"=>$row[0],"lecturerID"=>$row[1],"moduleName"=>$row[2],"classListCourseCode"=>$row[3]));
		}
		
		echo json_encode(array("server_response"=>$response));
	}

Thanks in advance.

I want to perform a query which returns a subset of the fields in a table.  One particular mySQL field is VARCHAR

I have a query like this:
$query = mysql_query("SELECT * FROM table WHERE code LIKE '3%') ;

It's my understanding this should return all values which begin with "3", but it only returns about a dozen of the values 3, 30-39, 300-399, etc.  (It works with string fields, but this field contains numerals.)

Any help appreciated.

thanks,
Tom

Has anyone got any script or refence to a tut where i can find a script that compares two mysql database (current) and outdated db and then takes the current db and updates the outdated one to match accordingly. Thanks

Hi,

I have a database (mysql). In the database is a table with categories (categories_id, categories_name etc).

I also have another table (products table) which gets filled using a html form. That table holds category info too.

What I am trying to do (without any luck) is when the form is processed, it will populate the table with the new data, then I need it to compare the 2 tables to see if the category fields from both tables have a match. If there is a match in the tables then send an email to people who has asked to be notified when new product has been added that matches a particular criteria.

For example, if someone adds a product to the category 'Landscapers', with a location 'Dorset'... I would like to be able to email all the registered tradespeople in Dorset about the new product.

I know this should be something quite simple, but I cant seem to get my head around it. Any pointers would be fantastic.

Many thanks

DB

How would I compare 2 random numbers to rows in a table.  The table has 4 rows and 2 colums.  My table is setup like this: ID hp mp then has just randomly placed numbers from 0 to 5.  So far my script looks like this: I have $new_hp=rand(0,5); $new_mp=rand(0,5).  Then i query the db by $myquery=doquery("select hp,mp from users";  $myrow=mysql_fetch_array($myquery); once this is done would a while statement like while ($myrow = mysql_fetch_array($myquery) to what each line in the table has?  I would then need to compare the random numbers to those entries in the database.  Something like if($myrow[hp] == $new_hp && $myrow[mp] == $new_mp) { ?  But if the if statement isnt true it needs go back choose another random number and run same again and again until the statement is true and that is where im stuck at so any help would be greatly appreciated

Hello all,

I am new to php coding and have a couple of problems with editing records in my database! I have two files below one test.php and edit.php. In the test.php the code outputs the records into a table. The problem is with the edit link as when it is selected I wish to be able to edit a record by a form, which is on edit.php. I am trying bring up the movie's information on the form to be edited. Currently on the form i get;

Quote

Movie: movie
Gen Genre
Year: year



Any ideas how I can edit the record and then return to the test.php page?
Code: [Select]
test.php

<html>
<body style="background-color:#669999;">
<table width="490"border=0><tr>
<td  colspan="2" style="background-color:#FFA500;">
<div id="header"
<h3 style="color:black">This is my first web-page! Below is a database of some of my favourite movies!
</h3>
</td>
</tr>

<?php
//connecting to server
$con = mysql_connect("localhost","root","NYOXAkly");

if (!$con)
{
    die('could not connect: ' . mysql_error());
}

//selecting movie database
mysql_select_db("my_mov",$con);

//Check if add button is active, start this
if(isset($_REQUEST['add']))
{ 
echo "<meta http-equiv=\"refresh\"content=\"0;URL=form.php\">";
}

$result = mysql_query("SELECT * FROM Films ORDER BY filmID");
?>

<!-------------------------------creating table------------------------------------------------------------------------------------>
<table width="490" border="0" cellspacing="1" cellpadding="0">
<tr>
 <td>
  <form name="test1" method="post" action="test.php">
  <table width="490" border="10" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"><tr>
 <td bgcolor="#FFFFFF"></td>
 <td align="center" colspan="6" bgcolor="#FFFFFF">Movie Database</td></tr>
 <td align="center" bgcolor="#FFFFFF">filmID</td>
 <td align="center" bgcolor="#FFFFFF">Movie</td>
 <td align="center" bgcolor="#FFFFFF">Genre</td>
 <td align="center" bgcolor="#FFFFFF">Year</td>
 <td align="center" bgcolor="#FFFFFF">Edit</td>
 <td align="center" bgcolor="#FFFFFF">Delete</td>
</tr>

<?php
while($rows=mysql_fetch_array($result))
{
?>

<tr>
 </td>
 <td bgcolor="#FFFFFF"><? echo $rows['filmID']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['movie']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['genre']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['year']; ?></td>
 <td bgcolor="#FFFFFF">
  <a href="edit.php?filmID=<?php echo 'filmID';?>">Edit</a> 
 <td bgcolor="#FFFFFF">
<a href="delete.php?filmID=<?php echo 'filmID';?>">Delete</a> 
 </td>
</tr>

<?php
}

echo print_r(error_get_last());
mysql_close();
?>

<!--add button-->
<tr>
  <td colspan="15" align="left" bgcolor="#FFFFFF">
      <input name='add' type="submit" filmID="add" value="Add A New Record" action="form.php?"> 
  </td>
</tr>

</table>
</form>

<br/>
By C.M.D.W
<br/>

<?php 
     echo date("Y/m/d") . "<br />";
?>

</body>
</html>


Code: [Select]

edit.php

<html>
<body style="background-color:#669999;">

<!------------------Creates a form ---------------------->
<br />
 <form action="" method="post">
  <fieldset>
   <legend>Enter your movies into database here!</legend>
   Movie: <input type ="text" name="movie" value="<?php echo 'movie';?>">
<br />
   Gen <input type ="text" name="genre" value="<?php echo 'genre';?>"/>
<br />
   Year: <input type ="text" name="year" value="<?php echo 'year';?>"/>
<br />
   <input type="submit" name="name" value="Submit" />
  </fieldset>
 </form>

<?php
//connecting to server
$con = mysql_connect("localhost","root","NYOXAkly");

if (!$con)
{
    die('could not connect: ' . mysql_error());
}

//selecting movie database
mysql_select_db("my_mov",$con);

if (isset($_POST['submit']))
 { 
 // confirm that the 'id' value is a valid integer

 if (is_numeric($_POST['filmID']))
 
 // get form data
 $filmID = $_POST['filmID'];
 $movie = mysql_real_escape_string(htmlspecialchars($_POST['movie']));
 $genre = mysql_real_escape_string(htmlspecialchars($_POST['genre']));
 $year = mysql_real_escape_string(htmlspecialchars($_POST['year']));
 
 // check that fields are filled in
 if ($movie == '' || $genre == '' || $year == '')
 {
 // generate error message
 $error = 'ERROR: Please fill in all required fields!';
 } 
 else
 {
 
 // save the data to the database
 }
mysql_query("UPDATE players SET movie='$movie', genre='$genre', year='$year' WHERE filmID='$filmID'")
 or die(mysql_error()); 
 
 // once saved, redirect back to the view page
 header("Location: test.php"); 
 }
 }

 if (isset($_GET['filmID']) && is_numeric($_GET['filmID']) && $_GET['filmID'] > 0)
  {
 // query db
 $id = $_GET['filmID'];
 $result = mysql_query("SELECT * FROM Films WHERE filmID=$FilmID")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
 
 // check that the 'id' matches up with a row in the databse
 if($row)
 {
 
 // get data from db
 $movie = $row['movie'];
 $genre = $row['genre'];
 $year = $row['year'];

}}

?>


<br/>
<br/>

<a href="test.php">Return To Home Page</a>
<br/>
<br/>
By C.M.D.W
<br/>
<?php 
     echo date("Y/m/d") . "<br />";
?>
</body>
</html>

Thanks

Chris