PHP - Form With Mutliple Sub Entries

So im trying to make a sign up forum to where you have to put in your zip code..

and im wanting to make a page to where it shows all the individual zip codes that have register but i dont want mutliples.. for example say i have 5 people register from '90210' and if you go to look at the page where it shows the list of zip codes how could i make it only display '90210' once and not 5 times?

im wanting to make this so someone can look at the zip code page and see if anyone near them has registerd on the site as well

Thanks

im doing smting basically wrong

Code: [Select]
<form action="" method="post">
<?php  
$x=1;
$images = $_GET['images'];
for( $i=0; $i<$images; $i++ )
{
   echo '<input name="ID" type="hidden" value="1234" />
<br>
<input name="ImageURL['.$i.']" type="file"  value=""/><br><br>';
}

?>
 
<input name="submit" type="submit" />




<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query("SET NAMES 'utf8'");
mysql_select_db("international", $con);

if (isset($_POST['submit']))
for( $i=0; $i<$images; $i++ )
{
$query=mysql_query("INSERT INTO images (ID,ImageURL) VALUES ('$_POST[ID]','$_POST[ImageURL]')");

exit;



mysql_close($con);
 } 
 
 ?></form>

Now, here's what I'm trying to do: First, I have a file filled with data like such: title tag 1 2 Title Description Etc Next, I upload that file to my site which then proceeds to make an array with said data and then inserts it into my database. But this is not the intended behavior. Right now, if I upload the same file again, it will re-insert everything and duplicate all entries. What I want to do is check if the data in the file has already been added, do nothing. If it's been modified, I want to update the database where changes have been made and not duplicate anything. Currently, my code does all that except one thing whre I'm really stuck: it won't update the changes from the file to the database. I've tried echoing everything and it's to be working except for the query so I take it the error is in there but I can't find it... I'm still learning PHP and MySQL so I thought maybe somebody could help indicate where or what I'm doing wrong in the query. Thanks in advance ! Here's my attempt at doing so:

$register_ep_data = array(
			'show' => $name,
			'season' => $srNum,
			'ep' => $epNum,
			'app_name' => $epName,
			'tag' => $tag,
			'app_about' => $desc,
			'app_website' => $imdb,
			'app_release' => $release,
			'type' => $type,
			'app_code' => $Frame 
			);

array_walk($register_ep_data, 'array_fu');

$fields = '`' . implode('`, `', array_keys($register_ep_data)) . '`';
$data = '\'' . implode('\', \'', $register_ep_data) . '\'';

$epFound = false;
$id = 0;
	 
while ($ep_list_data = mysql_fetch_array($turtle)) {

     $id = $ep_list_data['app_id'];

     $currentNAME = $ep_list_data['app_name'];
     $SERIES = $ep_list_data['show'];

     if ($SERIES == $name) {

        if ($currentNAME == $epName) {
              $epFound = true;
              break;
	}

      }

   }

   if ($epFound) {
      mysql_query("UPDATE `games` SET ($fields) VALUES ($data) WHERE `app_id` = '$id'");
   } else {
      mysql_query("INSERT INTO `games` ($fields) VALUES ($data)");
   }

A few explanations:   $fields would equal to something like: `show`, `season`, `ep`, etc... and $data to 'example', '1', '2', 'etc'

I am trying to create a dynamic table that gets generated based upon users birthday, then selection of last name (via a select menu), then first name (via a select menu), Each selection would subsequently filter out items not chosen.  i.e. if the last name of Griffin were selected, only those with the last name Griffin would be present when selecting the first name.

I have been able to generate the birthday and then last name selection, but I am unclear of how to add the first name into the mix (and any other subsequent filters thereafter)

Here is what I as so far.  Any help would be appreciated.

