PHP - Creating A Table With An Edit Button On Each Row

Hi all.
I built an online finance tracking thingy for myself and I got it to work using the following database table and PHP code. I didn't write the PHP code, rather, I edited it to suit my needs.
It works great for my needs. I have a way to enter records and view the last 180 records in a table. The thing is, while viewing the table, I would lke to be able to edit and delete records. I don't know enough to be able to do this.
Can it be done? I realize my PHP code would probably, for the most part, be totally different.
Thanks for any help with this.

Here is my DB table structu
Code: [Select]
DROP TABLE IF EXISTS `money`;
CREATE TABLE IF NOT EXISTS `money` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`type` varchar(18) NOT NULL,
`checking` decimal(5,2) NOT NULL DEFAULT '0.00',
`cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`description` varchar(25) NOT NULL,
`who` varchar(25) NOT NULL,
`note` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
And here is the PHP:
Code: [Select]
<?php


$result = mysql_query ('SELECT date, type, checking, cash, who, description, note'
        . ' FROM money'
        . ' ORDER BY date DESC LIMIT 0,180')
or die(mysql_error());  

echo "<table border='1' cellpadding='5'>";


echo "<tr><th>Date</th><th>Type</th><th>Checking</th><th>Cash</th><th>Who?</th><th>Description</th><th>Note</th></tr>";

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['date'];
echo "</td><td>";
        echo $row['type'];
echo "</td><td>";  
echo $row['checking'];
echo "</td><td>"; 
        echo $row['cash'];
echo "</td><td>"; 
echo $row['who'];
echo "</td><td>"; 
        echo $row['description'];
        echo "</td><td>"; 
        echo $row['note'];
echo "</td></tr>";
} 

echo "</table>";
?>

This topic has been moved to Other Libraries and Frameworks.

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

This topic has been moved to Miscellaneous.

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

hello all, i am trying to edit a mysql table from the browser using these codes:

edit.php:

      include"db.inc.php";//database connection

      $order = "SELECT * FROM prices";

      $result = mysql_query($order);

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

        echo ("<tr><td>$row[id_number]</td>");

        echo ("<td>$row[product]</td>");

        echo ("<td>$row[price]</td>");

        echo ("<td><a href=\"edit_form.php?id=$row[id_number]\">Edit</a></td></tr>");

      }

edit_form.php

      <table>

      <?

      include "db.inc.php";//database connection

      $order = "SELECT * FROM prices where id_number='$id'";

      $result = mysql_query($order);

      $row = mysql_fetch_array($result);

      ?>

      <form method="post" action="edit_data.php">

      <input type="hidden" name="id" value="<? echo "$row[id_number]"?>">

        <tr>       

          <td>Product</td>

          <td>

            <input type="text" name="product"

        size="20" value="<? echo "$row[product]"?>">

          </td>

        </tr>

        <tr>

          <td>Price</td>

          <td>

            <input type="text" name="price" size="40"

          value="<? echo "$row[price]"?>">

          </td>

        </tr>

        <tr>

          <td align="right">

            <input type="submit"

          name="submit value" value="Edit">

          </td>

        </tr>

      </form>

      </table>

edit_data.php

include "db.inc.php";

$order = "UPDATE prices SET product='$_POST[product]', price='$_POST[price]' WHERE id_number='$id'";

mysql_query($order);

header("location:edit.php");

the table:
CREATE TABLE IF NOT EXISTS `prices` (
  `id_number` int(3) NOT NULL,
  `product` varchar(30) DEFAULT NULL,
  `price` int(6) DEFAULT NULL,
  PRIMARY KEY (`id_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

the data is displayed correctly but i can't change the data...

Friends
  I am new to php and i have to submit my coursework in php by 3rd dec, I stuck at one place where i have to upload multiple photo and one can see all the photo he has uploaded and can edit or delete that photo so i have done uploading now i am showing those pics in table by running loop and generating tr and td but now i have two buttons with each row edit and delete now when i clicked on one delete or edit that pic should be delete or give text box to edit description of pic, Please help me how to do that.......

