Jump to content

problem with foreach


iamq08

Recommended Posts

I'm trying to populate a form in a menu for my website, and for some reason it won't pull the information from the database correctly. Any assistance would be real helpful.

here's the function from the include file

[code]  function get_extensions(){
                $q = mysql_query("select name, context, mailbox, secret from extensions");
                while($info = mysql_fetch_array($q)){
                return $info;
                }
        }[/code]


Heres the excerpt from the php file
[code]
$vars = New Casename;
$vars->mysqldbcon();
$extens = $vars->get_extensions();
..............
................
<?
                foreach($extens as $val){
        ?>

<form action="user.php" method="POST">
                <tr bgcolor="#E7F3FB">
                      <td nowrap valign=top><input name="name" value="<?=$val['name']?>"></td>
                      <td nowrap valign=top><input type="text" maxlength="150" name="context" value="<?=$val['context']?>"></td>
                      <td nowrap valign=top><input type="text" maxlength="150" name="mailbox" value="<?=$val['mailbox']?>"></td>
                      <td nowrap valign=top><input type="text" maxlength="150" name="secret" value="<?=$val['secret']?>"></td>
                          <td nowrap valign=top><input type="Submit" name="action" value="Update"></td>
                      <td nowrap valign=top><input type="Submit" value="Remove" name="action"></td>
                </tr>
</form>
<?}?>[/code]

For some reason it doesn't pull the information correctly.
Link to comment
Share on other sites

I'm trying to pull and populate the page with all of the entries, which is the reason for no where specification.  I don't think the problem is with the function, because I can print values, I think there may be somethin wrong with the foreach statement or below that.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.