database sql code:
Code: [Select]
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(20) NOT NULL,
  `lastname` enum('Griffin','Griffin6','Quagmire','Swanson') NOT NULL,
  `age` int(11) NOT NULL,
  `hometown` varchar(25) NOT NULL,
  `job` varchar(25) NOT NULL,
  `birthdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert  into `user`(`id`,`firstname`,`lastname`,`age`,`hometown`,`job`,`birthdate`) values
(1,'Peter','Griffin',41,'Quahog','Brewery','1960-01-01'),
(2,'Lois','Griffin',40,'Newport','Piano Teacher','1961-08-11'),
(3,'Joseph','Swanson',39,'Quahog','Police Officer','1962-07-23'),
(4,'Glenn','Quagmire',41,'Quahog','Pilot','1960-02-28'),
(5,'Megan','Griffin',16,'Quahog','Student','1984-04-24'),
(6,'Stewie','Griffin',2,'Quahog','Dictator','2008-03-03');
index.php:
<?php
include('config.php');  //Include the database connections in it's own file, for easy integration in multiple pages.

$lastname_result = mysql_query("SELECT lastname FROM user GROUP BY lastname");

$result = mysql_query("SELECT * FROM user");

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="start/jquery-ui-1.8.4.custom.css" rel="stylesheet" type="text/css"/></link>
<link href="../themes/style.css" rel="stylesheet" type="text/css" media="print, projection, screen" /></link>
<link href="../common.css" rel="stylesheet" type="text/css"></link>
<script type="text/javascript" src="jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="jquery.tablesorter.js"></script>
<script type="text/javascript" src="jquery-ui-1.8.4.custom.min.js"></script>
<script type="text/javascript">
$(document).ready(function() 
    { 
        $("#myTable").tablesorter({widgets: ['zebra']});
$("#options").tablesorter({sortList: [[0,0]], headers: { 3:{sorter: false}, 4:{sorter: false}}});
    } 
); 

function reSort(par) {
$("#tableBody").empty();
var vfrom = document.getElementById('from').value;
var vto = document.getElementById('to').value;
$.get('table.list.php?from='+vfrom+'&to='+vto+'&lastname='+par,function(html) { 
             // append the "ajax'd" data to the table body 
             $("#tableBody").append(html); 
            // let the plugin know that we made a update 
            $("#myTable").trigger("update"); 
// set sorting column and direction, this will sort on the first and third column 
            var sorting = [[0,0]]; 
            // sort on the first column 
            $("#myTable").trigger("sorton",[sorting]); 
        }); 
}

</script>
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main">
<tr>
<td width="160" valign="top"></td>
<td width="732" valign="top">
<table width="90%" border="0" align="center">
<form method="post">
<label for="from">From</label>
<input type="text" id="from" name="from"/>
<label for="to">to</label>
<input type="text" id="to" name="to"/>
  <?php //added javascript function call to function located in "ajax.js" ?>
<select id="selectbox" name="area" onchange="reSort(this.value);"> <?php //added javascript function call to function located in "ajax.js", and changed the id for content change via javascript. ?>
<option value="">Select an lastname</option>
<option value=""></option>
<?php while(list($lastname)=mysql_fetch_array($lastname_result)) {
     echo "<option value='$lastname'>$lastname</option>";
}
?>
</select>
</form>
</table>
<table id="myTable" class="tablesorter" border="0" cellpadding="5" cellspacing="1">
<thead>
<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Birthday</th>
<th>Hometown</th>
<th>Job</th>
</tr>
</thead>
<tbody id="tableBody"> <?php //added id to the tbody so we could change the content via javascript ?>

</tbody>
</table>  
<p>&nbsp;</p>
<p>&nbsp;</p>
<p align="right">&nbsp; </p>
</td>
<td width="196" valign="top">&nbsp;</td>
</tr>



</table>
</body>
</html>


table.list.php:
<?php
include('config.php');  //database connection.
if(!isset($_GET['lastname'])) { //if the proper get parameter is not there, redirect to google.
header('Location: http://google.com');
exit();
}

$lastname = preg_replace('~[^A-Za-z]+~','',$_GET['lastname']);  //strip out anything but alpha for the name.
$lastname = trim($lastname); //trim the name from all whitespace.
if($lastname != '') { //check against an empty string.  could have just used "empty()".

$where = ' WHERE lastname = \'' . $lastname . '\''; //write the where clause.
}
else { //if lastname is empty, the where clause will be to, and it will return all names.
$where = NULL;
unset($lastname);
}

$from = (isset($_GET['from'])) ? date('Y-m-d',strtotime($_GET['from'])) : NULL;
$to = (isset($_GET['to'])) ? date('Y-m-d',strtotime($_GET['to'])) : NULL;

if($from != NULL && $to != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate BETWEEN '$from' AND '$to'";
}
elseif($from != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate >= '$from'";
}
elseif($to != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate <= '$to'";
}
$query = "SELECT * FROM user $where";
$result = mysql_query($query); //get the database result.
while($row=mysql_fetch_assoc($result)){  //loop and display data.
?>
<tr>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
<td><?php echo $row['age']; ?></td>
<td><?php echo $row['birthdate']; ?></td>
<td><?php echo $row['hometown']; ?></td>
<td><?php echo $row['job']; ?></td>
</tr>

<?php } // End while loop. ?>

Hello, im looking for some help if anyone can be of help... i want to read from a file each line of that file, for each line search the database for that line found in the file and return what comes back, but i want it todo this for the whole file which could be up to 500 diffrent lines. what i have so far doesnt work ive tried a number of things including foreach() some of this could i got some somewhere else they said it worked for them.


$lines = file("/var/www/htdocs/mp32/playlist.lst"); 
   require('dbconfig1.php');//connect to db script 

while($n < count($lines))  {  //get number of lines in file or array 
        $recipeQuery = mysqli_query($conn1, "SELECT * FROM mp_id3_tags WHERE filename LIKE = '$lines[$n]'");   //query database for each one 
            while($recipeQuery1 = mysqli_fetch_array($recipeQuery))  
            {  
            print "{$recipeQuery1['artist']}";  
            }  
        $n = $n + 1;  
        } 

Below is the part of my code that creates the html table.  How do I add pagination every 30 entries?



$db = mysql_connect("localhost","trend_learnu","asdfasdf");
mysql_select_db("trend_learningdb",$db);

$result = mysql_query("SELECT * FROM Peoples ORDER BY number ASC");

$table = '<table width="608" border="0" align="center" cellpadding="10" cellspacing="0">
  <tr>
    <td style="color:#fff;" width="207" bgcolor="#425d74"><strong>Firstname</strong></td>
    <td style="color:#fff;" width="204" bgcolor="#425d74"><strong>Lastname</strong></td>
    <td style="color:#fff;" width="197" bgcolor="#425d74"><strong>Date</strong></td>
<td style="color:#fff;" width="197" bgcolor="#425d74"><strong>Weight</strong></td>
  </tr>';

while($row=mysql_fetch_array($result))
{
  $firstname = $row['Firstname'];
  $lastname = $row['Lastname'];
  $weight = $row['Weight'];
  $date = $row['Date'];

   $table.= '<tr>';
   $table.= '<td bgcolor="#e8f4ff">'.$firstname.'</td>';
   $table.= '<td bgcolor="#e8f4ff">'.$lastname.'</td>';
   $table.= '<td bgcolor="#e8f4ff">'.$date.'</td>';
   $table.= '<td bgcolor="#e0ffe6"><strong>'.$weight.'</strong></td>';
   $table.= '</tr>';
}
$table .= '</table>';

echo $table;



mysql_close($con)

the problem is that when I add an item to be displayed in the blog, shows three instead, which two are empty.
It should not create three entries when I just add one entry. How can I fix this?

<?PHP
/* define the blog content file name */
$filename = "myBlogContent.txt";
?>




<?php
/* check to see if the file exists */
if (!file_exists($filename)) {

echo "The Blog Is Empty";

}else{

/* get the file lines into an array */

$BlogArray = file($filename);

/* count the number of blog entries */
$count = count($BlogArray);

$i=0;

while($i<$count) {

$new_array = explode("|", $BlogArray[$i]);

echo "Posted by: " . $new_array[1] . "<br>";

echo "Posted on: " .  date("m/d/y h:iA", time($new_array[0])) . "<br>"
echo 

"Title: " . $new_array[2] . "<br>";


echo $new_array[3] . "<hr>";


$i ++;


}
}
?>





<?PHP
/* obtain the form data */
$who = $_POST['who'];
$title = $_POST['title'];
$content = $_POST['content'];
$content = str_replace(array("\r\n", "\r", "\n"), "<br>", $content); 

/* create timestamp variable for current date and time */
$when_ts = time(); 

/* define the blog content file name */
$filename = "myBlogContent.txt";

/* prepare the variables for adding to the file */

$new_line_content = $when_ts . "|" . $who . "|" . $title . "|" . $content . "\n";

/* open the file in the APPEND MODE */
$fh = fopen($filename, 'a+') or die("can't open file");

/* add the new content */
fwrite($fh, $new_line_content); 

/* close the file */
fclose($fh); 

 
//exit; // Closes further script execution . 
?>

I have an issue with some code I have.  All the code works correctly apart from when submit is clicked not only does it update a the current club but it creates a blank entry in the database!  I cant see whats wrong.  Here is the code.........



//gets
$validation = $_GET['new_club'];
//Querys
    $qGetClub = "SELECT * FROM clubs WHERE validationID = '$validation'"; 
$rGetClub = mysql_query($qGetClub);
$Club = mysql_fetch_array($rGetClub);
//Query for category by name
$qGetCat = "SELECT * FROM club_category WHERE catID = ".$Club['cat']."";
$rGetCat = mysql_query($qGetCat);
$CatName = mysql_fetch_array($rGetCat);
//query for related sub categorys.
$qGetSub = "SELECT * FROM sub_categorys WHERE catID =".$Club['cat']."";
$rSubCat = mysql_query($qGetSub);
// query for groups created
$Groupq = mysql_query("SELECT * FROM groups WHERE memberID = '".$User['memberID']."'");

//end of querys

if(isset($_POST['insert_clubbtn1'])){ 
//Process data for validation     
$subcat     = trim($_POST['subcat']);  
$NewSubCat = trim($_POST['NewSubCat']); 
//Prepare data for db insertion      
$subcat = mysql_real_escape_string($subcat); 
//find the new category 
//insert
$result = mysql_query("UPDATE clubs  SET 
`sub_category` = '$subcat'
WHERE validationID ='$validation'") or die(mysql_error());



if ($result!=="") {
$otherg = trim($_POST['other_groups']);
$newg = trim($_POST['new_group']);
$newg = mysql_real_escape_string($newg);     
//if an item other than none from the list is selected then update the club with an ID relating to the group it belongs to
if ($otherg !=='None') { $groupsq = mysql_query("UPDATE `clubs` SET groupID ='$otherg' WHERE validationID ='$validation'") or die (mysql_error()); }
// If none is selected then $newg must have a value so create a new group in the groups table and then on the next page I will add the group in the club table 
else {
$groupsq = mysql_query("INSERT INTO `groups` (`memberID`, `group`, `clubID`) VALUES ('".$User['memberID']."', '$newg', '".$Club['clubID']."')")or die (mysql_error());
}   }

if ($NewSubCat !="") { mail("mail","New Sub Category Request","Dear Ring Master,
\n\nThe club in the name of $name with a validation code of $validationID would like a new sub category called $new_cat\n\n  
\nTeam Arena\n\n\n\n"); }

$url = "/members/create/create_clubp3.php?new_club=$validation";  
header("Location: $url");     
}

Is there any other way of getting PHP form data into C# any other way besides calling  

www.downloadHandler.text

I am having issues  bringing all the entries into C# and breaking them all up.  I can do one row fine but multiple rows isn't working.  I keep getting an out range error.

This is my PHP echo

echo $row['userName']. '|' .$row['level']. '|' .$row['points']. '|' .$row['killRate']. '/';

And this is my C# code

                string nothing = "Not Placed";
                string Data_string = www.downloadHandler.text;
                string[] DataArray;
                DataArray = Data_string.Split('/');

                int numberOfEntries = DataArray.Length;
                Debug.Log(numberOfEntries);

                if (DataArray[0] == null || numberOfEntries == 1)
                {
                    DataArray[0] = nothing;
                    Debug.Log("Data Array [0] isn't there");
                    High_Points_1.text = DataArray[0];

                }
                else
                {
                    High_Points_1.text = DataArray[0];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[1] == null || numberOfEntries == 2)
                {
                    DataArray[1] = nothing;
                    Debug.Log("Data Array [1] isn't there");
                    High_Points_2.text = DataArray[1];
                }
                else
                {
                    High_Points_2.text = DataArray[1];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[2] == null || numberOfEntries == 3)
                {
                    DataArray[2] = nothing;
                    Debug.Log("Data Array [2] isn't there");
                    High_Points_3.text = DataArray[2];
                }
                else
                {
                    High_Points_3.text = DataArray[2];
                }
                if (DataArray[3] == null || numberOfEntries == 4)
                {
                    DataArray[3] = nothing;
                    Debug.Log("Data Array [3] isn't there");
                    High_Points_4.text = DataArray[3];
                }
                else
                {
                    High_Points_4.text = DataArray[3];
                }
                if (DataArray[4] == null || numberOfEntries == 5)
                {
                    DataArray[4] = nothing;
                    Debug.Log("Data Array [4] isn't there");
                    High_Points_5.text = DataArray[4];
                }
                else
                {
                    High_Points_5.text = DataArray[4];
                }

I have two entries in the database.  But when I debugged the number int he array I get 3 strings.

I want to show the top five entries in the database.

So, I've been trying to get this query working and can't quite get it to work.  I'm trying to get an "array" of distinct browsers from the database, but it's only showing one of them.  There are 3 unique browsers in the table and only "Chrome 30" gets returned.  Here is the query:

SELECT DISTINCT `browser` AS `unique_browsers`,
     COUNT(DISTINCT `ip`) AS `unique_visitors`,
     COUNT(DISTINCT `country`) AS `unique_countries`,
     COUNT(`id`) AS `total_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Chrome%') AS `chrome_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Internet Explorer%') AS `ie_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Firefox%') AS `firefox_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Safari%') AS `safari_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Opera%') AS `opera_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` NOT LIKE '%Chrome%' AND `browser` NOT LIKE '%Internet Explorer%' AND `browser` NOT LIKE '%Firefox%' AND `browser` NOT LIKE '%Safari%' AND `browser` NOT LIKE '%Opera%') AS `unknown_count`
