[mhs12grade1992]

Hello everybody!!

I have discussed some of you about my problems with database. I did INSERT INTO and CREATE TABLE that worked. But I did have problem with SELECT FROM. It always show "Array" using print and echo. Someone from here told me to use print_r($rows); and I could not get it to work. Let me tell you what.... Dummies showed me how to make it work.


$query = 'SELECT * FROM members';
include("./connect.php");
mysql_select_db(DB_NAME) or die(mysql_error());
$result=mysql_query($query);
$rows=mysql_fetch_assoc($result);
print_r($rows['username']);
mysql_close();

You must specific name into $rows['name'] in order to show real array. Otherwise it will show PHP codes.

Trust me. It works!
Now I am through.... !

You know what? Yahooooooooooo!!!!!!!!!!!!!! I am passed! I am A+

[NeverMind]

sorry to tell you, but that's not A+! I'd say D
when you specify $row['field_name'], you don't need to print_r() just echo/print()!
print_r() is used to print all the array elements in the form:

Code:

Array
(
    [filed_name] => value
)

print_r() is used for debugging ..
but we told you to use it since you constantly refused to read tuts before trying to use mysql's function..
also your code (above) only prints the first row and neglicates the others because it doesn't have a loop..
again, you refuse to read tuts to learn how to use MySQL..
no offense, but I am trying to tell you that you should learn before your attempt to use ..
it's like buying a complicated device and attempting to make it work without reading it's manual! it might work with you but it will malfunction for sure..

[mhs12grade1992]

Now $rows['username'] is no longer work. I tried echo, print and print_r but won't work on that array. Now I recommend to use $rows[0] as username as first column. You just said to use echo and print. Yup, it works. $rows[0] works better. I don't understand ...... $rows['username'] worked before it died. I follow Dummies book about that but it is wrong.

Look, Nevermind, I did read all through the book and I noticed few parts of the book are wrong. Very few and that author did forget something in PHP book. Now I do know how to solve the problem.

I know Bravenet does not work good. Yahoo! works fine. It is important that I learn MySQL and I have learned and often get them wrong. I read Dummies (Jeff Cogswell) and PHP and MySQL (Larry Ullman) books.

You assumed I refuse to read tutorials but you're wrong.