PHP - Updating Data In Two Tables At Once

I am working on a php project in which players can equipt items from there inventory and it shows them there current stats. When players have decided to equipt an item they hit the submit button and the new stats should show. The issue I have is that the data is delaying in update such as:

we have 10 strength
we equipt a sword with +2 to strength and click submit
it displays we have 10 strength
we equipt a axe with +3 to strength and click submit
it displays 12 strength
we equipt a sword with +2 to strength and click submit
it displays 13 strength
we equipt a sword with +2 to strength and click submit
it displays 12 strength
....

my code is represented below

<?php
updateEquiptment();
require("playerInfo.php");
?>
<p title="This stat increases how hard you hit with weapons!">Strength:<?php echo $baseStrength +  getModStrength() ?> </p>

the functions updateEquiptment and getModStrength are in the playerInfo.php file and are shown like this:


$user = $_SESSION['username'];
$result = mysql_fetch_row(mysql_query("SELECT equiptment FROM warUsers WHERE name = '$user'"));
$equiptment = explode(",",$result[0]);
function updateEquiptment()
{
global $user;
$result  = mysql_fetch_row(mysql_query("SELECT equiptment FROM warUsers WHERE name = '$user'")) or die(mysql_error());
global $equiptment;
$equiptment = explode(",",$result[0]);
}

//get there modified stats
function getModStrength()
{
$total = 0;
global $equiptment;
foreach ($equiptment as $value) //loop through every item in the equiptment
{
if($value == 0 || $value == null) //if nothing is equipt go to the next loop
continue;

$result = mysql_query("SELECT * FROM items WHERE id = '$value'");
$item = mysql_fetch_row($result);
$total += $item[4]; //get the items strength and add it to the total
}
return $total;
}

any help on the matter would be greatly appreciated

Hi,

I want to loop out data from DB in <input> and change and update several posts at the same time.
Can you give me a short example, how <input> and maybe foreach could look like?

Thanks

hi,

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Sahansevena_ver1\admin\profile\updAdmiInfo.php on line 49

i got this error.

here is the coding
Code: [Select]
<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
$dbuser="root";
    $dbpswd="****";
    $dbserver="localhost";


$nwuser=$_POST['username'];
$c_pw=$_POST['cur_password'];
$n_pw=$_POST['conf_password'];
//$user=$userName;
//$pass=$password;
//

$dbname="sahansevena";


if($_SERVER['REQUEST_METHOD']=='POST'){

    //get username and password from admin login.php

$con=mysql_connect($dbserver,$dbuser,$dbpswd);


    if(!$con){
        die('coudnt connect db connection prob'.mysql_error());
    }else{
        if($c_pw==$n_pw){

            $uname=mysql_real_escape_string($username);
            $pword=mysql_real_escape_string($n_pw);
           // setDatabase($dbname, $con) ;
           mysql_select_db($dbname, $con);
            //  $result="update admin set username='$uname',password='$pword'" where limit 0;
            $result="update admin set username='$uname' , password='$pword', last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname' limit 0";



            //Checked to see if any rows were returned from the database
            // If rows were returned, set a session variable to 1
            $result=mysql_query($result);



            if ($result) {
                $numRow=mysql_numrows($result);
                if($numRow>0){
                    //session_start();

                   //SESSION['admin']="menuka";

echo "data was suaccesfully updated";
                   /// header ("Location:config/menu.php");

                    //mysql_close($con);
                }else{
                    //session_start();
echo " problem in updating ";
                    //$_SESSION['login'] = "";
                    //header ("Location:login.php");

                }




            }
            else {
                trigger_error(mysql_error(), E_USER_ERROR);
            }




        }

    }

}else{
    echo 'error message not post methode';
    include(login.php);
}




?>




please check my code and help me to figur out the error
thanks in advance,
menukadevinda

Hello all,

I have form that has several fields.  Each field will be saved to a table (which is a relations table we will call markups).  The form is built from another table which is an array of categories.  The output will build a form with each category and allow the end-user to input data for each category.  The information the user will be entering is markup values. 

Cat1 | Markup Input
Cat2 | Markup Input
Cat3 | Markup Input

