PHP - This Should Be Simple, But I Dont Know That Much Php

i am a beginerr in php..
and here is my code..which shows error in the querry line..
erro goes like this

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\restafinal\process_edit_page.php on line 56

and code goes like this..
echo part works well...that query line is the error line..please tell me whats the problem...

Code: [Select]
<?php



//$id=$_GET["id"];
$id= $_GET['id'];
 $menu_name= $_POST['menu_name'];

 $position= $_POST['position'];
 $visible= $_POST['visible'];
 $note= $_POST['note'];
 $content= $_POST['content'];
 
 
 //echo part works well..
echo "menu_name"; echo $menu_name;
 echo "<br/>";
 echo "position"; echo $position;
   echo "<br/>";
 echo "visible";  echo  $visible;
    echo "<br/>";
  echo "note";  echo $note;
   echo "<br/>";
echo "id"; echo $id;

echo $content;



[b]$result = mysql_query(UPDATE page SET note =$note, nevigation = $menu_name WHERE id = $id,$connection)[/b]

// test to see if the update occurred
if (mysql_affected_rows() == 1) {
// Success!



} else {
$message = "The page could not be updated.";
$message .= "<br />" . mysql_error();
}




?>

I have this script where it uploads the file name to a database plus a few more things.

Main Upload form. (img_add.php)
 <form enctype="multipart/form-data" action="img_add.php" method="POST"> 
 Name: <input type="text" name="name"><br> 
 E-mail: <input type="text" name = "email"><br> 
 Phone: <input type="text" name = "phone"><br> 
 Photo: <input type="file" name="photo"><br> 
 <input type="submit" value="Add"> 
 </form>

