[RESOLVED] Silly Parse error

lilRachie

:eek:

Ok here is my code for manu.php

<?
include('connect.php');

$query = "SELECT * FROM `member` ORDER BY `user_name`";
if($result = mysql_query($query)) {
    while($row = mysql_fetch_array($result)){

print "<tr><td> </td><td align=right><a href=sendmail.php?user_name=".$row['user_name'].">SendMail</a> | <a href=terminateuser.php?user_name=".$row['user_name'].">Terminate</a></td></tr><tr><td width=200>User name</td><td>".$row['user_name']."</td></tr><tr><td>Email</td><td>".$row['user_email']."</td></tr><tr><td>IP address</td><td>".$row['user_ip']." </td></tr><tr><td>Domain listed</td><td>";

$query2 = "SELECT * FROM `domain_list` WHERE `user_name` = '$row['user_name']'";//this is line 10
$sql = mysql_query($query2);
$NumRow = mysql_num_rows($sql);

print "<a href=memberdn.php?user_name=".$row['user_name']."> ".$NumRow."</a></td></tr>";
		}// end while
}// end if

?>

Looks great no spaces no missing quotes. Here is my error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/url/public_html/folder/folder2/admin/manu.php on line 10

Seriously no idea why I'm getting this.

Help

LilRachie 😕

NogDog

It's an idiosyncrasy of PHP: if you want to use an associative array variable with a quoted key within a double-quoted string (or heredoc string), you need to wrap it in curly braces so that the parser does not get confused (referred to as "complex" notation):

$string = "foo {$array['key']} bar";

lilRachie

Ok that fixed that part, but now a new error

manu.php

<?
include('connect.php');

$query = "SELECT * FROM `member` ORDER BY `user_name`";
if($result = mysql_query($query)) {
    while($row = mysql_fetch_array($result)){

print "<tr><td bgcolor=#00FFFF> </td><td align=right bgcolor=#00FFFF><a href=sendmail.php?user_name=".$row['user_name'].">SendMail</a> | <a href=terminateuser.php?user_name=".$row['user_name'].">Terminate</a></td></tr><tr><td width=200>User name</td><td>".$row['user_name']."</td></tr><tr><td>Email</td><td>".$row['user_email']."</td></tr><tr><td>IP address</td><td>".$row['user_ip']." </td></tr><tr><td>Number of Domains listed</td><td>";

$sql = "SELECT * FROM `domain_list` WHERE `user_name` = {$row['user_name']}";
$ExecuteQuery = mysql_query($sql) or die('Query failed: ' . mysql_error() . "<br />\n$sql");
$rcount = mysql_num_rows($ExecuteQuery);

print "<a href=memberdn.php?user_name=".$row['user_name']."> ".$rcount."</a></td></tr>";
		}// end while
}// end if

?>

was getting a count error so I added " or die('Query failed: ' . mysql_error() . "<br />\n$sql");"
so now it says:

Query failed: Unknown column 'user1' in 'where clause'
SELECT * FROM domain_list WHERE user_name = user1

the $sql is correct.

$rcount = mysql_num_rows($ExecuteQuery);

isn't counting the times user1 is in the user_name field of table.

:quiet:

NogDog

In SQL you need to quote a literal string value, so you would need:

$sql = "SELECT * FROM `domain_list` WHERE `user_name` = '{$row['user_name']}'";

If all those quotes, brackets, and variables start to drive you nuts, you can use [man]sprintf/man to separate things a bit:

$sql = sprintf(
   "SELECT * FROM `domain_list` WHERE `user_name` = '&#37;s'",
   $row['user_name']
);

lilRachie

WOO Thank you. That did it.😃:o

Thanks
lilRachie