FROM `table`
GROUP BY `browser` 

Everything works properly except the line:

Hello...
I have a .txt database with ~100 records.  I only want to show the 15 records that are at the top (referring to reading order of the file).
Here is my php code to display the records.
http://www.flcbranson.org/mobile.php?content=mobile-freedownloads.php if you want to see the results of the code, below.
Code: [Select]
<?php
$index_file = 'services/series/Index-Date.txt';
$fd = fopen($index_file, 'r');
if ($fd) {
        while (!feof ($fd)) {
                $seriestitle = trim(fgets($fd, 1024)); // Series Title
                if(feof ($fd))
                break;
                $seriessubtitle = trim(fgets($fd, 1024)); // Series subtitle
                $seriesinfo  = trim(fgets($fd, 1024)); // Series Info (Church name)
                $serieslocation = trim(fgets($fd, 1024)); // City, State
                $seriesindex = trim(fgets($fd, 1024)); // Series index file
                $seriesstatus = trim(fgets($fd, 1024)); //Online Only?
                $divider     = trim(fgets($fd, 1024)); // Divider
                $seriestitle2 = $seriestitle;
                $seriestitle3 = str_replace("'", "%27", $seriestitle); // Kind of makes the alt= below work "God's Will" ends up being "God%27s Will" but without is "God"
                if(strstr($seriestitle,"<")) {
                        $seriestitle2 = strip_tags($seriestitle);
                }
                $seriestitle2 = urlencode($seriestitle2);
                if(file_exists("images/ProductCovers/".substr($seriesindex,0,-4).".jpg")) {
                        echo "<img src='images/ProductCovers/".substr($seriesindex,0,-4).".jpg' width='115' height='150' border='0' alt='".substr($seriestitle3,7)."'><br />";
                }
        }
        fclose ($fd);
}
?>
I'm assuming that "for" would do the trick, but when I tried I got 10 copies of every record.
Hehehe...
I'm guessing that it's a quick fix.
Thanks...
JJ

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?

