Why is this loop blowing up?

[wickedneat]

I have the following code. What I'm trying to make it do is create a table that shows all the usersnames in this databases, and display each username in a seperate row of a table. Then I'm wanting to have different columns in that row, and display variables which are numbers in the database for each individual added together. I tried using the following code but I get the error message:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

<?php
mysql_connect($db_host, $db_user, $db_pwd); 

mysql_select_db($db_name); 

$sql = "SELECT * FROM authorize AS u_one INNER JOIN authorize AS u_all ON u_all.department IN ( u_one.department , u_one.department2 , u_one.department3 , u_one.department4 , u_one.department5 , u_one.department6 ) WHERE u_one.username = '$_SESSION[user_name]' AND NOT u_all.lockedstatus = 'LOCKED'"; 
$result = mysql_query($sql); 
while($row = mysql_fetch_array($result))
  {
echo '<tr><td>' . username. '</td><td> <tr><td>' . $total . '</td><td>';  
  
  }

mysql_close($con);
?>

[logic_earth]

well clearly you are trying to use a socket to connect to the MySQL server which does not allow that means to connect.

[wickedneat]

logic_earth, I'm sorry but I have no idea what you mean by that.

[stampyhead]

That error means that the script can't connect to your database. Do you have those variables at the beginning of the script defined somewhere? Those are used to connect to the db.
I'm talking about this line:

mysql_connect($db_host, $db_user, $db_pwd); 

[wickedneat]

Yes, They are in my script at the heading.

[Jake Arkinstall]

Are you sure that they're correct?

Apart from that, I can tell you that the following line is incorrect:

echo '<tr><td>' . username. '</td><td> <tr><td>' . $total . '</td><td>'; 

Try:

echo '<tr><td>' . $row['username']. '</td><td> <tr><td>' . $row['total'] . '</td><td>'; 

[wickedneat]

still get same error

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[_Steve_]

cd /usr/local/mysql
./bin/mysqld_safe --user=mysql &

[logic_earth]

What is contained in "$db_host".

I also told you the problem you cannot connect to the mysql database using sockets.

hence the error message " Can't connect to local MySQL server through socket"

[Wardrop]

Are you sure that they're correct?

Apart from that, I can tell you that the following line is incorrect:

echo '<tr><td>' . username. '</td><td> <tr><td>' . $total . '</td><td>'; 

Try:

echo '<tr><td>' . $row['username']. '</td><td> <tr><td>' . $row['total'] . '</td><td>'; 

What's with the <tr> tags? for example...

<tr><td>data1</td><td><tr><td>data2</td><td>

That's not a valid table row. You can't have <tr> tags directly under <td> tags. Not only that, but the rest of your table is a mess also (not you arkinstall, although your 'fix' still includes the table problems, hence the quote).

[lorenw]

not sure about the socket thing but have you defined the variables

$db_host = 'localhost';
$db_user = 'me';
$db_pwd = 'mypass';

[wickedneat]

I've defined my variables. I'm still having thesee problems

[TheRedDevil]

As logic_earth has mentioned two times already, the problem is that you can not connect to a mysql server at the address you have given it.

This either means that there is no mysql server at localhost, that it use a different socket filename than "localhost" or that you need to connect to it through TCP/IP.

Check out the MySQL documentation for more information:
http://dev.mysql.com/doc/refman/5.0/...to-server.html

[wickedneat]

It's no longer displaying the error:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

However, it's not displaying any error or output at all. Just shows a blank page.

[wickedneat]

Well I got the data to print out now. It's just not in table format it looks like a big paragraph of data.

[wickedneat]

username | Reg | O/T | Reg | O/T | Reg | O/T | Reg | O/T | Reg | O/T | Reg | O/T | Reg | O/T | Reg |O/T

The above represents a row in the table the| starts a new column. That's how I need the data to be presented.