Uploader. (img_add.php)
<?php 
 
 //This is the directory where images will be saved 
 $target = "mainnewsimg/"; 
 $target = $target . basename( $_FILES['photo']['name']); 
 
 //This gets all the other information from the form 
 $name=$_POST['name']; 
 $email=$_POST['email']; 
 $phone=$_POST['phone']; 
 $pic=($_FILES['photo']['name']); 
 
 // Connects to your Database 
 mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
 mysql_select_db("chat") or die(mysql_error()) ; 
 
 //Writes the information to the database 
 mysql_query("INSERT INTO `images` VALUES ('$name', '$email', '$phone', '$pic')") ; 
 
 //Writes the photo to the server 
 if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
 { 
 
 //Tells you if its all ok 
 echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 //Gives and error if its not 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

And the one that views it. (img_view.php)
It uses a get function so do it with img_view.php?img=2
<?php 
 mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
 mysql_select_db("chat") or die(mysql_error()) ; 
 
 //Retrieves data from MySQL 
         $newsid = $_GET['img'];
 $data = mysql_query("SELECT * FROM `images` WHERE id ='$newsid'") or die(mysql_error()); 

//Puts it into an array
 while($info = mysql_fetch_array( $data )) { 
//Outputs the image and other data
 Echo "<img src=mainnewsimg/".$info['photo'] ."> <br>";
 }
 ?> 

And my database sql.

CREATE TABLE IF NOT EXISTS `images` (
  `name` varchar(30) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `photo` varchar(30) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`name`, `email`, `phone`, `photo`, `id`) VALUES
('sdf', 'sdfdsdsf', 'dsffsfsdf', 'arrow_forward_last.gif', 1),
('sadd', 'sadd', 'adsadasdad', 'artbottomshadr.png', 2);


The values inside I had to put in manually to test if it worked for the img_view.php

Anyways, It doesnt want to upload the images at all, even tho it says it did and gives the message
The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory

I would greatly appreciate some help, I also provided everything so you can try it on your own server too.

why this simple code only works on chrome??

function mostrarOcultar(obj) {
  document.getElementById('seguro').style.visibility = (obj.checked) ? 'hidden' : 'visible';
}

Hi, im using colorbox(basically like lightbox) for some links on my site. When a user clicks the link it opens this lightbox. But if they type the link into the address bar manually it takes them to the actual page(which isnt formatted properly). Is there a way to open up the lightbox when they enter the address manually? or a work around?

although im using nl2br, and \r\n in the code below, my results are still displaying;

result1,result2,result2

opposed to

result1
result2
result3

How can i change to this format?

$code = $_GET['postcode'];
$message = $_GET['message'];
$shortcode = substr($code,0,2);
$subject = "subject here";
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";
$number_of_results = mysql_num_rows($result);
$results_counter = 0;
if ($number_of_results != 0) 
{while ($array = mysql_fetch_array($result)) 
{$email = $array['email'];
$results_counter++;
if ($results_counter >= $number_of_results) {$to .= $email;} 
else {$to .= $email . ',';}}}
$headers = 'From: me@me.com' . "\r\n" .
    'Reply-To: me@me.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
$message .= "\r\n". $to ;
echo nl2br ($message);
mail( "$to", "$subject","$message", "$headers");
echo "<br>" . "Thank you for using our mail form.";
?></body></html>

I have the echo statement set up for all files, but what i want to do is put an if statement for example if it contains .pdf or .docx dont echo out an image how would i do this? 

Code: [Select]

<?php $id = explode("/", $_GET['a']); $id = $id[2]; ?>
<?php global $allow_client_uploads; ?>
<div id="content">
<div class="wrapper content">

<h3 class="page-title"><?php echo $project['name']; ?></h3>

<div id="client-controls">
<a href="<?php echo $this->redirect('messages/add/'.$id, true); ?>" class="new-message">Post Message to Admin</a>

<?php if($allow_client_uploads): ?>
<a href="<?php echo $this->redirect('documents/add/'.$id, true); ?>" class="new-file">Upload A Document</a>
<?php endif; ?>

<a href="<?php echo $this->redirect('clients/change_password', true); ?>" class="change-password">Change Password</a>
</div>

<!--<div class="project-progress">Progress
<div class="progressbar">
        <div id="test" class="progressbar-completed"
style="width:<?php // echo $project['progress']; ?>%;">
            <div>&nbsp;</div>
        </div>
        <div><?php // echo $project['progress']; ?>%</div>
    </div>
    </div> -->
   
<ul class="project-phases">

<?php $n=0; global $document_upload_path;?>

<?php foreach($project['phases'] as $phase): ?>

<li class="clearfix">

<div class="large-bullet"><?php echo ++$n; ?> </div>

<h1 class="phase-title"><?php echo $phase ?></h1>

<?php if(@count($documents[$n])>0): ?>

<ol class="documents">

<?php foreach($documents[$n] as $doc): ?>
<li>
<a href="<?php echo $this->redirect('documents/download/'.$doc['path'], true); ?>">
<?php echo $doc['description']; ?> <br />
</a>

<?php //echo $doc['size']."K - "; ?>

<span class="date"><?php // echo date("F j, Y, g:i a", $doc['created']); ?></span>  
<?php // echo (isset($doc['uploaded_by']))? ", by ".$doc['uploaded_by']:""; ?>
                       <a href="/clientele/uploads/<?php echo $doc['path'];?>" class="lightbox"><?php echo '<img src="/clientele/uploads/'.$doc['path'].'" height="300" width="300">'; ?></a>
</li>
<?php endforeach;?>
</ol>

<?php else: ?>

<?php endif; ?>
</li>
<?php endforeach;?>
</ul>

<div class="sidebar">

<?php if(is_array($messages)): ?>
<div class="messagebar">Latest News</div><br />
<?php foreach($messages as $message): ?>

<div class="message clearfix">
           
<p class="body"><?php echo $message['message']; ?></p>
<span class="meta"> <?php // echo $message['posted_by']; ?></span>
</div>

<?php endforeach; ?>

<?php endif; ?>

</div>


<div class="clear"></div>
</div>
</div>

keep gettin error msg
Notice: Undefined index: id in C:\wamp\www\profile.php on line 42
 dun everything to define the index cud it b the verion of wamp i am using

Code: [Select]
if ($_GET['id']) {

     $id = $_GET['id'];

} else if (isset($_SESSION['id'])) {

$id = $_SESSION['id'];

} else {
print "important data to render this page is missing";
   //include_once "index.php";
   //}
   }
   //exit();
[code]

Hello,

im using a contact form which sends me an email with the data name.. comments ..

Now im testing a new better server which use IMAP (old POP3) and my form is not working like it used to be..

Code: [Select]
                $emailTo = " $dbSentEmail"; //Put your own email address here
$emailServer = "noreply@totalsports.com.cy"; //Put your own email address here
$body = "Name: $name \n\nEmail: $email \n\nSubject: $subject \n\nComments:\n $comments";
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/plain; charset=UTF-8' . "\r\n";
$headers .= 'From: Contact Form <'.$emailServer.'>' . "\r\n" . 'Reply-To: ' . $email;

mail($emailTo, $subject, $body, $headers);

Any idea what i have to do to work like before?

ok , i made a friends thing  and its to hard to work with so i need to change it to where it has it own table ... i had it in an array in a table with other things , and now its hard to get it from the array so i want to make it simpler ... so here is my code and what i want to do , i need help and thank you in advance

here is my part 1 of my adding people as friends.
Code: [Select]
<?php
if ($_POST["request"] == "requestFriendship") {

    $mem1 = preg_replace('#[^0-9]#i', '', $_POST['mem1']); 
    $mem2 = preg_replace('#[^0-9]#i', '', $_POST['mem2']); 
//
if (!$mem1 || !$mem2 || !$thisWipit) {
echo  'Error: Missing data';
     exit(); 
}
//
if ($mem1 == $mem2) {
     echo  'Error: You cannot add yourself as a friend';
     exit(); 
} 

$sql_frnd_arry_mem1 = mysql_query("SELECT friend_array FROM myMembers WHERE id='$mem1' LIMIT 1"); 
while($row=mysql_fetch_array($sql_frnd_arry_mem1)) { $frnd_arry_mem1 = $row["friend_array"]; }
$frndArryMem1 = explode(",", $frnd_arry_mem1);
    if (in_array($mem2, $frndArryMem1)) { echo  'This member is already your Friend'; exit(); }

$sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1");
$numRows = mysql_num_rows($sql);
if ($numRows > 0) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> You have a Friend request pending for this member. Please be patient.';
        exit(); 
}
$sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1");
$numRows = mysql_num_rows($sql);
if ($numRows > 0) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> This user has requested you as a Friend already! Check your Requests on your profile.';
        exit(); 
}
$sql = mysql_query("INSERT INTO friends_requests (mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("Friend Request Insertion Error"));
//$sql = mysql_query("INSERT INTO pms (to, from, time, sub, msg) VALUES('$mem2','XXXXX',now(),'New Friend Request','You have a new Friend Request waiting for approval.<br /><br />Navigate to your profile and check your friend requests. <br /><br />Thank you.')") or die (mysql_error("Friend Request PM Insertion Error"));
    //$id = mysql_insert_id();
echo '<img src="images/round_success.png" width="20" height="20" alt="Success" /> Friend request sent successfully. This member must approve the request.';
    exit(); 
}
?>Now i need to change my code to where it inserts all this info and stuff not as an array and , in another table which is called "friends" my table is set up like this
Code: [Select]
-- Table structure for table `friends`

