Help Tutorials: Membership

[ParanoID87]

Hello all, sorry for my bad english!

Well, i just made the membership tutorials, all is working and very nice tutorials !

But how can i call like the user username, or other info i added like like the phone number.. in my database in the member page ?

I tried all my best to find a way, but i`m new in php//mysql and nothing have worked ! So if you can help me a little bit !

Thnx you very much !!

[ConceptualMind]

PM scrowler if you want an immediate response. He's the creator of the membership tutorial.

Unfortunately I don't know php well so I don't help you. If scrowler isn't available, PM Order. He's another php guru.

[ParanoID87]

oki thnx you !

[scrowler]

if you have a column in your mysql database/table that is in the same table as the username password etc, you can use the following code to retrieve the data in the column named "PhoneNumber"

<?
# assume already connected to mysql server/database
$query = mysql_query("SELECT * FROM YourTableName") or die(mysql_error());
while($row = mysql_fetch_array($query)){

// process your data, each row will be in variable: $row['PhoneNumber'];

}
?>

every time it loops through a row in the table, $row['PhoneNumber'] will be different. you can either echo is each time to output every phone number, it only retrieve one... etc.

hope this helps

[ParaSnake]

Let me make scrowler`s script more useful for you then:

PHP Code:

<?
//connect to the database
//for example you have 3 fields are username,phone,password in ur table name member
//heres the query
$query = mysql_query("SELECT * FROM member") or die(mysql_error());
//use this to determine if there is no data in table member yet.
if(mysql_num_rows($query)==0) {  
  echo "Problem,theres no data.";
  exit();
}
//use while loop to gain data
while($row = mysql_fetch_array($query)){
         echo $row[username]."--".$row[phone];
         echo "<BR>";
}
//final result will display like
//name1--phone1
//name2--phone2
//ect...
?>

Hope you get it man,i`m bad at English to