I am working on a website for my landscape architecture master's thesis centered around the Google Earth API.  Through out the site I have various test questions that I pass along as hidden fields from page to page to be entered into my database at the end.  My problem is:  I am trying to create a button that refreshes my Google earth div container ("APEarth") without refreshing the whole page.  Currently, the button refreshes the whole page creating null entries for all the previous test questions.  Any help would be greatly appreciated.  My code is below.  Just as a side note, my skills are very limited, so specific coding help would be greatly appreciated.

<?php /*?>The items below are all the AP Elements in the Design View that make up the website <?php */?>
  <style type="text/css">
  <!--
  #APBody {
      position:absolute;
      left:0px;
      top:0px;
      width:1000px;
      height:700px;
      z-index:1;
      margin-top: 12pt;
      margin-left: 12pt;
  }
  #APUpperTitleBlock {
      position:absolute;
      left:0px;
      top:0px;
      width:1000px;
      height:50px;
      z-index:2;
  }
  #APBottomTitleBlock {
   position:absolute;
   left:0px;
   width:1000px;
   height:50px;
   z-index:6;
   bottom: 0px;
  }


#APEarth {
   position:absolute;
   top:73px;
   width:800px;
   height:577px;
   z-index:4;
   right: 0px;
   border-color: #000;
   border-width: 2 px;
}

#ApContinue {
   position:absolute;
   left:0px;
   top:51px;
   width:1000px;
   height:18px;
   z-index:8;
   text-align: right;
}
#APLayers {
   position:absolute;
   left:0px;
   top:73px;
   width:200px;
   height:576px;
   z-index:9;
   font-family: Arial, "Arial Bold", "Arial Bold Italic", "Arial Black", "Arial Italic";
   font-size: 14px;
   font-weight: bold;
}

  -->
  </style>
<title>Scenario Three</title>
<style type="text/css">
<!--
#APBody #APLayers p {
   font-weight: normal;
   font-family: Arial, "Arial Bold", "Arial Bold Italic", "Arial Black", "Arial Italic";
}
#GoogleEarthReset {
   position:absolute;
   left:4px;
   top:4px;
   width:192px;
   height:13px;
   z-index:1;
}


