help sort

[kamsmartx]

hi
i hve this code , this code is sort data to data base , but when i select valuse form list print value of other filed ,,,

but the wrong is :--
when i dislpy data i see on file address , tell , pationtname ,the value "pationtname " why !!!

we must print on address, tell , pationtname value of each

😕 😕 😕

<select name="FileNO" onChange="change_pationt(this.value);">
            <? 

$query="SELECT * FROM pationt";
$result=mysql_query($query) or die("error: " . mysql_error());
while($row=mysql_fetch_array($result))
{
?>  

<option value="<?php echo $row['PationtName'] . '^' . $row['address'] . '^' . $row['tell']; ?>"><?php echo $row['PNO'] ; ?></option>   

<?

}  
?>
</select>
<input name="PationtName" type="text" id="PationtName"/>

<input name="address" type="text" id="address"/>

<input name="tell" type="text" id="tell"/>

function change_doctor(ref) {
  var arr = ref.split(/^/);
  document.getElementById('PationtName').value  = arr[0]; 
  document.getElementById('address').value  = arr[1];
  document.getElementById('tell').value  = arr[2];
}

[Xager]

Can anyone make sence of this? o.O

[kamsmartx]

ya ya

[kamsmartx]

what can i do

[laserlight]

I think you need to explain the problem better. For example, it is not clear what "sort data to data base" means.

[kamsmartx]

ok
i have table pationt and i wont to select any value from list

<select name="FileNO" onChange="change_pationt(this.value);"> 
            <? 

$query="SELECT * FROM pationt"; 
$result=mysql_query($query) or die("error: " . mysql_error()); 
while($row=mysql_fetch_array($result)) 
{ 
?>   

<option value="<?php echo $row['PationtName'] . '^' . $row['address'] . '^' . $row['tell']; ?>"><?php echo $row['PNO'] ; ?></option>    

<? 

}   
?> 
</select>

and after that we must print to

<input name="PationtName" type="text" id="PationtName"/>

the pationt name

---

and here

<input name="tell" type="text" id="tell"/>

tell of pationt

---

and here

<input name="address" type="text" id="address"/>

---

so what can i do to make this >>>

but we must sort ths vaule to the data base

[leatherback]

First of all:
=> Do you realize that PhP runs on the server, and once the server has produces the webpage, PhP is not involved anymore untill you make a new call to the server?

In other words: You have a javascript function: onChange="change_pationt(this.value). Does this make a call to the server to reload the page?

Is that happens, you are on the right way. Just for testing, place these two lines of code on the lop of your php code:

print_r($_POST);
print_r($_GET);

This will show you which variables are being passed to the page. If you are getting the patient ID (FileNO) through to that page, you are on track; Let us know what that gives you and we will look again.

In short what you then need to do is change te query to:

if(is_numeric($_POST['FileNO']))
  {
  $filenr = $_POST['FileNO'];
  $query="SELECT * FROM pationt where FILECOLUM = $filenr";
  }
else
  {
  $query="SELECT * FROM pationt where FILECOLUM = $filenr";
  }

[kamsmartx]

no no

u canot understande me !!

i explain the problem above are you read it >🙂

i need whent i select value from list , the server call value of pationt from pationt table and put it on text filed then i press ok to save this value to another table

[leatherback]

Kams,

As pointed out here, and also in your other thread on this topic you need to read the suggestions given, answer the questions posted, and -specifically in your case- be a bit more clear onwhat you want.

Once you start 'listening' and provide the answers requested I am sure we can sort this out. No offense, but you English is rather difficult to read. So we might be misunderstanding one another. BUt I think I understood your question. We need the info I asked of you.

[kamsmartx]

what u need

[leatherback]

Read the posts and respond to the questions

[kamsmartx]

i read

[kamsmartx]

so any one not help me ok

[leatherback]

1) what does "sort data to data base" mean
2) Do you realize that PhP runs on the server, and once the server has produces the webpage, PhP is not involved anymore untill you make a new call to the server?
3) You have a javascript function: onChange="change_pationt(this.value). Does this make a call to the server to reload the page?
4) what do the code snippets here give you