Create a form and add a submit button that will run a php file.
The SQL query in the php file will have something like
"SELECT custName FROM table WHERE lname='$lname';
This will come after you have retrieved the data from a form like this
$lname = $_POST['lname'];
On 10 February 2013 15:45, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> wrote:
> On 2/9/2013 10:51 PM, Ethan Rosenberg, PhD wrote:
>
>> 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
>>
>>
>> I'm not sure what you are going to do with the customer number when you
> get it since you are outside of php but here's one way of getting it on the
> fly:
>
> As you build your html table wtih php, assign an id to the name fields and
> the custno fields, such as 'id=name1' id='name2', etc. and 'id=cust1',
> 'it=cust2' and so on.
>
> On the name field also add an onclick=getCustNo($i) where $i has the value
> of the id value. Then write a javascript function like:
>
> function getCustNo(id)
> {
> var cno = "cust"+id;
> var cname = "name"+id;
> namefld = document.getElementById(cname)**.value;
> custno = document.getElementById(cno).**value;
> alert("Customer "+namefld+ "has customer number "+custno);
> return;
> }
>
> As I said - I don't know what you think you are going to do now but you
> got it.
>
> PS - I might have used ".value" when it should be ".innerHTML" in the js
> code. You'll have to experiment.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