Hello,

For starters I'm not sure if what I want to do is possible, but if it is I would like your input. I have a script that will show a number of fields to fill out in a second form based on the number the user puts into the first from. the problem is that only the last one saves into the database and not all of them.

Code: [Select]
<form auction="index.php" method="post">
System Name: <input type="text" name="systemname">
Number of E-sites: <input type="text" name="events">
Number of Sigs: <input type="text" name="sigs"><br>
<input type="reset" name="reset" value="Reset">
<input type="submit" name="start" value="Start">
</form>
<form auction="index.php" method="post">
<?php
$events = $_POST['events'];
$system = $POST['systemname'];

if (isset($_POST['start'])) {
$num = $_POST['sigs'];
$i = 0;
While ($i < $num)
{
echo "Sig ID: <input type=text name=sigid>";
echo "Type: <input type=text name=type>";
echo "Name: <input type=text name=name>";
echo "Notes: <input type=text name=notes>";
echo "<br>";
$i++;
}
}
?>
<input type="submit" name="enter" value="Enter">
</form>
<?php
$sigid = $_POST['sigid'];
$type = $_POST['type'];
$name = $_POST['name'];
$notes = $_POST['notes'];
mysql_connect('xt', 'x', 'x');
mysql_select_db('wormhole');
if (isset($_POST['enter'])) {

$query = "INSERT INTO sites VALUES ('$system','$events','$sigid','$type','$name','$notes')";
mysql_query($query);

}
?>
How do I get it so all the data saves, lets say that $num = 5, I want all 5 to save not just the last one.