I'll be saving the data in their own columns and not as an serialized array to the database.  I'm currently looping through the arrayed fields and saving the data to the markup relations table.  I've read other forums and serializing the data will be to difficult to retrieve for relationship purposes??  Anyway, here's my question:

Let's say the user is entering the markups for the first time.  They go down the list of categories and add their markups for each and click save.  Cool, no problem just do an INSERT INTO. Then, they go into the category setup screen and add a category then go back to the markup screen and now have to update the category markup that was just added. 

So now I have to do an UPDATE to the current listed markups table (no problem). But now I have to add another row in the same table from that array.  Is there a logical way of handling this.  I guess I'm looking for some ideas on how to accomplish this task.  I hope you guy understand what I'm after here.  Thanks for any suggestions on this.

 

Hello folks,
I can not seem to find out why this code is not being executed properly. Basically, I'd like to edit Records, so I am using forms to retrieve data, make modifications then save them.

Code: [Select]
<?php
//connection to db
 
$results = mysql_query("SELECT * FROM crud WHERE id=".$_GET[id]."") or die (mysql_error());
$row = mysql_fetch_assoc($results);
echo "<form action=\"\" method=\"POST\">";
echo "Year: <input type=\"text\" value=".$row['car_year']." name=\"car_year\" /> <br />";
echo "Make: <input type=\"text\" value=".$row['car_make']." name=\"car_make\" /> <br />";
echo "Model: <input type=\"text\" value=".$row['car_model']." name=\"car_model\" /><br /><br />";
echo "Description:<br /><textarea rows=\"15\" cols=\"60\" name=\"description\" />". $row['description']. "</textarea>";
echo "<br /><input type=\"submit\" value=\"save\">";
echo "</form>";

if ($_POST['save']) {
    $car_year = $_POST['car_year'];
    $car_make = $_POST['car_make'];
    $car_model = $_POST['car_model'];
    $description = $_POST['description'];

// Update data
    $update = mysql_query("UPDATE crud SET car_year='$car_year', car_make='$car_make' car_model='$car_model', description='$description' WHERE id=".$_GET['id']."") or die (mysql_error());
echo 'Update successfull';
}

?>


Please HELP!!!!

Hey guys,

I got another one that i could use some help on.  I have a input form that utilizes a javascript that adds additional rows to my table.  here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
    var x = document.getElementById('results_table').insertRow(-1);
    var a = x.insertCell(0);
    var b = x.insertCell(1);
    var c = x.insertCell(2);
    var d = x.insertCell(3);
    var e = x.insertCell(4);

    a.innerHTML="<input type=\"text\" name=\"id\">";
    b.innerHTML="<input type=\"text\" name=\"place\">";
    c.innerHTML="<input type=\"text\" name=\"username\">";
    d.innerHTML="<input type=\"text\" name=\"earnings\">";
    e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
    var i=r.parentNode.parentNode.rowIndex;
    document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page.  basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

            <th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

            <tr>
                <td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
            </tr>

        </table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database.  is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)


now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID. 

so when it comes to processing I need to do a switch of these two things before I run my query.  Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);



also i've never tried to submit multiple entries at a time.  maybe i have to create an array somehow in order to capture each rows data.  any thoughts?

as always thanks for the help.

I used to be good at this but I changed servers and everything is different...  Heres my code so far:

Code: [Select]
<?php
$rated=$_REQUEST['rated'];
echo $rated;
$rating=$_REQUEST['rating'];
echo $rating;

// Make a MySQL Connection
mysql_connect("localhost", "********", "********") or die(mysql_error());
mysql_select_db("*********") or die(mysql_error());

$result = mysql_query("SELECT * FROM main WHERE username = '$rated'")
or die(mysql_error());  

$row = mysql_fetch_array( $result );

$votes = $db_field['$rating'];
$newvotes = $votes + 1;

echo $newvotes;