CREATE TABLE IF NOT EXISTS `friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_1` int(11) NOT NULL,
  `mem_2` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


So please if im not clear enough i will post more details

As expected when a die statement is triggered, my script is exited and ALL of the fields that have been filled in on my form are wiped clean. 
This however is proving to be annoying for users making mistakes. 
Is there a way to keep the data in the correctly filled in fields, and to just wipe or highlight the incorrectly filled in fields?

Code: [Select]
<?php 
 function checkPostcode (&$toCheck) 
 { 
 $alpha1 = "[abcdefghijklmnoprstuwyz]";                           
 $alpha2 = "[abcdefghklmnopqrstuvwxy]";                          
 $alpha3 = "[abcdefghjkstuw]";                                   
 $alpha4 = "[abehmnprvwxy]";                                       
 $alpha5 = "[abdefghjlnpqrstuwxyz]";                               
 $pcexp[0] = '^('.$alpha1.'{1}'.$alpha2.'{0,1}[0-9]{1,2})([0-9]{1}'.$alpha5.'{2})$';  
 $pcexp[1] =  '^('.$alpha1.'{1}[0-9]{1}'.$alpha3.'{1})([0-9]{1}'.$alpha5.'{2})$';
 $pcexp[2] =  '^('.$alpha1.'{1}'.$alpha2.'[0-9]{1}'.$alpha4.')([0-9]{1}'.$alpha5.'{2})$';
 $pcexp[3] =  '^(gir)(0aa)$';  
 $pcexp[4] = '^(bfpo)([0-9]{1,4})$';
 $pcexp[5] = '^(bfpo)(c\/o[0-9]{1,3})$'; 
 $Postcode = strtolower($toCheck);
 $Postcode = str_replace (' ', '', $Postcode);
 $valid = false;
 foreach ($pcexp as $regexp) {    
 if (ereg($regexp,$Postcode, $matches)) {      
 $toCheck = strtoupper ($matches[1] . ' ' . $matches [2]);    
 $toCheck = ereg_replace ('C\/O', 'c/o ', $toCheck);
 $valid = true;
 break;     
 }  
 }  
 if ($valid){return true;} else {return false;};
 }