I am quite new so I am sure this is an easy fix for some of the experts around here.

I am using the canned script below to add urls to the database as text.  The problem is if you update one of the form text boxes it loads all the urls into the database again resulting in a lot of duplicates.

My question is, How do I get the form to only post the new changes and not re-post the existing urls?


<?php
session_start();

   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
   {
        include_once("dbc.php");

        if($_POST)
        {
            $c = 0;
            
            $errMssg = "";

            for($i=0;$i<count($_POST['url']);$i++)
            {
                if($_POST['url'][$i]=="")
                {
                    $c++;
                }
            }
            if($c==5)
            {
                $errMssg = "Submission error . Please fill at least 1 url.";
            }
            else
            {
                for($j=0;$j<count($_POST['url']);$j++)
                {
                    if(!empty($_POST['url'][$j]))
                    {
                        $sql = mysql_query("INSERT INTO images (id ,url ,user_id)VALUES (NULL , '".$_POST['url'][$j]."',".$_SESSION['userId'].")");    

                     }
                                    
                }
                
            }
        }    

        
        

        $sqlresult = mysql_query("SELECT * FROM images WHERE user_id =".$_SESSION['userId']);
        
        $count = 0;
            
        while($data = mysql_fetch_array($sqlresult))
        {
            $image[$count] = $data['url'];

            $count++;

        }
         
?>

Hi guys 

Im trying to delete multiple images from  a page with the code below, I have retirieved the images successfully but i can not delete the with checkbox,

wht it does is just refereshing the page and thats it, what im trying to do is to delete the image from the database but it wont.

can u help me please?

<?php
session_start();

include ("../../global.php");
//welcome messaage
$username=$_SESSION['username'];
echo "$username";

$query=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row = mysql_fetch_assoc($query))
{
$user_id = $row['id'];
}

$ref=$_GET['reference'];


$images=mysql_query("SELECT * FROM img WHERE refimage='$ref'");

while($row = mysql_fetch_array($images))
{
$image=$row['image'];
$thumb=$row['thumb'];





?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="" method="post" action=''>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo "<a href='$image' rel='lightbox[roadtrip]'><img src= '$thumb' width='60' height='40' alt='$title'>";?></td>
<?
}
?>


<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php

// Check if delete button active, start this
$delete = $_REQUEST['delete'];
if( $delete != '' ){
$checkbox = $_REQUEST['checkbox'];
$count = count($_REQUEST['checkbox']);
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$del = mysql_query("DELETE FROM img WHERE id = '$del_id'");

}
}

?>