mysql_query("UPDATE main SET $rating = '$newvotes'
WHERE username = '$rated'");


?>
Whats going on here is the colomb that I want to update comes as a variable $rated (That works) and then the database selects the  row to update with $username (That works) and gets the variable $newvotes by taking the original value of the data its about to update and add 1 to it (That works)  Then it updates the field to $newvotes....

I don't know why the update won't go through... there are no errors....

Hi I making some forms that write to mysql database, Im now in the process of making the update form so the user can update there details on the form, I want it to populate the form with existing data but its not doing it at all. Thanks in advance Attached Files  delete.php   210bytes   2 downloads  modify.php   4.03KB   4 downloads  index.php   473bytes   3 downloads

Hello:

I have a DB table with this structu
Code: [Select]
CREATE TABLE `gallery_category` (
  `category_id` bigint(20) unsigned NOT NULL auto_increment,
  `category_name` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

What I am trying to do id pull this data into my "Edit Product" page and populate a SELECT menu with it.

I want the user to be able to re-assign a product to a new category if they chose to do so.

I want to add the data (and update the DB) to this area:
Code: [Select]
         <div style="float: left; width: 550px;">
          <select name='category_name'>
<option></option>
</select>

         </div>

This is the full page code that allows users to update product info:
Code: [Select]
<?php

include('../include/myConn.php');
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');
include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

$photo_id = $_REQUEST['photo_id'];

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$photo_title = mysql_real_escape_string($_POST['photo_title']);
$photo_price = mysql_real_escape_string($_POST['photo_price']);
$photo_caption = mysql_real_escape_string($_POST['photo_caption']);


$sql = "

UPDATE gallery_photos
   SET
      photo_title = '$photo_title',
      photo_price = '$photo_price',
      photo_caption = '$photo_caption'
  WHERE photo_id = $photo_id
  ";
  
mysql_query($sql) && mysql_affected_rows()

?>
<?php
}

$query=mysql_query("SELECT photo_title,photo_price,photo_caption FROM gallery_photos") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_title=$result['photo_title'];
  $photo_price=$result['photo_price'];
  $photo_caption=$result['photo_caption'];
}
?>

<!DOCTYPE HTML>

<html>
<head>

</head>

<body>

<div id="siteContainer">

<p>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
echo "<span class=\"textError\">". $photo_title ." successfully updated!</span>"
?>
</p>

<p>

         <form method="post" action="<?php echo $PHP_SELF;?>">
         <input type="hidden" name="POSTBACK" value="EDIT">
         <input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />



         <div style="float: left; width: 120px; margin-right: 30px;">
          Category:
         </div>
         
         <div style="float: left; width: 550px;">
          <select name='category_name'>
<option></option>
</select>

         </div>





         
         <div style="float: left; width: 120px; margin-right: 30px;">
          Title:
         </div>
         
         <div style="float: left; width: 550px;">
          <input type="text" name="photo_title" size="45" maxlength="200" value="<?php echo $photo_title; ?>" />
         </div>
         
         <div style="clear: both;"><br /></div>
         
         <div style="float: left; width: 120px; margin-right: 30px;">
          Price:
         </div>
         
         <div style="float: left; width: 550px;">
          <input type="text" name="photo_price" size="45" maxlength="200" value="<?php echo $photo_price; ?>" />
         </div>
         
         <div style="clear: both;"><br /></div>
         

          Description:<br />
          <textarea cols="107" rows="1" name="photo_caption"><?php echo $photo_caption; ?></textarea>


         
         <div style="clear: both;"><br /></div>
         
         
           
         <br />
         
         <input type="submit" value="Submit" />
         
         </form>
         
</p>


</div>

</body>

</html>


How can I do this? I'm stumped ...

Thanks!

I need help here. I am creating a system where the user will be able to update the product stock by uploading the stock of the products according to the id that has been assigned to the product. 
this is how my products table in  looks like in mysql database

 

I tried the code below but all i could not update my data into my database. And there's not error shown on my code. I do not know what is wrong with my codes. Please help me.
below the code that i use for uploading the CSV file to the data of my product_stock. 

