PHP - On Submit, Which Table Row Am I In?

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

Hi.  Pretty straight forward I guess but as the name suggests am a newbie.  I have a form that requires the user to enter certain parameters.  If the values are blank it submits to itself and loads the error messages.  What I want to do is create PHP code that submits the form to a different url.  What I thought was create two forms (the second with hidden fields replicating the first form), each form having a different url in the action"" code.  What I cant work out is the PHP IF ELSE code to submit form 2 if Form1 is is validated correctly.  This is the PHP code relevant to the form validation.  Help?

<?php
      //If form was submitted
      if ($_POST['submitted']==1) {
          $errormsg = ""; //Initialize errors
          if ($_POST[width]){
             $title = $_POST[width]; //If title was entered
          }
          else{
             $errormsg = "Please enter width";
          }
          if ($_POST[drop]){
             $textentry = $_POST[drop]; //If comment was entered
          }
          else{
             if ($errormsg){ //If there is already an error, add next error
                $errormsg = $errormsg . " & content";
             }else{
                $errormsg = "Please enter drop";
             }
          }
      }

      if ($errormsg){ //If any errors display them
          echo "<div class=\"box red\">$errormsg</div>";
      }

      //If all fields present
      if ($title && $textentry){
         //Do something
          
echo 'THIS IS WHERE I WANT THE CODE TO SUBMIT FORM 2 or SUBMIT FORM 1 TO A DIFFERENT URL';
      }   
      ?>

the info posts beautifully i just canst seem to get the button to auto click or submit, tried numerous ways!  help

Code: [Select]
<?php  

require_once "../store/paypal/utility.php";
require_once "../store/paypal/constants.php";

$url = "https://www.".DEFAULT_ENV.".paypal.com/cgi-bin/webscr";
$postFields =   "cmd=".urlencode("_notify-synch").
            "&tx=".urlencode(htmlspecialchars($_GET["tx"])).
            "&at=".urlencode(DEFAULT_IDENTITY_TOKEN);
$ppResponseAr = Utils::PPHttpPost($url, $postFields, true);

if(!$ppResponseAr["status"]) {
   Utils::PPError($ppResponseAr["error_msg"], $ppResponseAr["error_no"]);
   exit;
}

$httpParsedResponseAr = $ppResponseAr["httpParsedResponseAr"];

// assign posted variables to local variables
   $item_name = $httpParsedResponseAr['item_name'];
   $item_number = $httpParsedResponseAr['item_number'];
   $receiver_email = $httpParsedResponseAr['receiver_email'];
   $receiver_id = $httpParsedResponseAr['receiver_id'];
   $quantity = $httpParsedResponseAr['quantity'];
   $first_name = $httpParsedResponseAr['first_name'];
   $last_name = $httpParsedResponseAr['last_name'];
   $payer_email = $httpParsedResponseAr['payer_email'];
   $txn_type = $httpParsedResponseAr['txn_type'];
   $address_street = $httpParsedResponseAr['address_street'];
   $address_city = $httpParsedResponseAr['address_city'];
   $address_state = $httpParsedResponseAr['address_state'];
   $address_zip = $httpParsedResponseAr['address_zip'];
   $item_number = $httpParsedResponseAr['item_number'];
   $option_name1 = $httpParsedResponseAr['option_name1'];
   $option_selection1 = $httpParsedResponseAr['option_selection1'];
   $option_name2 = $httpParsedResponseAr['option_name2'];
   $option_selection2 = $httpParsedResponseAr['option_selection2'];
   $invoice = $httpParsedResponseAr['invoice'];
   $custom = $httpParsedResponseAr['custom'];
   $payer_id =$httpParsedResponseAr['payer_id'];

?>
<html lang="en">
<head>
<title>Rec</title>
<link REL="stylesheet" href="include/style.css" type="text/css">
<!--[if IE]>
<link REL="stylesheet" href="include/styleIE.css" type="text/css">
<![endif]-->
<style>
#center_block {width:50%;margin:0 auto;min-width:500px;}
#contents_block {text-align:center;}
#header_block {white-space:nowrap;height:25px;padding:0 10px 5px;text-align:center;}
#fields_block {width:100%;margin:0;padding:10px}
#header_block  span {margin:0 5px}
#buttons_block {padding:10px 10px 5px}
#buttons_block div {padding:3px}
#delimiter {margin:2px}
#fields_block td {padding:3px 14px}
#username_block td {padding-top:13px;white-space:nowrap;}
#remember_block td {padding-bottom:13px;white-space:nowrap;}
#required_block {text-align:left;padding:5px}
</style>
<!--[if IE]>
<style>
#main_block {width:100%}
</style>
<![endif]-->
</head>
<body>
<script language="JavaScript" src="include/jquery.js"></script>

<script language="JavaScript" src="include/jsfunctions.js"></script>

