[RESOLVED] is this right ?

[sttc2]

what im trying todo is make a page were registered menber can see who has registerd, iv tested this code it works prefect but i want it as normal text not in a dropdown menu can anyone show mw how to pur it into normal text like

user 1
user2
user3
ect

<?php
$dbhost = "localhost";
$dbname = "db";
$dbuser = "user";
$dbpass = "pass";

 mysql_connect($dbhost,$dbuser,$dbpass);
 mysql_select_db($dbname);




$sql="select * from forummembers";
$result=mysql_query($sql);
echo "<select name=\"select\">\n";
while($zeile = mysql_fetch_array($result)){
?>
<option value="<?php echo $zeile['id']; ?>"><?php echo $zeile['member_name'];
?></option>
<?php
}
?>
</select>

thanks

[kfcSmitty]

This line

<option value="<?php echo $zeile['id']; ?>"><?php echo $zeile['member_name'];
?></option>

Is making the option menu. If you remove the <option> tag and add a <br /> to the end, it will list it as plain text down the page.

You could also add <tr> and <td> tags to format it in a table.

[sttc2]

so like this

   

  <br /> <?php echo $zeile['id']; ?>><?php echo $zeile&#91;'member_name'];
   
 ?><br />

??

[kfcSmitty]

Have you tested it?

That code would

#1 Have an extra > in it when being display
and
#2 Would print a break rule, then the value of 'id' and then the value of 'member_name' (with > in between)and another break rule.

[sttc2]

no still the same =[

[kfcSmitty]

You will also need to remove the <select> tags from around the while.

I suggest you look up what a select tag is in HTML.

http://www.w3schools.com/TAGS/tag_Select.asp

What you need to do is either print each out with a <br /> at the end, or add them to an HTML table http://www.w3schools.com/html/html_tables.asp

I would also recommend actually learning what your code is doing rather than just copying and pasting it.

[sttc2]

i know what the code dose just i get confused very ez

[sttc2]

hmm like this ?

<?php
$dbhost = "localhost";
$dbname = "";
$dbuser = "";
$dbpass = "";

 mysql_connect($dbhost,$dbuser,$dbpass);
 mysql_select_db($dbname);



$sql="select * from forummembers";
$result=mysql_query($sql);
echo "<select name=\"select\">\n";
while($zeile = mysql_fetch_array($result)){
?>

<table border="1">
<tr>
<th>id</th>
<th>name</th>
</tr>
<tr>
<td><?php echo $zeile['id']; ?>
<td>row 1, cell 2</td>
</tr>
<tr>
<td><?php echo $zeile['member_name']; ?>
<td>row 2, cell 2</td>
</tr>
</table>

<?php
}
?>

now i habve to edit this bit of the code yes ?

echo "<select name=\"select\">\n";

[kfcSmitty]

Anything between theses 2 lines will repeat for the # of records you have.

while($zeile = mysql_fetch_array($result)){
?>

and

<?php
}
?>

So #1, you still need to remove your select and
#2 You will be printing out a table over and over again, not to mention you're missing tags after your php output.

Please attempt running your code, when seeing the output you should be able to troubleshoot what you're doing easier. I am here to help guide you, not walk you through this step by step.

[sttc2]

i have test its in text but the tables are beying repeated after every member that registers but i think i can do this now =]

[sttc2]

iv tryed the funchtion print but nothing come up

[sttc2]

well i cant do it but thanks for the info

[kfcSmitty]

Can't do what? What you're looking to do is a simple task.

[sttc2]

with i cant do i only been doing this 2 weeks

[kfcSmitty]

If you follow the links I've given you, you should be able to figure out what you're doing.

Here is also a php/mysql tutorial that may give you some hints as well:

http://www.w3schools.com/php/php_mysql_intro.asp

[sttc2]

i did it thank you