<?php 
include 'conn.php';
if(isset($_POST["add_stock"]))
{
 if($_FILES['product_file']['tmp_name'])
 {
  $filename = explode(".", $_FILES['product_file']['tmp_name']);
  if(end($filename) == "csv")
  {
   $handle = fopen($_FILES['product_file']['tmp_name'], "r");
   while($data = fgetcsv($handle))
   {
    $product_id = mysqli_real_escape_string($conn, $data[0]);
    $product_stock = mysqli_real_escape_string($conn, $data[1]);  
    $product_status = 1 ;
    $query = "UPDATE products SET `product_stock` = '$product_stock', `product_status` = '$product_status' WHERE id = '$product_id'";
    mysqli_query($conn, $query);
   }
   fclose($handle);
   header("location: upload-product.php?updation=1");
  }
  else
  {
   echo '<script>alert("An error occur while uploading product. Please try again.")
   window.location.href = "upload-product.php"</script>';
  }
 }
 else
 {
  echo '<script>alert("No file selected! ")
  window.location.href = "upload-product.php"</script>';
 }
}
if(isset($_GET["updation"]))
{
  echo '<script>alert("Product Stock Updated successfully!")</script>';
}
?>

 <div class="col-12">
            <div class="card card-user">
              <div class="card-header">
                <h5 class="card-title">Update Product Stock</h5>
                <div class="card-body">
                <div class="form-group">
				<label for="file">Update Products stock File (.csv file)</label>
                <a href="assets/templates/product-template.xlsx" title="Download Sample File (Fill In Information and Export As CSV File)" class="mx-2">
				<span class="iconify" data-icon="fa-solid:download" data-inline="false">
				</a>
                </div>
                <form class = "form" action="" method="post" name="uploadCsv" enctype="multipart/form-data">
                <div>
                <input type="file" name="product_file" accept=".csv">
                <div class="row">
                <div class="update ml-auto mr-auto">
                <button type="submit" class="btn btn-primary btn-round" name="add_stock"> Import .cvs file</button>
                </div>
                </div>
                </div>
                </div>
                </form>
                </div>
              </div>

This is the template that i require user to key in and saved it in CSV format before uploading it. 

Hi guys,

This is my first time posting here - im just getting into PHP - i got a question;

I have two databases:

profile(id, name, interests, dob, gender, join_date, email)
interests(id, profile_id, interests)
id being the primary key, and profile_id being the foreign key from profile.

I want to script that returns profile information and all the matching interests (one user can have multiple interests).

This is what i have so far, though it does not work, and i knew it wouldnt;

function get_profile($id) {
   $connection = mysql_open();
   $query = "SELECT * ";
   $query .= "FROM profiles, interests ";
   $query .= "WHERE profile.id=" . $id;
   $query .= " AND interests.profile_id=" . $id;
   $result = @ mysql_query($query, $connection);
   // Transform the result set to an array (for Smarty)
   $entries = array();
   while ($row = mysql_fetch_array($result)) {
      $entries[] = $row;
   }
   mysql_close($connection) or show_error();;
   return $entries;   
}


Can someone please advise on how this can be done? or do i need to have two query's one for each table ?

Thank you in advance!!

Hi all,

I am lost again in this PHP world. I am trying to set up a grade book for my reporting system. I have got totally lost in the code and I am need of some help.

Many Thanks

F

Code: [Select]
<?php 
function doquery($query) {
  $db = "prs";
   $link = mysql_connect("localhost","gandalf","A3tti2ca")
     or die("Could not connect to server! Error: ".mysql_error());
   mysql_select_db($db,$link)
     or die("Could not select $db! Error: ".mysql_error());
   $result = mysql_query($query,$link)
     or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error();
   mysql_close($link);
   return($result);
}

function parseresults($result) {
   if ($line = mysql_fetch_array('$result', MYSQL_ASSOC)) {
        displayform($line);
   } 
        else {
    print "A database problem has occurred. Contact the database administrator<p>";
  }
}


