Help! I can't figure this out

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jaydeesmalls
Forum Newbie
Posts: 5
Joined: Wed Apr 30, 2008 1:58 pm

Help! I can't figure this out

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Help! I can't figure this out

Post 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);
(#10850)
jaydeesmalls
Forum Newbie
Posts: 5
Joined: Wed Apr 30, 2008 1:58 pm

Re: Help! I can't figure this out

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Help! I can't figure this out

Post by Christopher »

Do you mean that the option is not correctly set to selected?
(#10850)
jaydeesmalls
Forum Newbie
Posts: 5
Joined: Wed Apr 30, 2008 1:58 pm

Re: Help! I can't figure this out

Post 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.
UnGround
Forum Newbie
Posts: 3
Joined: Wed Apr 30, 2008 9:18 pm

Re: Help! I can't figure this out

Post 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.
Post Reply