-->
</style>
<script type="text/javascript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<div id="APBody">
  <div id="APUpperTitleBlock"><img src="Images/ScenarioThree_UTitleBlock.jpg" width="1000" height="50"></div>
  <div id="APBottomTitleBlock"><img src="Images/Website_LTitleBlock.jpg" width="1000" height="50"></div>
    <div id="ApContinue">
      <form method="post" action="ScenarioThreeTest.php">
     <?php /*?>Begin hidden pretest answers<?php */?>
        <input type="hidden" name="UniqueID" value="<?php echo $_POST['UniqueID']; ?>" />
        <input type="hidden" name="GroupID" value="<?php echo $_POST['GroupID']; ?>" />
        <input type="hidden" name="1_Age" value="<?php echo $_POST['1_Age']; ?>" />
        <input type="hidden" name="2_Race" value="<?php echo $_POST['2_Race']; ?>" />
        <input type="hidden" name="3_Education" value="<?php echo $_POST['3_Education']; ?>" />
        <input type="hidden" name="4_Occupation" value="<?php echo $_POST['4_Occupation']; ?>" />
        <input type="hidden" name="5_Income" value="<?php echo $_POST['5_Income']; ?>" />
        <input type="hidden" name="6_SWM_Is" value="<?php echo $_POST['6_SWM_Is']; ?>" />
        <input type="hidden" name="7_Landuse" value="<?php echo $_POST['7_Landuse']; ?>" />
        <input type="hidden" name="8_Location" value="<?php echo $_POST['8_Location']; ?>" />
        <input type="hidden" name="9_Participation" value="<?php echo $_POST['9_Participation']; ?>" />
        <input type="hidden" name="10_Comments_Blog_Etc" value="<?php echo $_POST['10_Comments_Blog_Etc']; ?>" />
        <input type="hidden" name="11_Web" value="<?php echo $_POST['11_Web']; ?>" />
      <?php /*?>Begin hidden Scearnio One Test answers<?php */?>
        <input type="hidden" name="12_Scenario_One" value="<?php echo $_POST['12_Scenario_One']; ?>" />
        <input type="hidden" name="13_Sustainable" value="<?php echo $_POST['13_Sustainable']; ?>" />
        <input type="hidden" name="14_Effectiveness" value="<?php echo $_POST['14_Effectiveness']; ?>" />
        <input type="hidden" name="15_Use_Techniques" value="<?php echo $_POST['15_Use_Techniques']; ?>" />
        <input type="hidden" name="16_Willing_Scenario_One" value="<?php echo $_POST['16_Willing_Scenario_One']; ?>" />
        <input type="hidden" name="17_Comments_Scenario_One" value="<?php echo $_POST['17_Comments_Scenario_One']; ?>" />
      <?php /*?>Begin hidden Scenario Two Test answers<?php */?>
         <input type="hidden" name="18_Scenario_Two" value="<?php echo $_POST['18_Scenario_Two']; ?>">
        <input type="hidden" name="19_Sustainable" value="<?php echo $_POST['19_Sustainable']; ?>">
        <input type="hidden" name="20_Effectiveness" value="<?php echo $_POST['20_Effectiveness']; ?>">
        <input type="hidden" name="21_Use_Techniques" value="<?php echo $_POST['21_Use_Techniques']; ?>">
        <input type="hidden" name="22_Willing_Scenario_Two" value="<?php echo $_POST['22_Willing_Scenario_Two']; ?>">
        <input type="hidden" name="23_Comments_Scenario_Two" value="<?php echo $_POST['23_Comments_Scenario_Two']; ?>">
      <?php /*?>Continue to Scenario Three Button<?php */?>
      <input type="submit" value="Continue to Scenario Three Test" />
    </form>   
   
   
  </div>
  <div id="APLayers">
    <form id="form1" name="form1" method="post" action="">
      <p>
        <input type="submit" name="Refresh View" id="Refresh View" value="Refresh View" />
        <br />
        <br />
        <a href="GEHelpVideo.html" target="_blank">Google Earth Help Video</a><a href="GEHelpVideo.html"></a></p>
    </form>
    <p><strong>Introduction: </strong></p>
<p><em>Problem and/or Opportunity Identification:</em></p>
    <p>The Big Hollow drainage-way provides a unique opportunity for dense development. Its proximity to the urban core of State College and The Pennsylvania State University allows for continuity of development and alternative transportation. It also contains the necessary infrastructure to accomodate new development. </p>
    <p><em>Goal Establishment:<br />
    </em><br />
    1. Expand and enhance the availability of different housing types and<br />
    <br />
    2. Expand and enhance urban district growth with new commercial and industrial development.</p>
  </div>
  <div id="APEarth"></div>
</div>

<?php /*?>End Design View Elements<?php */?>



