PHP - If I Delete Brand The Mobile Related To That Brand Should Also Be Deleted How To Implement This?

Me and a buddy have started a new website.  Were basically looking to make a site where you can upload a swf or image file (at first) for a temp. amount of time.  Lets say 24 hours.  Then after 24 hours its deleted.    We eventually wanna grow into a bigger site where you can log in, keep your files, etc.  However we have the site layed out and a server set up.  We are missing the key part of PHP making the site work. 

What are the first steps we should take?

Are their any tutorials to help us set up a basic site?

Does anyone wanna help with the project?   ....  j/k..... but seriously.

Thanks guys.  Would love any advice or tips. 

I am trying to display records from a database using pagination.  Currently the first page is showing and data is being displayed correctly.  The links are also available below to move from page to page, however when I click on the next page, nothing happens.  I know I need to add parameters to my query string, but I'm unsure as to what I need to add.  Can someone help?

Here is where I am calling the page:

Code: [Select]
<a href="index.php?menukey=7" accesskey="7" title="">Project 3</a>
Here is my pagination:

Code: [Select]
function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5) {
        $this->conn = $connection;
        $this->sql = $sql;
        $this->rows_per_page = $rows_per_page;
        $this->links_per_page = $links_per_page;
        $this->php_self = htmlspecialchars($_SERVER['PHP_SELF']);
        if(isset($_GET['page'])) {
            $this->page = intval($_GET['page']);
        }
    }
   
    /**
     * Executes the SQL query and initializes internal variables
     *
     * @access public
     * @return resource
     */
    function paginate() {
        if(!$this->conn) {
            if($this->debug) echo "MySQL connection missing<br />";
            return false;
        }
       
        $all_rs = @mysql_query($this->sql);
        if(!$all_rs) {
            if($this->debug) echo "SQL query failed. Check your query.<br />";
            return false;
        }
        $this->total_rows = mysql_num_rows($all_rs);
        @mysql_close($all_rs);
       
        $this->max_pages = ceil($this->total_rows/$this->rows_per_page);
        //Check the page value just in case someone is trying to input an aribitrary value
        if($this->page > $this->max_pages || $this->page <= 0) {
            $this->page = 1;
        }
       
        //Calculate Offset
        $this->offset = $this->rows_per_page * ($this->page-1);
       
        //Fetch the required result set
        $rs = @mysql_query($this->sql." LIMIT {$this->offset}, {$this->rows_per_page}");
        if(!$rs) {
            if($this->debug) echo "Pagination query failed. Check your query.<br />";
            return false;
        }
        return $rs;
    }
   
    /**
     * Display the link to the first page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'First'
     * @return string
     */
    function renderFirst($tag='First') {
        if($this->page == 1) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page=1">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the link to the last page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'Last'
     * @return string
     */
    function renderLast($tag='Last') {
        if($this->page == $this->max_pages) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page='.$this->max_pages.'">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the next link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '>>'
     * @return string
     */
    function renderNext($tag=' &gt;&gt;') {
        if($this->page < $this->max_pages) {
            return '<a href="'.$this->php_self.'?page='.($this->page+1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the previous link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '<<'
     * @return string
     */
    function renderPrev($tag='&lt;&lt;') {
        if($this->page > 1) {
            return '<a href="'.$this->php_self.'?page='.($this->page-1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the page links
     *
     * @access public
     * @return string
     */
    function renderNav() {
        for($i=1;$i<=$this->max_pages;$i+=$this->links_per_page) {
            if($this->page >= $i) {
                $start = $i;
            }
        }
       
        if($this->max_pages > $this->links_per_page) {
            $end = $start+$this->links_per_page;
            if($end > $this->max_pages) $end = $this->max_pages+1;
        }
        else {
            $end = $this->max_pages;
        }
           
        $links = '';
       
        for( $i=$start ; $i<$end ; $i++) {
            if($i == $this->page) {
                $links .= " $i ";
            }
            else {
                $links .= ' <a href="'.$this->php_self.'?page='.$i.'">'.$i.'</a> ';
            }
        }
       
        return $links;
    }
   
    /**
     * Display full pagination navigation
     *
     * @access public
     * @return string
     */
    function renderFullNav() {
        return $this->renderFirst().'&nbsp;'.$this->renderPrev().'&nbsp;'.$this->renderNav().'&nbsp;'.$this->renderNext().'&nbsp;'.$this->renderLast();   
    }
   
    /**
     * Set debug mode
     *
     * @access public
     * @param bool $debug Set to TRUE to enable debug messages
     * @return void
     */
    function setDebug($debug) {
        $this->debug = $debug;

I have designed and created a ecommerce website that allows the user to add products to a shopping cart and for the admin to edit the inventory list. However i would like to have a navigational bar on the website where the user can choose a brand of product and the webpage shows only that brand. I know i can do this by using the WHERE command in a query however would i have to make a separate web page for each brand?

Thanks Boldonglen

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=349563.0

i do think is a small mistake i making can u please have a look if u can
ok here's the problem i am trying to delete an album within the album should also delete the photos related to that album this what i tried gives this error
Delete image failed. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

my tables are
table albums fields album_id, album_name, album_owner, sub_album
table photos fields, photo_id, photo_name, photo_extension, photo_proper photo_owner, photo_date, photo_comments, photo_size, album_id

photo_proper is the name image stored in folder


<?php

define('ROOT_DIR', './');

define('PROPER', TRUE);

/**

* include common files

*/

include_once(ROOT_DIR. 'includes/common.inc.php');





// No album id has been selected

if (isset($_GET['albums'])) 

   // get the album name since we need to display

   // a message that album 'foo' is deleted

   $result = mysql_query("SELECT album_id, album_name, album_owner, sub_album

                          FROM albums

                          WHERE album_id = $album_id")

             or die('Delete image failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row        = mysql_fetch_assoc($result);

      $album_id  = $row['album_id'];

      $album_name = $row['album_name'];



      // get the image filenames first so we can delete them

      // from the server

      $result = mysql_query("SELECT photo_id, photo_id

                             FROM photos

                             WHERE album_id = $album_id")

                or die(mysql_error());

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

      

    define("GALLERY_IMG_DIR", "./photos/");



      

      unlink(GALLERY_IMG_DIR . $row['photo_proper']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['photo_proper']);



      }



      $result = mysql_query("DELETE FROM photos

                             WHERE album_id = $album_id")

                or die('Delete image failed. ' . mysql_error());

      $result = mysql_query("DELETE FROM album

                             WHERE album_id = $album_id")

                or die('Delete album failed. ' . mysql_error());



      // album deleted successfully, let the user know about it

      echo "<p align=center>Album '$album_name' deleted.</p>";

   } else {

      echo "<p align=center>Cannot delete a non-existent album.</p>";

   }







?>



try 2 error line 5
<?php
define('ROOT_DIR', './');
define('PROPER', TRUE);
/**
* include common files
*/
include_once(ROOT_DIR. 'includes/common.inc.php');


// No album id has been selected
if (isset($_GET['albums'])) 
 {
   // get the image file name so we
   // can delete it from the server
   $sql = "SELECT album_id, album_name, album_owner, sub_album

           FROM albums

           WHERE album_id = {$_GET['albums']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);

      // get the image filenames first so we can delete them
      // from the server
     $sql = "SELECT photo_id, photo_proper

           FROM photos

           WHERE photo_id = {$_GET['photos']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);
      
define("GALLERY_IMG_DIR", "./photos/");

      // remove the image and the thumbnail from the server
      unlink(GALLERY_IMG_DIR . $row['photo_proper']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['photo_proper']);
      
      // and then remove the database entry

      $sql = "DELETE FROM photos

              WHERE photo_id = {$_GET['photos']}";
      $result = mysql_query("DELETE FROM album
                             WHERE album_id = $album_id")
                or die('Delete album failed. ' . mysql_error());

      // album deleted successfully, let the user know about it
      echo "<p align=center>Album '$album_name' deleted.</p>";
   } else {
      echo "<p align=center>Cannot delete a non-existent album.</p>";
   }

}
}

?>