function displayform($line) {
<<<HTML
 <form action="gradebook2.php" method="post">
   <H4>Thank You, <p>
HTML;

   print $line['firstname']." ".$line['surname']." (#".$line['upn'].") in set ".$line['class_set'];
   print ' has been sucessfully added to the system.<p>';
         echo"<form id=\"Gradebook\" name=\"gradebook\" method=\"post\" action=\"gradebook2.php\">
        <table width=\"77%\" border=\"1\" align=\"center\" cellpadding=\"5\" cellspacing=\"0\" bordercolor=\"#de6057\">
         <tr>
           <td width=\"45%\" class=\"footer\">
 <label class=\"form_labels\">Coursework Mark</label>
                                 </td>
           
 <td width=\"55%\">
  <input name=\"cw_mark\" type=\"text\" id=\"cw_mark\" value=".$line['english_cw_mark']." tabindex=\"1\" size=\"6\" maxlength=\"4\" />
<input type=\"hidden\" name=\"upn\" value=".$line['upn'].">
</td>
         </tr>
        
<tr>
           <td class=\"footer\">Coursework Comment </td>
           <td>
  <label>
  <textarea name=\"cw_comment\" id=\"cw_comment\" cols=\"35\" rows=\"7\" value=".$line['english_cw_commnents']."></textarea>
        </label>
</td>
        </tr>
        
<tr>
           <td class=\"footer\"><label class=\"form_labels\">Exam Mark</label></td>
           <td>
<input name=\"exam_mark\" type=\"text\" id=\"exam_mark\" value=".$line['english_exam_mark']." tabindex=\"3\" size=\"6\" maxlength=\"4\">
</td>
         </tr>
       
    <tr>
           <td class=\"form_labels\">Exam Comment </td>
                   <td>
     <label>
             <textarea name=\"exam_comment\" id=\"exam_comment\" cols=\"35\" rows=\"7\" value=".$line['english_exam_comments']."></textarea>
                </label>
         </td>
         </tr>
       
    <tr>
           <td class=\"form_labels\"><label>Commendation in Poetry</label></td>
          <td>
  <select name=\"com_poetry\" id=\"com_poetry\" value=".$line['com_poetry'].">
                         <option value=\"No Commendation\" selected=\"selected\">No Commendation</option>
                        <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
</td>
       </tr>
        
       <tr>
            <td class=\"form_labels\"><label>Commendation in Creative Writing</label></td>
             <td>
<select name=\"com_creative\" id=\"com_creative\" value=".$line['com_creative'].">
                    <option selected=\"selected\">No Commendation</option>
                   <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
              </td>
                 </tr>
        
<tr>
           <td class=\"form_labels\">Commendation in Literary Interpretation</td>
           <td>
  <select name=\"com_lit_int\" id=\"com_lit_int\" value=".$line['com_lit_int'].">
             <option value=\"No Commendation\" selected=\"selected\">No Commendation</option>
            <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
</td>
         </tr>
        
<tr>
          <td class=\"form_labels\"><label>Overall Comments</label></td>
            <td>
    <textarea name=\"overall_comments\" id=\"overall_comments\" cols=\"35\" rows=\"7\" value=".$line['english_overall_commnents'].'"></textarea>
 </td>
         </tr>
       
    <tr>
           <td>&nbsp;</td>
           <td>
<input type=\"reset\" name=\"Reset\" id=\"Reset\" value=\"Reset Form\" tabindex=\"12\" /> &nbsp;&nbsp;
   <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit Form\" tabindex=\"11\" />
</td>
         </tr>
       </table>
  </form>";
}


$student_upn = (integer) $_POST["stu_upn"];
$query = "select count(*) as numberRecords from english where upn = ".$student_upn."";
$result = doquery($query);
$row = mysql_fetch_array($result);

if ($row['numberRecords'] == 0)  
{
$query = "select students.upn from students where students.upn = '".$student_upn."'";
$result = doquery($query);
$row = mysql_fetch_array($result);
$cw_mark = $row['english_cw_mark'];
$cw_comment = $row['english_cw_comments'];
$exam_mark = $row['english_exam_mark'];
$exam_comment = $row['english_exam_comments'];
$com_poetry = $row['com_poetry'];
$com_creative = $row['com_creative'];
$com_lit_int = $row['com_lit_int'];
$overall_comment = $row['english_overall_comments'];
$insert = "insert into english (upn, english_cw_mark, english_cw_comments, english_exam_mark, english_exam_comments, com_poetry, com_creative, com_lit_int, english_overall_ comments) values (".$student_upn.",'".$cw_mark."','".$cw_comment."', '".$exam_mark.",'".$exam_comment."','".$com_poetry."','".$com_creative."','".$com_lit_int."','".$overall_comment."',0);
print $insert;
doquery($insert);
}