<?php /*?>The following is the codefor Google Earth on GoDaddy.com<?php */?>
<script src="http://www.google.com/jsapi?key=ABQIAAAAASFuJKi2srzH7vU9dQ775BSMepAERdnJfYrR64vZA9ytMBD-kBTzNLiWgdo_rLSrLhNdv2e5GaHvjg"> </script>
      <script type="text/javascript">
     //Google Earth HTML 
     var ge;
      google.load("earth", "1");
     
          function init() {
              google.earth.createInstance('APEarth', initCB, failureCB);
              }
        
          function initCB(instance) {
              ge = instance;
              ge.getWindow().setVisibility(true);
        
     
              // add a navigation control
              ge.getNavigationControl().setVisibility(ge.VISIBILITY_AUTO);
     
              // add an overview map
              ge.getOptions().setOverviewMapVisibility(true);
         
              //add the status bar
              ge.getOptions().setStatusBarVisibility(true);
     
              //add the scale legend
              ge.getOptions().setScaleLegendVisibility(true);
           ge.getOptions().setUnitsFeetMiles(true);
           
              // add some standsard google earth layers
              ge.getLayerRoot().enableLayerById(ge.LAYER_BORDERS, true);
              ge.getLayerRoot().enableLayerById(ge.LAYER_ROADS, true);
                                 
       
          //add Big Hollow Well data KML File
          var href1 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Scenario3Wells.kml';
            google.earth.fetchKml(ge, href1, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
                           
         //add Big Hollow existing zoning KML File
          var href3 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Scenario3ExLanduse.kml';
            google.earth.fetchKml(ge, href3, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
            
         //add Big Hollow proposed zoning KML File
          var href4 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Scenario3PropLanduse.kml';
            google.earth.fetchKml(ge, href4, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
   
         //add Big Hollow Video Placemark KmL File
   //       var href5 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Landuse_Conflict_Video.kml';
//            google.earth.fetchKml(ge, href5, function(kmlObject) {
//            if (kmlObject)
//            ge.getFeatures().appendChild(kmlObject);});   
            
            
         //add Big Hollow Existing Buildings KML File
          var href6 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Scenario3ExBuildings.kml';
            google.earth.fetchKml(ge, href6, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
            
         //add Big Hollow Proposed Buildings KML File
          var href7 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Scenario3PropBuildings.kml';
            google.earth.fetchKml(ge, href7, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
            
         //add Big Hollow Potential Sinkhole KML File
          var href8 = 'http://www.iecoplanningstudio.com/Google_Earth_Files/Potential_Sinkhole.kml';
            google.earth.fetchKml(ge, href8, function(kmlObject) {
            if (kmlObject)
            ge.getFeatures().appendChild(kmlObject);});
            
                                    ///--------------------------------------------------------------------------------------------------------
                                    //Test Placemark
                                    var placemark = ge.createPlacemark('');
                                    
                                    // Define a custom icon.
                                    var icon = ge.createIcon('');
                                    icon.setHref('http://maps.google.com/mapfiles/kml/shapes/movies.png');
                                    var style = ge.createStyle(''); //create a new style
                                    style.getIconStyle().setIcon(icon); //apply the icon to the style
                                    placemark.setStyleSelector(style); //apply the style to the placemark
                                    
                                    // Set the placemark's location. 
                                    var point = ge.createPoint('');
                                    point.setLatitude( 40.800827);
                                    point.setLongitude(-77.881896);
                                    placemark.setGeometry(point);
                                    
                                    // Add the placemark to Earth.
                                    ge.getFeatures().appendChild(placemark);
                                    
                                    placemark.setName('Land Use Video!');
                                    
                                    google.earth.addEventListener(placemark, 'click', function(event) {
                                    // prevent the default balloon from popping up
                                    event.preventDefault();
                                    
                                    var balloon = ge.createHtmlStringBalloon('');
                                    balloon.setFeature(placemark); // optional
                                    balloon.setMaxWidth(400);
                                    
                                    // YouTube video embed... the   in the beginning is a fix for IE6
                                    balloon.setContentString(
                                       ' <object width="400" height="300"><param name="movie" '
                                       + 'value="http://www.youtube.com/v/6mrG_bsqC6k&hl=en&fs=1"/>'
                                       + '<param name="allowFullScreen" value="true"/>'
                                       + '<embed src="http://www.youtube.com/v/oN3TNoRudfE?hl=en&fs=1" '
                                       + 'type="application/x-shockwave-flash" allowfullscreen="true" '
                                       + 'width="400" height="300"></embed></object>');
                                    
                                    ge.setBalloon(balloon);
                                     });
                                    ///--------------------------------------------------------------------------------------------------------
   
                 
              //Get the Current View
              var lookAt = ge.getView().copyAsLookAt(ge.ALTITUDE_RELATIVE_TO_GROUND);
     
              //Set New Latitude and Longitude
              lookAt.setLatitude(40.794709);
              lookAt.setLongitude(-77.887323);
              lookAt.setRange(10000);
           // Add  to the current tilt
           lookAt.setTilt(lookAt.getTilt() + 60);
   
              //Update View
              ge.getView().setAbstractView(lookAt);       
           }
            
            
          function failureCB(errorCode) {
          }
       
    
         google.setOnLoadCallback(init);

     
      //End Google Earth Coding
   
</script>

Hi, I'm doing a simple e-mail using localhost, while doing the rest, I realized I need a delete button for it. Is there a simple way to delete the message when the user opens the mail content?

This is the code I did for read_pm.php:
Code: [Select]
<?php
include('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" />
        <title>Read a PM</title>
    <script type="text/javascript">
<!--
function FP_swapImg() {//v1.0
 var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
 n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
 elm.$src=elm.src; elm.src=args[n+1]; } }
}

function FP_preloadImgs() {//v1.0
 var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
 for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; }
}

function FP_getObjectByID(id,o) {//v1.0
 var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
 else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
 if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
 for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
 f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
 for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
 return null;
}
// -->
</script>
    <style type="text/css">
.auto-style2 {
font-family: "Gill Sans", "Gill Sans MT", Calibri, "Trebuchet MS", sans-serif;
text-align: left;
}
.auto-style4 {
color: #FFFFFF;
}
.auto-style1 {
font-family: "Gill Sans", "Gill Sans MT", Calibri, "Trebuchet MS", sans-serif;
}
</style>
    </head>
    <body onload="FP_preloadImgs(/*url*/'default/images/buttonD5.jpg',/*url*/'default/images/buttonD6.jpg',/*url*/'default/images/button51.jpg',/*url*/'default/images/button52.jpg')">
    <div class="header">
        <a href="<?php echo $url_home; ?>"><img src="<?php echo $design; ?>/images/logo.png" alt="Members Area" /></a>
    </div>
       
       
<?php
//We check if the user is logged
if(isset($_SESSION['email']))
{
//We check if the ID of the discussion is defined
if(isset($_GET['id']))
{
$id = intval($_GET['id']);
//We get the title and the narators of the discussion
$req1 = mysql_query('select title, user1, user2 from pm where id="'.$id.'" and id2="1"');
$dn1 = mysql_fetch_array($req1);
//We check if the discussion exists
if(mysql_num_rows($req1)==1)
{
//We check if the user have the right to read this discussion
if($dn1['user1']==$_SESSION['userid'] or $dn1['user2']==$_SESSION['userid'])
{
//The discussion will be placed in read messages
if($dn1['user1']==$_SESSION['userid'])
{
mysql_query('update pm set user1read="yes" where id="'.$id.'" and id2="1"');
$user_partic = 2;
}
else
{
mysql_query('update pm set user2read="yes" where id="'.$id.'" and id2="1"');
$user_partic = 1;
}
//We get the list of the messages
$req2 = mysql_query('select pm.timestamp, pm.message, users.id as userid, users.username from pm, users where pm.id="'.$id.'" and users.id=pm.user1 order by pm.id2');
//We check if the form has been sent
if(isset($_POST['message']) and $_POST['message']!='')
{
$message = $_POST['message'];
//We remove slashes depending on the configuration
if(get_magic_quotes_gpc())
{
$message = stripslashes($message);
}
//We protect the variables
$message = mysql_real_escape_string(nl2br(htmlentities($message, ENT_QUOTES, 'UTF-8')));
//We send the message and we change the status of the discussion to unread for the recipient
if(mysql_query('insert into pm (id, id2, title, user1, user2, message, timestamp, user1read, user2read)values("'.$id.'", "'.(intval(mysql_num_rows($req2))+1).'", "", "'.$_SESSION['userid'].'", "", "'.$message.'", "'.time().'", "", "")') and mysql_query('update pm set user'.$user_partic.'read="yes" where id="'.$id.'" and id2="1"'))
{
?>
<div class="message"><strong><span class="auto-style4">Your message has successfully been sent.</span></strong><br />
<a href="read_pm.php?id=<?php echo $id; ?>">Back to Message</a></div>
<?php
}
else
{
?>
<div class="message"><strong><span class="auto-style4">An error occurred while sending the message.</span></strong><br />
<a href="read_pm.php?id=<?php echo $id; ?>">Back to Message</a></div>
<?php
}
}
else
{
//We display the messages
?>
<div class="content">

<table class="messages_table">
<tr>
        <th class="auto-style2" style="height: 27px; width: 64px">Subject : <?php echo $dn1['title']; ?></th>
    </tr>
<?php
while($dn2 = mysql_fetch_array($req2))
{
?>
<tr>
    <td class="auto-style2" style="height: 50px; width: 64px">
<div class="auto-style2">Sent by: <a href="profile.php?id=<?php echo $dn2['userid']; ?>"><?php echo $dn2['username']; ?>
on <?php echo date('d/m/Y, g:i a' ,$dn2['timestamp']); ?></div>
    <br>
   
   
   
    <?php echo $dn2['message']; ?></a><br></td>
    </tr>
<?php
}
//We display the reply form
?>
</table>
<br />
<div class="center">
    <form action="read_pm.php?id=<?php echo $id; ?>" method="post">
    &nbsp;
<img id="img7" alt="Reply" fp-style="fp-btn: Braided Row 1; fp-font-style: Bold" fp-title="Reply" height="24" src="default/images/button53.jpg" style="border: 0" width="120" class="auto-style1" onmousedown="FP_swapImg(1,0,/*id*/'img7',/*url*/'default/images/button52.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img7',/*url*/'default/images/button53.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img7',/*url*/'default/images/button51.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img7',/*url*/'default/images/button51.jpg')"><br>&nbsp;<textarea rows="5" name="message" id="message" style="width: 311px"></textarea><br><br />
        <input type="submit" value="Send" />&nbsp;&nbsp;&nbsp;&nbsp;
    </form>
</div>
</div>
<?php
}
}
else
{
echo '<div class="message">You do not have the rights to access this page.</div>';
}
}
else
{
echo '<div class="message">This private message does not exists.</div>';
}
}
else
{
echo '<div class="message">The private message ID is not defined.</div>';
}
}
else
{
echo '<div class="message">You must be logged to access this page. Please register.</div>';
}
?>
<div class="foot"><a href="list_pm.php">
<img id="img1" alt="Back to Inbox" fp-style="fp-btn: Braided Row 3; fp-font-style: Bold" fp-title="Back to Inbox" height="24" onmousedown="FP_swapImg(1,0,/*id*/'img1',/*url*/'default/images/buttonD6.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img1',/*url*/'default/images/buttonD4.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img1',/*url*/'default/images/buttonD5.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img1',/*url*/'default/images/buttonD5.jpg')" src="default/images/buttonD4.jpg" style="border: 0" width="120"></a></div>
</body>
</html>

I have a string (Product1-Product2-Product3#2-4-1) where Product1-Product2-Product3 are products and 2-4-1 are quantities. I am struggling to make a table out of it where products and quantities are shown in rows.

here is what i tried.

Code: [Select]
list($products, $quantities) = explode("#", $specs); //to separate Quantities from products

<?php foreach(preg_split("/-/", $products) as $product_list) { ?>
 
  <tr>
    <td> <?php echo $product_list; ?></td><? } ?> <?php foreach(preg_split("/-/", $quantities) as $qtylist) { ?>   <td></td>
    <td><?php echo $qtylist; ?></td> <?php } ?>
  </tr>

  <?php //} ?>
</table>
 
I know something is wrong with this and its giving me unexpected reasult

Please help me create a table out of the above string.

Many Thanks
-Max

Hi guys, i cannot figure out what is wrong with this and I hope you could help figure it out?

This is the code I am using -
Code: [Select]


$create_cart_table = "CREATE TABLE `". $string ."` (cart_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY(cart_id), item_name VARCHAR(1000) NOT NULL, item_id VARCHAR(30) NOT NULL, price VARCHAR(30) NOT NULL, date_time TIMESTAMP(100) NOT NULL CURRENT_TIMESTAMP, quantity VARCHAR(100) NOT NULL)";
$set_cart_table = mysql_query($create_cart_table);


$string is defined above and there are no database connection warnings etc coming up and I am lost as to how the heck this isn't working? It was working for about an hour when I first made the script but now it is not. Please help?

What I want to do is create a table out of records from a table that shows an image and a radio button under the image (so I would imagine it would be in 2 rows). I want it to have 3 columns across. Here's what I have to get and output the results:
    $fabricsql = "SELECT * FROM Fabric f, Images i WHERE f.SKU = i.SKU";
        //echo $fabricsql;
        $fabricResult = mysql_query($fabricsql);
        $i=0;
        while($fabricAssoc = mysql_fetch_assoc($fabricResult)){
            //echo $fabricAssoc['SKU']. "+ ".$fabricAssoc['Name'];
            echo "<a href=\"\"><img src='../../".$fabricAssoc['ThumbPath']."' alt='".$fabricAssoc['Description']."' width='".$fabricAssoc['ThumbWidth']."' /></a><br />
             <input type=\"radio\" name=\"fabricSelect\" value='".$fabricAssoc['SKU']."' id=\"RadioGroup1_".$i."\" /><br /><br />";    
             $i++;
        }
        

Any help is much appreciated. I'm not even sure this is the best way to go about this so any suggestions are appreciated.

Hi there, trying to create a function more out of lazyness an timesaving than anything
im sure it has to do with something combining the use of INSERT and x++ in an array, but im failing at figuring out the right way of doing it to achieve the right combination of effects.

in simple

need to create a 600x600 grid of co-ordinates where x starts at 1, ending in 600 with y starting at 1 and ending in 600

so basically a cubed set of entrys, (360,000 rows) not even sure thats possible lol..

the table only needs to contain the colums of id, x , y , ownerid (where id is auto inc)

any suggestions, as you can tell its a pain-staking long case of affairs to create with a manual VERY long sql statement, trying to figure out a better way of doing this.
help please?

Thanks

It's about making a form for a web page.
Which is better?
Using table or divs?

Which do you use?


<form action='a.php' method='post'>
<table>
.............
</table>
</form>

<form action='a.php' method='post'>
<div>
.............
</div>
</form>

HI. Im new to database. I didnt know how to use bridge table. In my bridge table i have SubjectID and studentID, PK from student table and subject table. In my subject table have SubjectID, SubjectName and SubjectLecturer while in my student table have studentID,,studentName,IC,studentFac,studentPhone, studentEmail,pswd,studentAddress. I didnt know where is the wrong part because when i click my form which is enroll button, this enroll page blank Can someone check my coding ? Help ?               <!DOCTYPE HTML> <html> <head> <?php
error_reporting(0);
session_start();
if (!isset($_SESSION['studentID']))
{
$_SESSION['studentID'] = $_POST['studentID'];
$_SESSION['pswd'] = $_POST['pswd'];
}

include("connect.php");
$sql = "SELECT * FROM student WHERE 
studentID='".$_SESSION['studentID']."' AND 
pswd='".$_SESSION['pswd']."'";

$result = mysql_query($sql);
$row = mysql_num_rows($result);
if ($row == 0)
{
echo "Login fail Try again <a href='http://bytes.com/'>here</a>";
?> <meta http-equiv="refresh" content="0;userlogin.php" /> <?php
}
else
{
$row = mysql_fetch_assoc($result);
}
?> <meta charset="UTF-8"> <title>E-Education portal</title> <link href="http://bytes.com/style.css" rel="stylesheet" type="text/css"> </head> <body> <div id="header"></ div> <?php

if(isset($_POST["submit"]))
{
session_start();
include("connect.php");

$SubjectID = $_POST['SubjectID'];
$SubjectName = $_POST['SubjectName'];
$SubjectLecturer = $_POST['SubjectLecturer'];


$Subject= "SELECT SubjectID
FROM Subject
WHERE SubjectID='$SubjectID'";

$queryssubject=mysql_query($subject) or die(mysql_error);
$record=mysql_num_rows($querysubject);

if($record==1)
{
header ('Location: studentSubject.php');
}
else if($record<1)
{
if(substr($subjectID))
{

$insertIntoSubject= "INSERT INTO Subject ('SubjectID', 'SubjectName', 'SubjectLecturer') VALUES ('$SubjectID','$SubjectName','$SubjectLecturer')";

$result1=mysql_query($insertIntoSubject) or die(mysql_error());

$insertIntobridge="INSERT INTO `bridge`(`SubjectID`, `studentID`)
VALUES ('$SubjectID', '$studentID')";
$result2=mysql_query($insertIntobridge)or die(mysql_error());

$insertIntostudent="INSERT INTO student (`studentID`, `studentName`, `IC`, `studentFac`, `studentPhone`, `studentEmail`, `pswd`, `studentAddress')
VALUES ('$studentID', '$studentName', '$IC', '$studentFac', '$studentPhone', '$studentEmail', 'abc123', '$studentAddress')";

$result3=mysql_query($insertIntostudent)or die(mysql_error());



if ($result1 && $result2 && $result3)
{
header ('Location: studentSubject.php');
}
}
else echo 'insert error';
}

else
{
echo "<script type='text/javascript'>
alert('Data Updated!')
location.href='homestudent.php'
</script>";

}
mysql_close($conn);
}
?>

Hello,    I have this very frustrating problem 

I'm trying to make a dynamic table with only 5 columns per row. So every 5 items, I need a new row.   I have tried many different examples with no success. What is the best way to approach this?   Here is what I am working with, this doesn't show what I have tried, just what I am working with at the moment which of course, just outputs it one column per row. http://www.mesquitew.../inc-legend.php

// Lets parse the data
$entries = simplexml_load_file($data);
if(count($entries)):
    //Registering NameSpace
    $entries->registerXPathNamespace('prefix', 'http://www.w3.org/2005/Atom');
    $result = $entries->xpath("//prefix:entry");

    foreach ($result as $entry):
        $event = $entry->children("cap", true)->event;

// Set the alert colors for the legend
include ('../inc-NWR-alert-colors.php');

// Lets creat some styles for the list
$spanStyle = "background-color:{$alertColor};border:solid 1px #333;width:15px;height:10px;display:inline-block;'> </span><span style='font-size:12px;color:#555;";

 $legend .= "<table>";
 $legend .= "<tr>";
 $legend .= "<td> <span style='$spanStyle'> $event</span></td>";
 $legend .= "</tr>";
 $legend .= "</table>";

         endforeach;
endif;

echo $legend;

-Thanks!

Can someone five me the correct code or format to use that will allow my TINYINT columns to carry TWO decimal places when creating my table?  I have a script for creating the table and columns, but only recently learned that I need to ADD the TWO decimal place FUNCTION in order to get whole dollar values to display WITH the trailing zeros (ie.:2.00).  I don't expect to need any values greater than xxx.xx in my columns, I'm just not clear on how to get the desired script when running the initial CREAT script.

Thanks