if(isset($_POST['submit']))
{
$drop = mysql_real_escape_string($_POST['drop_1']);
$tier_two = mysql_real_escape_string($_POST['Subtype']);
$Name = mysql_real_escape_string($_POST["Name"]);
$Phone = mysql_real_escape_string($_POST["Phone"]);
$Email = mysql_real_escape_string($_POST["Email"]);
$Postcode = mysql_real_escape_string($_POST["Postcode"]);
$Website = mysql_real_escape_string($_POST["Website"]);
if($Name == '')
{
die ("<div class=\"form\">You did not complete the name field, please try again</div>");
}
elseif  ($Phone == '' or (preg_match("/^([1]-)?[0-9]{3}-[0-9]{3}-[0-9]{4}$/i", $Phone)))
{
die("<div class=\"form\"> You completed the telephone field incorrectly, please try again</div>");
}
elseif  ($Email == '' or (!filter_var($Email, FILTER_VALIDATE_EMAIL)))
{
die("<div class=\"form\"> You completed the Email field incorrectly, please try again</div>");
}    
elseif  ($Postcode == '' or (!checkPostcode($Postcode)))
{
die("<div class=\"form\"> You did not complete the Postcode field correctly, please try again</div>");
}   
elseif  ($Website == '' or (!preg_match("~^[a-z0-9.-]+\.(com|org|net|edu|co.uk)~i", $Website)))
{   
die("<div class=\"form\">You completed the website field incorrectly, please try again</div>");
}
else
{
echo("<div id=\"formtwo\">Thankyou for submiting your details, you will be added to our directory shortly</div>");
}
$query = ("INSERT INTO business (`id`, `Name`,  `Type`, `Subtype`, `Phone`, `Email`, `Postcode`, `WebAddress`, `Confirmed`)
  VALUES ('NULL', '$Name', '$drop', '$tier_two' , '$Phone', '$Email', '$Postcode', '$Website', 'Yes')");
mysql_query($query) or die ( "<br>Query: $query<br>Error: " .mysql_error());
}
?>

hi everyone

i am currently making my website with an uploadform. The upload function is working, but now i am trying to make the site remember the last 5 uploads. The filenames should appear in an array:
$aotf[0]
$aotf[1]
$aotf[2]
$aotf[3]
$aotf[4]
and since all files that can be/are uploaded are images, i want them to be drawed next to each other, each 128x128. THAT is working, but the fetch for images doesn't. When an image is uploaded, i execute this code:
    $readhandle=fopen("uploaddb.log","r");
    $aotf=fread($handle,filesize("uploaddb.log"));
    fclose($readhandle);
    $writehandle=fopen("uploaddb.log","w");
    fwrite($writehandle,"$aotf\r\n" . "uploadform/gebruikers/" . $naam);
    fclose($writehandle);
then,there is some html code, and then there is this code:

$aotf=explode("/n",$aotf);
for($i = count($aotf) - 5; $i <= count($aotf); $i++) {
echo ' <img src="'. $aotf[$i] . '" width="128" height="128"> ';
}

when i open the page, all img src's are empty. The writing works, and the folder of the image is 7777 chmod and the images draw on the screen, but not as the last uploaded. Does anyone know how to make this work? maybe even without a fwrite?


Thank you,

masterens

EDIT: i cannot use mysql

hi every one
i want to make a list from my database and if user click on one item it open a link... its a list of models of products so if click in one link me to the page of its full description, my database has the fields: "modelo" (model), and "paginal" the link page i make this code.. works fine cause display all the catalog but when i click in an item dont do nothing... hes the code.. what im missing??
tnx in advance


    <?PHP
// Connect to MySQL Server
@mysql_connect('localhost','user','password') or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db('zerocctv_almacen') or DIE("Couldn't Select Database");
$sql = "SELECT modelo, paginal,precio,foto FROM modelos";
$result=mysql_query($sql);
$row_array=mysql_fetch_row($result);
$string='<select name=selection><option value=>modelo</option>';

for ($i=0;$i < mysql_num_rows($result);$i++)
{
if ($row_array[0]=="")
{
$row_array=mysql_fetch_row($result);
}
else
{
$string .='<option value="'.$row_array[1].'">'.$row_array[0]."</option>";
$row_array=mysql_fetch_row($result);
}
}
$string .='</SELECT>';
//echo "</label>";
echo $string;
?>

I am building a commenting system, it's sort of like facebooks comments. I have it right now so it loads the first last 3 comments in the database, and then there's a button to view all comments. I have it working fine, except when you add another comment to it, and then click the view all comments,


This is the script that loads onload showing the last 3 comments


$limit  = 3;

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$id' ORDER BY id DESC LIMIT $limit");



This is the php script that runs when you click view more




//($start_id would be 3 in this case)

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$comment_id' ORDER BY id DESC LIMIT $start_id, 1000");

so to try to show you what's happening:

OnLoad--------------------------------|---When you add more comments, (let's just say u add 1 comment before u click view comments)----
comment 9   --------------------------|   comment 10
comment 8   --------------------------|   comment 9
comment 7   --------------------------|   comment 8
------------------------------------------|   comment 7
----to be loaded onclick-------------|------What's loaded onclick---
comment 6   --------------------------|   comment 7
comment 5   --------------------------|   comment 6
comment 4   --------------------------|   comment 5
comment 3   --------------------------|   comment 4
comment 2   --------------------------|   comment 3
comment 1   --------------------------|   comment 2
------------------------------------------|   comment 1


(see how "comment 7" is being shown twice in a row)

Hi,

my page is currently up at brewhas.org/transactions.php.  When I retrieve a set of results > the defined # per page (such as entering 'WI' for last name), I see the first page correctly, and see the links to next pages, but when I go to the next page there are no results displayed.  Same for p.3, etc.

So I've looked around enough to know that I need to pass a variable to the subsequent pages, either via a session variable or the URL.  I have 2 fields input on the form, as well as a limit and offset.  My questions are 1) do I need to pass all 4 and if so then should I use a session variable so the URL does not get too long, and 2) can anyone provide any help with setting session variables and including them to be passed?

I'm a newbie and have grabbed some code where I can but this is where i'm stuck.  thanks in advance.
Code: [Select]
         <?php
               include 'config.php';
               include 'opendb.php';
               $rows_per_page = 20;

                  //Get the values from the text boxes         
                  $fnamesearch = $_POST["fnamesearch"];
                  $lnamesearch = $_POST["lnamesearch"];

                  //These trim and convert the name fields to upper case.
                  $fnamesearch=strtoupper($fnamesearch);
                  $lnamesearch=strtoupper($lnamesearch);
                  $fnamesearch=trim($fnamesearch);
                  $lnamesearch=trim($lnamesearch);
            
                  // Count how many rows are coming back for the query
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT COUNT(*) FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%'))";
                     }

                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the get count query
                  $query_data = mysql_fetch_row($result);
                  $numrows = $query_data[0];
                  echo "count: ".$numrows;   
                  $lastpage = ceil($numrows/$rows_per_page);      //determines how many pages based on rows divided by rows per page
                  echo "pages: ".$lastpage;

                  // Get required page number.  If not present, default to 1.
                  if (isset($_GET['pageno']) && is_numeric($_GET['pageno'])) 
                     {$pageno = $_GET['pageno'];
                     } 
                  else 
                     {$pageno = 1;
                     } 
                  
                  //Checks that the value of $pageno is an integer between 1 and $lastpage.
                  $pageno = (int)$pageno;
                  if ($pageno > $lastpage) 
                     {$pageno = $lastpage;
                     } 
                  if ($pageno < 1) 
                     {$pageno = 1;
                     }                  
               
                  //constructs OFFSET for the sql SELECT statement
                  $offset = ($pageno - 1) * $rows_per_page;
                  
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT * FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%')) LIMIT $offset, $rows_per_page";
                     }
      
                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the query
                  //Count the number of results 
                  $numrows=mysql_num_rows($result);
                  
                  echo "<p class='style7'>Your search: &quot;".$fnamesearch." ".$lnamesearch."&quot; returned <b>".$numrows."</b> results.</p>";
                  
                  if ($numrows == 0)  //if no matches, don't display the table 
                        exit;
                  else            //build the table and insert rows 
                     {
                              echo "<table border=1 cellspacing=0 cellpadding=1 width='77%' align=left bordercolor=#666666>";
                              echo "<tr bgcolor=#cccc99 class='style5'><th width='10%' class='style5'>Date</th>";
                              echo "<th width='10%' class='style5'>Action</th>";
                              echo "<th width='12%' class='style5'>From</th>";
                              echo "<th width='12%' class='style5'>To</th>";
                              echo "<th width='5%' class='style5'>Pos</th>";
                              echo "<th width='18%' class='style5'>Name</th>";      
                              echo "<th width='5%' class='style5'>Round</th></tr>";                     
      
                           while ($row = mysql_fetch_array($result))
                           {
                              echo "<tr><td width='10%' class='style6'>".$row['TRANS_DT']."</td>";
                              echo "<td width='10%' class='style6'>".$row['TRANS_ACTION']."</td>";
                              echo "<td width='12%' class='style6'>".$row['FROM_OWNER']."</td>";
                              echo "<td  width='12%' class='style6'>".$row['TO_OWNER']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['POSITION']."</td>";
                              echo "<td  width='18%' class='style6'>".$row['PLAYER_FNAME']." ".$row['PLAYER_LNAME']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['DRAFT_RND']."</td></tr>";
                           }
               
                           /******  build the pagination links ******/   
                           // if not on page 1, don't show back links
                           if ($pageno > 1) {
                              // show << link to go back to page 1
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'><<</a> ";
                              // get previous page num
                              $prevpage = $pageno - 1;
                              // show < link to go back to 1 page
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'><</a> ";
                           }
                           // range of num links to show
                           $range = 3;

                           // loop to show links to range of pages around current page
                           for ($x = ($pageno - $range); $x < (($pageno + $range)  + 1); $x++) {
                              // if it's a valid page number...
                              if (($x > 0) && ($x <= $lastpage)) {
                                // if we're on current page...
                                if ($x == $pageno) {
                                  // 'highlight' it but don't make a link
                                  echo " [<b>$x</b>] ";
                                // if not current page...
                                } else {
                                  // make it a link
                                  echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$x'>$x</a> ";
                                } // end else
                              } // end if 
                           }
                           // if not on last page, show forward and last page links        
                        if ($pageno != $lastpage) {
                           // get next page
                           $nextpage = $pageno + 1;
                           // echo forward link for next page 
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>></a> ";
                           // echo forward link for lastpage
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>>></a> ";
                        } // end if
                        /******  end build pagination links ******/               
                        echo "</table>";
                     }      
                  mysql_free_result($result);    //release the result set from the table
                  mysql_close($conn);          //close the connection to the db
               ?>

MOD EDIT: [code] . . . [/code] tags added.

I have made a shopping cart where I can add items from my sql table. But I dont know how to send the table to my email. this is my cart.php

Can someone give me some tips? Thanks in advance.
you can also check it out on http://fhcs.be/cart-demo3/



<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Cart</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Back to bookshop...</a></p>


</div>

</body>
</html>