$query =  select students.upn as upn, firstname, surname, class_set, from customers left join english on students.upn = english.upn where students.upn = ".$student_upn.";
$result = doquery($query);

if (is_resource($result)) {
  parseresults($result);
} else {
   print "$result";
}
print "<a href=\"gradebook.php\"><h4>Grade Another Student</h4></a>";
?>

Hey,   I have am creating a web app to hold customer and job details.. I have the following table structures to hold the data:  

CREATE TABLE Customers (
  customerID int(5) NOT NULL auto_increment,
  customer varchar(25) default NULL,
  contact varchar(25) default NULL,
  phone varchar(25) default NULL,
  email varchar(25) default NULL,
  address varchar(25) default NULL,
  PRIMARY KEY (customerid)
) ENGINE = INNODB;


CREATE TABLE Jobs (
  jobID int(5) NOT NULL auto_increment,
  customerID int(5) NOT NULL default '0',
  invoiceNumber varchar(25) default NULL,
  purchasOrder varchar(25) default NULL,
  orderDate datetime NOT NULL default '0000-00-00',
  dateRequired datetime NOT NULL default '0000-00-00',
  jobStatus varchar(25) default NULL,
  PRIMARY KEY (jobID)
) ENGINE = INNODB;


CREATE TABLE vinyl (
  vinylID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  colour varchar(25) default NULL,
  font varchar(25) default NULL,
  size varchar(25) default NULL,
  fileLocation varchar(25) default NULL,
  PRIMARY KEY (vinylID)
) ENGINE = INNODB;


CREATE TABLE screenprint (
  screenprintID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  colour varchar(25) default NULL,
  font varchar(25) default NULL,
  size varchar(25) default NULL,
  fileLocation varchar(25) default NULL,
  PRIMARY KEY (screenprintID)
) ENGINE = INNODB;


CREATE TABLE items (
  itemID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  supplier varchar(25) default NULL,
  code varchar(25) default NULL,
  colour varchar(25) default NULL,
  style varchar(25) default NULL,
  total varchar(25) default NULL,
  dateOrdered varchar(25) default NULL,
  PRIMARY KEY (itemID)
) ENGINE = INNODB;


CREATE TABLE itemsqty (
  itemqtyID int(5) NOT NULL auto_increment,
  itemID int(5) NOT NULL default '0',
  jobID int(5) NOT NULL default '0',
  size varchar(25) default NULL,
  quanity int(5) NOT NULL default '0',
  PRIMARY KEY (itemqtyID)
) ENGINE = INNODB;


CREATE TABLE embroidery (
  embroideryID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  code varchar(25) default NULL,
  stitchCount varchar(25) default NULL,
  quanity int(5) NOT NULL default '0',
  PRIMARY KEY (embroideryID)
) ENGINE = INNODB;

Are these tables set out correctly for the collection of data needed. Also.. am I best to use Foreign Keys? My understanding of using foreign keys is not in place for queries as such, more to keep the tables clean of miss matched records etc?   Thanks

Hey everyone.

I have some experience with PHP and can easily modify existing code, but seem to have trouble writing the logic from scratch.

Situation:

I'm using this Jquery slider ( http://mine.tuxfamily.org/?p=74#more-74 ) and would like to populate the slides with data coming from an XML file. The data will be text, images(URIs), and links to buy. The thing is, each slide will hold 4 items, and then I want to somehow using PHP logic, allow the code to generate the next slide...

In other words, how would I code it so that after 4 entries, it creates a new slide?

I'm imagining a For loop + SimpleXML functions... but just kind of fumbling in the dark here.

Any direction or guidance is greatly appreciated!

Kind regards,
Dey

<?php
$con = mysql_connect("localhost","user","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("contact", $con);

$sql="INSERT INTO contact_info (FirstName, LastName, Phone, Email, ContactMethod, City, State, zip, TimeFrame, Agent, AgentInfo)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[phone]','$_POST[email]','$_POST[contactmethod]','$_POST[city]','$_POST[state]','$_POST[zip]','$_POST[timeframe]','$_POST[agent]','$_POST[agentinfo]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

That's my code everything seem's to be working fine script runs and says 1 record added however when I go to view the entry phpMyAdmin the entry show's up without the data?