<script language="JavaScript" src="include/runnerJS/RunnerBase.js"></script>





 
 
<form action="rec.php" method="post" id="rec" name="rec.php">

<table id="center_block" align="center">
   <tr><td id="contents_block">
 
 
<div class="main_table_border2 loginshade" id="main_block">
 
<table cellpadding=0 cellspacing=0 border=0 id="fields_block" class="loginshade">
 
<tr id="email_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_email_1">Email:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_email_0" style="white-space: nowrap;"><input id="value_email_1" style="" type="text" name="value_email_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["payer_email"]) ?>">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="pass_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_pass_1">Pass:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_pass_0" style=""><input style="" id="value_pass_1" type="Password" name="value_pass_1"  maxlength=50 value="1234">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="confirm_block">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_confirm_1">Re-enter password:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_confirm_0" style=""><input style="" id="value_confirm_1" type="Password" name="value_confirm_1"  value="1234">&nbsp;<font color="red">*</font></span>
      <div class="error"></div>
   </td>
</tr>
 
 
<tr id="fname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_fname_1">First Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_fname_0" style="white-space: nowrap;"><input id="value_fname_1" style="" type="text" name="value_fname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["first_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="lname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_lname_1">Last Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_lname_0" style="white-space: nowrap;"><input id="value_lname_1" style="" type="text" name="value_lname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["last_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="address_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_address_1">Address:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_address_0" style="white-space: nowrap;"><input id="value_address_1" style="" type="text" name="value_address_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_street"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="city_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_city_1">City:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_city_0" style="white-space: nowrap;"><input id="value_city_1" style="" type="text" name="value_city_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_city"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="state_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_state_1">State:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_state_0" style="white-space: nowrap;"><input id="value_state_1" style="" type="text" name="value_state_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_state"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="zip_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_zip_1">Zip:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_zip_0" style="white-space: nowrap;"><input id="value_zip_1" style="" type="text" name="value_zip_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_zip"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="cosponsor_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_cosponsor_1">Cosponsor:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_cosponsor_0" style=""><input id="type_cosponsor_1" type="hidden" name="type_cosponsor_1" value="checkbox"><input id="value_cosponsor_1" type="Checkbox" name="value_cosponsor_1" ></span>
          </td>
</tr>
 
 
<tr id="recipients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_recipients_1">Recipients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_recipients_0" style="white-space: nowrap;"><input id="value_recipients_1" style="" type="text" name="value_recipients_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["quantity"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="clients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_clients_1">Clients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_clients_0" style=""><input id="type_clients_1" type="hidden" name="type_clients_1" value="checkbox"><input id="value_clients_1" type="Checkbox" name="value_clients_1" ></span>
          </td>
</tr>
 
 
<tr id="space_block"></tr>
 
</table>
 
 
</div>
</td></tr>
</table>
    <input type=submit value="Submit" class=button id="saveButton1" onload="Submit"></form>

</body>
</html>

Hi All, I want to copy into a table values from another table that partially match a given value, case-insensitively. So far I do as follows but I wonder whether there is a quicker way.

$input_table=array('1'=>'toto','2'=>'tota','3'=>'hello','4'=>'TOTO','5'=>'toto');
$input_table_2 = array_map('strtolower', $input_table);
$value_to_look_for='Tot';
$value_to_look_for_2=strtolower($value_to_look_for);
$output_table=array();
foreach ($input_table_2 as $k=>$v)
  {
  if(false !== strpos($v, $value_to_look_for_2))
    {
    $output_table[]=$input_table[$k];
    }
}

One drawback is that $input_table_2 is 'foreached' whereas there might be no occurrences, which would lead to a loss of time/resources for big arrays.   Thanks.

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

Hi All ,   I have a small table with 4 fields namely Day_ID, Dues, Last_Visit, Points. where Day_ID is an auto-increment field. The table would be as follows:   Day_ID -- Dues ---  Last_Visit ---  Points. 1  --------- 900 -------- 1/12  --------   6      2  --------- 700 -------- 4/12  --------   7 3  --------- 600 -------- 7/12  --------   5 4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   So this is the record of a person's visit to say a club. The last row indicates the last date of his visit to the club. His points on this date are 6. Based on this point value of 6 in the last row I want to retrieve all the previous BUT adjoining all records that have the same Points i.e. 6.    So my query should retrieve for me, based on the column value of Points of the last row (i.e. Day_ID - 6 ), as follows:   4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   This problem stated above had been completely resolved, thanks to a lot of help from Guru Barand by this following query :-

$query = "SELECT cv.day_id, cv.dues, cv.last_visit, cv.points
FROM clubvisit cv
WHERE last_visit >=
(
SELECT MAX(last_visit) FROM clubvisit
WHERE points <>
(
SELECT points as lastpoints
FROM clubvisit
JOIN
(
SELECT MAX(last_visit) as last_visit
FROM clubvisit
) as latest USING (last_visit)
)
)";

I am using this and it works perfectly except that now there is a slight change in the table because the criteria for points is now dependent on more than one column cv.points and is more like cv.points1, cv.points2, cv.points3 etc. So now I need to make a selection based on each of these cv.points columns.   As of now I can still get the results by running the query multiple times for each of the cv.points columns ( seperately for cv.points1, cv.points2, cv.points3) and it works correctly. However I am wondering if there is a better way to do this in just one go. This not only makes the code repetitive but also since the queries are interconnected, involves the use of transactions which I wish to avoid if possible.    The values that I require for each of the cv.point columns is  1. day_id of the previous / old day on which the cv.points value changed from the current day value, and  2. cv.points on that old/ previous day.    So for  example if the table is as below:   Day_ID -- Dues ---  Last_Visit ---  Points1 --- Points2. 1  --------- 900 -------- 1/12  -----------   9  ------------ 5    2  --------- 600 -------- 4/12  -----------   6  ------------ 6 3  --------- 400 -------- 7/12  -----------   4  ------------ 7 4  --------- 500 -------- 9/12  -----------   5  ------------ 8 5  --------- 600 -------- 10/12 ----------   6  ------------ 8 6  --------- 600 -------- 11/12 ----------   6  ------------ 8 7  --------- 600 -------- 13/12 ----------   6  ------------ 7 8  --------- 500 -------- 15/12 ----------   5  ------------ 7 9  --------- 500 -------- 19/12 ----------   5  ------------ 7   Then I need the following set of values : 1. day_id1 -- Day 7,      points1 ---- 6,          days_diff1 -- (9-7 = 2)  . // Difference between the latest day and day_id1 2. day_id2 -- Day 6,      points2 ---- 8,          days_diff2  -- (9-6 = 3) 3. day_id3 -- ....   and so on for other points.    Thanks all !

Hello everyone.

I need help with the following PHP APP. I am running on (Version PHP 7.2.10) I am trying to have a page table form on table.php pass the input variable of “5-Numbers” to another page called table_results.php

I want that variable string of “5-Numbers” to be compared against 4 arrays and output any duplicates found within each of those 4 lists. If nothing is found, I still want some visual output that reads “None found”.

 

Lets pretend I have the following example ..

On table.php, I typed inside my table form the 5-Numbers ..

INPUT:  2,15,37,13,28

On table_results.php, the 4 arrays to be compared against my input numbers “ 2,15,37,13,28” are ..

 

$array_A = array(2,6,8,11,14,18,24); 

$array_B = array(1,2,9,10,13,14,25,28,);  

$array_C = array(1,3,7,9,13,15,20,21,24); 

$array_D = array(4,5,12,22,23,27,28,29); 

 

So my output should read as follows below ..

OUTPUT: 

 

TABLE

COLUMN 1   COLUMN 2

ROW 1 Matches Found Results ..

ROW 2 GROUP A:            2 

ROW 3 GROUP B:             2,13,28

ROW 4 GROUP ?            13,15

ROW 5 GROUP ?            28

ROW 6 5#s Input:              2,15,37,13,28

 

Please let me know if anyone has any suggestions on how to go about it. 

Thanks.

Edited January 1, 2019 by Jayfromsandiego
Wanted to include image example

hi...

i have a table ...

i add and remove data in the table...when i add new record , information add to center of the table ! whats problem?   i want add data in first of table.   please guide me.thanks

 

 

Can anyone tell me why this will not submit? It's pretty simple code and the reason there is an if else for whether it does a select or update is unrelated.    It does however submit, Name, stars and location. However the testimonial will not update. If we update every field everything will update except for testimonial. The only difference I can see is testimonial is a textarea and an input field? Please help it's driving me crazy. 

if($_POST){
						$name = $_POST['name'];
						$stars = $_POST['stars'];
						$testimonial = $_POST['testimonial'];
						$location = $_POST['location'];

						mysql_query("UPDATE testimonials SET name='$name', stars='$stars', testimonial='$testimonial', location='$location' WHERE testimonialID='$testimonialID'", $retreat);

						echo '<a href="./">Back Home</a> | <a href="./testimonials">Tesimonials</a><br><br>';
						echo 'Yay, Successful. PS: There is no error handling so this really just means you submitted it.';
					} else {
					
						$getTestimonial = mysql_query("SELECT * FROM testimonials WHERE testimonialID='$testimonialID' LIMIT 1", $retreat);
							while($row = mysql_fetch_array($getTestimonial)){
								$testimonialID = $row['testimonialID'];
								$name = $row['name'];
								$stars = $row['stars'];
								$testimonial = $row['testimonial'];
								$location = $row['location'];
							}
				?>

				<a href="./">Back Home</a> | <a href="./testimonials">Tesimonials</a><br><br>
					<form action="testimonials?p=edit&id=<?php echo $testimonialID; ?>" method="POST">

						Name:<br>
						<input type="text" name="name" value="<?php echo $name; ?>"/><br><br>

						Stars:<br>
						<input type="text" name="stars" value="<?php echo $stars; ?>"/><br><br>

						Testimonial:<br>
						<textarea type="text" name="testimonial" ><?php echo $testimonial; ?></textarea><br><br>

						Location:<br>
						<input type="text" name="location" value="<?php echo $location; ?>"/>

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

					</form>

how do I code the submit into this form?
  echo "<form action='#' method='post'><b>Prerent Update :<br /><br />
         <table border='1'>
          <tr>
          <th>dep</th>
          <th>tenant</th>
                    </tr>";
  while($row = mysql_fetch_assoc($result))
  {
   echo "<tr>
          <td><input type='text' name='dep' value='" . $row['dep'] . "'></td>
          <td><input type='text' name='name' value='" . $row['name'] . "'></td>
            
          </tr>";
   }
  echo "</table>
// ***
<input type="submit" name="submit" value="update record"/>
// ***
echo</form>";
  }
 else{echo "No listing for appartment $apt.<br />Please select another.<br />";}
 }
if(!empty($_POST["update"]))
{
 $sql = "UPDATE testtable SET dep, name, amtpaid, prevbal, misc, tentpay, hudpay, datepaid  WHERE apt='apt'";
 mysql_query($sql) or die("Update query failed.");
 echo "Record for appartment ".$_POST["apt"]." has been updated ...";
 }
?>

I am trying to make my website submit a file when the submit button is pressed. I tried to use isset but when I press submit it doesn't work.

This is just an example of when I am trying to do:

<?php

if (isset($_POST['submit'])) {
echo "clicked";
}
else
{
echo "not_clicked";
}

?>

 <form  id="myform" enctype="multipart/form-data" action="test.php" method="POST">
 <input type="submit" value="Upload" />
 
 </form>

Not sure how to do this at all... I'm creating a page with a form to edit existing info in two tables in the database. I need to pre-check some checkboxes and I don't know how. The first query query_selectguest below puts data into the form just fine. query_checked looks in the second table for any rows that match the discount id. Then further down in the form, I have a php snippet that pulls all the classes from a third database. As I'm echoing these out to the page, I want them to be pre-checked if they match a result found in $result_checked

here's what I have right now...

Code: [Select]
$query_selectguest = 'SELECT * FROM tbl_discount WHERE discount_id='.$passedID;
$result_guest = mysql_query($query_selectguest);
$g_row = mysql_fetch_array($result_guest);

$query_checked = 'SELECT * FROM active_discounts WHERE disc_id='.$passedID;
$result_checked = mysql_query($query_checked);
$h_row = mysql_fetch_array($result_checked);

?>

<form name="form1" method="post" action="update_discount.php" onSubmit="return validate_form()">

<input name="discount_name" type="text" class="input" id="subject" size="50" maxlength="100" value="<? print $g_row['discount_name'] ?>">
<input name="discount_amount" type="text" class="input" id="subject" size="5" maxlength="3" value="<? print $g_row['discount_amount'] ?>">

<!-- here's what I'm concerned with -->

This discount applies to these classes:<br>
         
           <?php
$quer4=mysql_query("SELECT workshop_id, workshop_title FROM tbl_workshops order by workshop_title");

while($row4 = mysql_fetch_array($quer4)) {
echo "<input type='checkbox' name='workshop_link_1[]' value='".$row4[workshop_id]."'>".$row4[workshop_title]."<BR>";
}

 ?>

This topic has been moved to MySQL Help.

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

I know I'm doing it something right, but can someone tell me why only one table is showing up? Can you help me fix the issue?

Heres my code:


function showcoords()
{
echo"J3st3r's CoordVision";
$result=dbquery("SELECT alliance, region, coordx, coordy FROM ".DB_COORDFUSION."");
dbarray($result);
$fields_num = mysql_num_fields($result);

echo "<table border='1'>";
// printing table headers


    echo "<td>Alliance</td>";
    echo "<td>Region</td>";
    echo "<td>Coord</td>";


// printing table rows
while($row = mysql_fetch_array($result))
{
    

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row AS $Cell)
     echo "<tr>";     
     echo "<td>".$row['alliance']."</td>\n";
     echo "<td>".$row['region']."</td>\n";
     echo "<td>".$row['coordx'].",".$row['coordy']."</td>\n";
     echo "</tr>\n";
    
}
echo "</table>";
mysql_free_result($result);

}



I have 2 rows inserted into my coords table. Just frustrated and ignorant to php.