populate text box from MYSQL query

Question

I need to Query a database and then populate a textbox input with the result.

I'm trying

Date Called:

   <td>
      <?php 
         $selectedSPK=$_POST['SPKSelect'];
        $assigned = $_POST['Sales_Exec'];
        $date = $_POST['DateSelect'];

if ($selectedSPK)

{
    $Call1query = "SELECT  Call1 FROM Data WHERE SPKCustNo  = '$selectedSPK' ";

$Call1result = mysql_query($Call1query);


 while( $row = mysql_fetch_array($Call1result) ){
    $Call1 = $row["$Call1Result"];

    }

}
?>
    <input type="text" name="Call1" id="Call1" value="<?php echo( htmlspecialchars( $Call1) ); ?>"/></td>

But getting nothing out, where am I going wrong, Text inputs seem tricky to populate!

Thankyou!

You can't do this... $Call1 = $row["$Call1Result"];... Give the field names in $row — Bhuvan Rikka
– Bhuvan Rikka, Commented Oct 3, 2012 at 10:48

triclosan · Accepted Answer · 2012-10-03 10:47:32Z

2

use instead

$Call1 = $row["Call1"];

answered Oct 3, 2012 at 10:47

triclosan

5,7846 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chris Spalton Over a year ago

Awesome! Thankyou, will mark as answer as soon as the timer lets me.

Bhuvan Rikka · Accepted Answer · 2012-10-03 11:01:24Z

1

Replace

$Call1 = $row["$Call1"];

with

$Call1 = $row["Call1"];

edited Oct 3, 2012 at 11:01

Bhuvan Rikka

2,7031 gold badge19 silver badges28 bronze badges

answered Oct 3, 2012 at 10:47

Man Programmer

5,3662 gold badges24 silver badges21 bronze badges

Comments

Yogesh Suthar · Accepted Answer · 2012-10-03 10:48:46Z

0

the problem is here change

$Call1 = $row["$Call1Result"];

to

$Call1 = $row['Call1'];   //here column name comes not variable name

answered Oct 3, 2012 at 10:48

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Comments

M.I.T. · Accepted Answer · 2012-10-03 11:00:00Z

0

try like this

<td>
  <?php 
     $selectedSPK=$_POST['SPKSelect'];
    $assigned = $_POST['Sales_Exec'];
    $date = $_POST['DateSelect'];

if ($selectedSPK)

{
 $Call1query = "SELECT  Call1 FROM Data WHERE SPKCustNo  = '$selectedSPK' ";

$Call1result = mysql_query($Call1query);


 while( $row = mysql_fetch_array($Call1result) ){
$Call1 = $row["Call1"];

}

}?>

<input type="text" name="Call1" id="Call1" value="<?php echo( htmlspecialchars( $Call1) ); ?>"/></td>

answered Oct 3, 2012 at 11:00

M.I.T.

1,0422 gold badges17 silver badges34 bronze badges

Collectives™ on Stack Overflow

populate text box from MYSQL query

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related