I know that this might be an Ajax/Javascript question. Hopefully you
can help. I do not know of any other source for good info.
I would like to be able to click on one field in a table, and retrieve
the data in another field. Here is the information:
The table is:
+----------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------------------+------+-----+---------+-------+
| Cust_Num | smallint(5) unsigned | NO | PRI | NULL | |
| Fname | varchar(25) | NO | | NULL | |
| Lname | varchar(25) | NO | | NULL | |
| Street | varchar(25) | NO | | NULL | |
| City | varchar(25) | NO | | NULL | |
| State | varchar(2) | NO | | NULL | |
| Zip | mediumint(9) | NO | | NULL | |
| Phone | int(10) | NO | | NULL | |
| Date | date | NO | | NULL | |
| Notes | text | YES | | NULL | |
| P1 | int(3) | YES | | NULL | |
| P2 | int(3) | YES | | NULL | |
| P3 | int(4) | YES | | NULL | |
+----------+----------------------+------+-----+---------+-------+
Click on Lname and retrieve the Cust_Num.
Here is the sql query that will be used:
$sql12 = 'SELECT Cust_Num, Fname, Lname, Street, City, State, Zip,
Phone, Notes FROM Customers WHERE Cust_Num = $_POST['Cust_Num'];
[I'm actually doing this w/ prepared statements]
$i = 0;
do
{
{
$vara2 = array(array($Cust_Num, $Fname,
$Lname, $Street, $City, $State, $Zip, $Phone, $Notes));
$vara2[$i][0] = $Cust_Num;
$vara2[$i][1] = $Fname;
$vara2[$i][2] = $Lname;
$vara2[$i][3] = $Street;
$vara2[$i][4] = $City;
$vara2[$i][5] = $State;
$vara2[$i][6] = $Zip;
$vara2[$i][7] = $Phone;
$vara2[$i][8] = $Notes;
$_SESSION['exe'] = 2;
?>
<tr>
<td class="cn"> <?php echo $vara2[$i][0]?> </td>
<td> <?php echo $vara2[$i][1]?> </td>
<tdclass="ln"> <?php echo $vara2[$i][2]?> </td>
<td> <?php echo $vara2[$i][3]?> </td>
<td> <?php echo $vara2[$i][4]?> </td>
<td> <?php echo $vara2[$i][5]?> </td>
<td> <?php echo $vara2[$i][6]?> </td>
<td> <?php echo $vara2[$i][7]?> </td>
<td class="first-col"><?php echo $vara2[$i][8] ?></td>
<?php
echo "</tr>\n";
$i = $i + 1;
}
} while (mysqli_stmt_fetch($stmt)); //end do-while
$imax = $i;
echo "</table>";
echo "</center>";
} // end count($errors_array)
Any ideas?
Eitan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
