[Resolved] Displaying Results of DB into fields

ndorfnz

Hello all,

I have page that is displaying results from a mysql database.

In this page I have an edit link that enables the user to "edit" the data. Upon clicking this link they are taken to the original page where the data was input...

I am passing some parameters within the URL, such as the primary key, etc.

I am also passing a parameter of UPDATE which I am attempting to then run some sql to then populate the fields on the page that are in the database...

Below is a sample of the code, it seems to be right however is not working...

//update section
if ($process == "UPDATE")
{
$UpdateQueryRetrieve = mysql_query("SELECT * from log3 where runid = '$run_num'");

while ($UpdateData = mysql_fetch_array($UpdateQueryRetrieve))
{
$distance = $UpdateData[distance];
}
}

Here is the test pages links:

http://www.ndorfnz.com/log2.php

Click on the Edit Run, I am anticipating the code above would AT LEAST update the distance field...

Appreciate your insight!!!!

TheDefender

A couple of things:
1) Since you are retrieving one row, you don't need the while loop.
2) Don't forget your quotes (in red below) in your variable name definitions.

if ($process == "UPDATE") 
{ 
$UpdateQueryRetrieve = mysql_query("SELECT * from log3 where runid = '$run_num'"); 

$UpdateData = mysql_fetch_array($UpdateQueryRetrieve); 

$distance = $UpdateData[[COLOR=firebrick]'[/COLOR]distance[COLOR=firebrick]'[/COLOR]]; 

}

ndorfnz

Thanks for the input...

I added the ' ' that I missed and removed the array...

//update section
if ($process == "UPDATE")
{
$UpdateQueryRetrieve = mysql_query("SELECT * from log3 where runid = '$run_num'");

$distance = $UpdateQueryRetrieve['distance'];
}

Still no luck!

Could it have something to do with the code being "before" the form in which the "fields" (ie: distance) exist?

Thanks again!

TheDefender

Well, in theory, that's what you want, is the query and result set before the input box...

if ($process == "UPDATE") 
{ 
[b]$query = "SELECT * FROM log3 WHERE runid = '$run_num'";
echo $query;
$UpdateQueryRetrieve = mysql_query($query);[/b]


$distance = $UpdateQueryRetrieve['distance']; 
}

Make the above changes, and let's take a look at what is echoing out when you echo your $query string.

ndorfnz

The query and result set are before the input box, yes.

results of the echo:
SELECT * FROM log3 WHERE runid = '2693'

I am going to try and move it within the form...

Thanks again for your help!

ndorfnz

To no avail when moving the code within the form...

I do have these fields defined within the form as such:

<TD ALIGN=RIGHT VALIGN=TOP bgcolor="#808080" width="550">
<font face="Verdana" color="#000000" size="3">Distance:<INPUT TYPE=TEXT NAME="distance" VALUE= "" SIZE=6" onChange='calcPace();'>

Could this possibly be causing the problem?

Thanks again.

TheDefender

Change to:

<INPUT TYPE=TEXT NAME="distance" VALUE= "<?= $distance; ?>" SIZE="6" onChange="calcPace();">

ndorfnz

Very interesting... that appears to me that it should have worked, but did not...

The form doesn't need to be submitted to be able to populate values, that just doesn't seem like an issue, but I'm reaching now!

Changed query to specific to distance thinking that may help isolate...

Trying to echo out the value of $distance and not getting anything...

if ($process == "UPDATE")
{
$query = "SELECT distance FROM log3 WHERE runid = '$run_num'";
echo $query;
$UpdateQueryRetrieve = mysql_query($query);

$distance = $UpdateQueryRetrieve['distance'];
echo $distance;
}

Appreciate your help!
😃 😃

ndorfnz

Well, I finally got it!!!

Went back to using an Array, that in combination with the distance value equaling <? $distance ?> did it!!

if ($process == "UPDATE")
{
$U1query = "SELECT * FROM log3 WHERE runid = '$run_num'";
echo $U1query;

$Uquery = mysql_query($U1query);

while ($UpdateQueryRetrieve = mysql_fetch_array($Uquery))
{
echo $UpdateQueryRetrieve;
$distance = $UpdateQueryRetrieve['distance'];
echo $distance;
}
}

Thanks for your help!!!

TheDefender

OK, then, let's add some error checking to your connect and query statements to see if you are even connecting and retrieving data.

$connect = mysql_connect(SERVERNAME, USER, PASSWORD) [b]OR mysql_die()[/b];

$UpdateQueryRetrieve = mysql_query($query) [b]OR mysql_die()[/b];

Let's take a look and see if any errors are produced.

[edit]Oops, you got it while I was posting this, so disregard. But, for future reference, this can be helpful in troubleshooting. Make sure you mark this thread resolved. Have a nice day.[/edit]