Page 1 of 1

Help! I can't figure this out

Posted: Wed Apr 30, 2008 2:00 pm
by jaydeesmalls
I know it's a lot, and probably, not very pretty, and there probably is a better way to do this, but...

Why doesn't the 'act' field show when I try to echo this? Every other field shows fine, just the 'act' field.

***** PLEASE USE THE CODE OR PHP TAGS WHEN POSTING *****

Code: Select all

<?php
$id ='11'; //Foundation Specialist 1
$results = mysql_query("SELECT p1 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>                                                                   
<select name="fs1a">
   <option value=" "<?php if ($values['p1'] == " ") echo 'selected="selected"'; ?>> </option>
   <option value="Annie"<?php if ($values['p1'] == "Annie") echo 'selected="selected"'; ?>>Annie</option>
   <option value="Antonio"<?php if ($values['p1'] == "Antonio") echo 'selected="selected"'; ?>>Antonio</option>
   <option value="Beverly"<?php if ($values['p1'] == "Beverly") echo 'selected="selected"'; ?>>Beverly</option>
   <option value="Celia"<?php if ($values['p1'] == "Celia") echo 'selected="selected"'; ?>>Celia</option>
   <option value="Charlene"<?php if ($values['p1'] == "Charlene") echo 'selected="selected"'; ?>>Charlene</option>
   <option value="Dennis"<?php if ($values['p1'] == "Dennis") echo 'selected="selected"'; ?>>Dennis</option>
   <option value="Elaine"<?php if ($values['p1'] == "Elaine") echo 'selected="selected"'; ?>>Elaine</option>
   <option value="Elizabeth"<?php if ($values['p1'] == "Elizabeth") echo 'selected="selected"'; ?>>Elizabeth</option>
   <option value="Erica"<?php if ($values['p1'] == "Erica") echo 'selected="selected"'; ?>>Erica</option>
   <option value="Faye"<?php if ($values['p1'] == "Faye") echo 'selected="selected"'; ?>>Faye</option>
   <option value="Gladys"<?php if ($values['p1'] == "Gladys") echo 'selected="selected"'; ?>>Gladys</option>
   <option value="Grace"<?php if ($values['p1'] == "Grace") echo 'selected="selected"'; ?>>Grace</option>
   <option value="Jennifer"<?php if ($values['p1'] == "Jennifer") echo 'selected="selected"'; ?>>Jennifer</option>
   <option value="Karl"<?php if ($values['p1'] == "Karl") echo 'selected="selected"'; ?>>Karl</option>
   <option value="Kimberly"<?php if ($values['p1'] == "Kimberly") echo 'selected="selected"'; ?>>Kimberly</option>
   <option value="Ross"<?php if ($values['p1'] == "Ross") echo 'selected="selected"'; ?>>Ross</option>
   <option value="Seth"<?php if ($values['p1'] == "Seth") echo 'selected="selected"'; ?>>Seth</option>
   <option value="Shana"<?php if ($values['p1'] == "Shana") echo 'selected="selected"'; ?>>Shana</option>
</select>
<?php
$id ='11'; //Foundation Specialist 1
$results = mysql_query("SELECT act FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>   
<select name="act">
   <option value=" "<?php if ($values['act'] == " ") echo 'selected="selected"'; ?>> </option>
   <option value="(C)"<?php if ($values['act'] == "(C)") echo 'selected="selected"'; ?>>(C)</option>
   <option value="(H)"<?php if ($values['act'] == "(H)") echo 'selected="selected"'; ?>>(H)</option>
   <option value="(T)"<?php if ($values['act'] == "(T)") echo 'selected="selected"'; ?>>(T)</option>
</select>
<?php
$id ='11'; //Foundation Specialist 1
$results = mysql_query("SELECT p2 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>   
<select name="fs1b">
   <option value=" "<?php if ($values['p2'] == " ") echo 'selected="selected"'; ?>> </option>
   <option value="Annie"<?php if ($values['p2'] == "Annie") echo 'selected="selected"'; ?>>Annie</option>
   <option value="Antonio"<?php if ($values['p2'] == "Antonio") echo 'selected="selected"'; ?>>Antonio</option>
   <option value="Beverly"<?php if ($values['p2'] == "Beverly") echo 'selected="selected"'; ?>>Beverly</option>
   <option value="Celia"<?php if ($values['p2'] == "Celia") echo 'selected="selected"'; ?>>Celia</option>
   <option value="Charlene"<?php if ($values['p2'] == "Charlene") echo 'selected="selected"'; ?>>Charlene</option>
   <option value="Dennis"<?php if ($values['p2'] == "Dennis") echo 'selected="selected"'; ?>>Dennis</option>
   <option value="Elaine"<?php if ($values['p2'] == "Elaine") echo 'selected="selected"'; ?>>Elaine</option>
   <option value="Elizabeth"<?php if ($values['p2'] == "Elizabeth") echo 'selected="selected"'; ?>>Elizabeth</option>
   <option value="Erica"<?php if ($values['p2'] == "Erica") echo 'selected="selected"'; ?>>Erica</option>
   <option value="Faye"<?php if ($values['p2'] == "Faye") echo 'selected="selected"'; ?>>Faye</option>
   <option value="Gladys"<?php if ($values['p2'] == "Gladys") echo 'selected="selected"'; ?>>Gladys</option>
   <option value="Grace"<?php if ($values['p2'] == "Grace") echo 'selected="selected"'; ?>>Grace</option>
   <option value="Jennifer"<?php if ($values['p2'] == "Jennifer") echo 'selected="selected"'; ?>>Jennifer</option>
   <option value="Karl"<?php if ($values['p2'] == "Karl") echo 'selected="selected"'; ?>>Karl</option>
   <option value="Kimberly"<?php if ($values['p2'] == "Kimberly") echo 'selected="selected"'; ?>>Kimberly</option>
   <option value="Ross"<?php if ($values['p2'] == "Ross") echo 'selected="selected"'; ?>>Ross</option>
   <option value="Seth"<?php if ($values['p2'] == "Seth") echo 'selected="selected"'; ?>>Seth</option>
   <option value="Shana"<?php if ($values['p2'] == "Shana") echo 'selected="selected"'; ?>>Shana</option>
</select>
 
<?php
$id ='11'; //Foundation Specialist 1 Extra
$results = mysql_query("SELECT extra FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1ex" size="15" maxlength="60" value="<?php echo $values['extra']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 1
$results = mysql_query("SELECT up1 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up1" size="12" maxlength="60" value="<?php echo $values['up1']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 2
$results = mysql_query("SELECT up2 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up2" size="12" maxlength="60" value="<?php echo $values['up2']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 3
$results = mysql_query("SELECT up3 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up3" size="12" maxlength="60" value="<?php echo $values['up3']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 4
$results = mysql_query("SELECT up4 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up4" size="12" maxlength="60" value="<?php echo $values['up4']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 5
$results = mysql_query("SELECT up5 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up5" size="12" maxlength="60" value="<?php echo $values['up5']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 6
$results = mysql_query("SELECT up6 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up6" size="12" maxlength="60" value="<?php echo $values['up6']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
<?php
$id ='11'; //Update 7
$results = mysql_query("SELECT up7 FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);
?>
<input type="text" name="fs1up7" size="12" maxlength="60" value="<?php echo $values['up7']; ?>"/><input type="hidden" name="textid" value="<?php echo $id; ?>" />
 
and here is what I have on the page where it is to be echoed:
 
<?php
$query="SELECT * FROM $tbl_name WHERE id ='11'";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
echo '<h2>', ($row['p1']), '</h2>' . '&nbsp;' . '<h2>', ($row['act']), '</h2>' . '&nbsp;' . '<h2>', ($row['p2']), '</h2>' . '&nbsp;' . '<h2>', '</h2>' . '&nbsp;' . '<h2>', ($row['extra']), '</h2>' . '&nbsp;' . '<h2 class="update1">', ($row['up1']), '</h2>' . '&nbsp;' . '<h2 class="update2">', ($row['up2']), '</h2>' . '&nbsp;' . '<h2 class="update3">', ($row['up3']), '</h2>' . '&nbsp;' . '<h2 class="update4">', ($row['up4']), '</h2>' . '&nbsp;' . '<h2 class="update5">', ($row['up5']), '</h2>' . '&nbsp;' . '<h2 class="update6">', ($row['up6']), '</h2>' . '&nbsp;' . '<h2 class="update7">', ($row['up7']), '</h2>';
}
mysql_free_result($result);
?>
Thank you for reading this

Re: Help! I can't figure this out

Posted: Wed Apr 30, 2008 2:09 pm
by Christopher
The first think is that you only need to do one query at the top:

Code: Select all

$results = mysql_query("SELECT * FROM $tbl_name WHERE id='$id'");
$values = mysql_fetch_array($results);

Re: Help! I can't figure this out

Posted: Wed Apr 30, 2008 2:17 pm
by jaydeesmalls
Thanks. I will change that. I am very new to PHP and didn't realize I could do that.

Did you see anything peculiar with why the 'act' row isn't echoing? It's the only input that doesn't echo, and I don't understand why.

thank you

Re: Help! I can't figure this out

Posted: Wed Apr 30, 2008 2:30 pm
by Christopher
Do you mean that the option is not correctly set to selected?

Re: Help! I can't figure this out

Posted: Wed Apr 30, 2008 2:53 pm
by jaydeesmalls
I don't know why 'act' is not echoing correctly. Everything else in that line shows as it should, but the 'act' part is omitted.

Re: Help! I can't figure this out

Posted: Wed Apr 30, 2008 9:53 pm
by UnGround
if you go into MySQL and run the query "SELECT act FROM $tbl_name WHERE id=11" what does it return? It may be a Data issue rather then a PHP issues.

As another note, you may find it better to code your selects using the DB data rather then hard coding it in, which means when you update the database later, the site will automatically reflect it rather then you having to go back in and update every field manually.
One way to do this is to use the query you have above and another query like "SELECT DISTINCT p2 from TABLE" (in an ideal DB, these would even be a separate table...) You can then iterate through this new query for each select (pseudo-code)

Code: Select all

 
echo "<select name = fb>";
$res1=mysql_query("SELECT p2 FROM $tbl_name WHERE id=11");
$value=mysql_fetch_array($res); //value you want selected in the option
$res2=mysql_query("SELECT DISTINCT p2 from TABLE"); //all possible option values
while($op=mysql_fetch_array($res2))
{
     echo "<option value='$op'";  
     if($op==$value)         
          echo "selected";
     echo ">$op</option>";
}
echo "</select>";
keep in mind this would need some tweaking to work, and is only a quick code up so it may contain bugs.