syntax error, unexpected T VARIABLE

[scott815]

I am new to php and trying to learn. Got error message below on code below.

Parse error: syntax error, unexpected T_VARIABLE in /home2/ytbvacat/public_html/includes/common.inc(1355) : eval()'d code on line 5

<?php
mysql_connect("localhost", "#*$!xx", "#*$!xx") or die(mysql_error()); //mysql_connect ($server,$username,$password )
mysql_select_db("#*$!#*$!xx") // this should go after mysql_connect

$test = 'SELECT COUNT(*) AS `Rows`, `field_rental_state_value` FROM `content_type_vacation_rental` GROUP BY `field_rental_state_value` ORDER BY `field_rental_state_value` LIMIT 0, 30 ';
$result = mysql_query($test);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Count :" . $row['Rows'] . "<br>" . "field_rental_state_value : " . $row['field_rental_state_value']. " <br>" .
}
?>

[eelixduppy]

You are missing a semi-colon at the end of the following line:

echo "Count :" . $row['Rows'] . "<br>" . "field_rental_state_value : " . $row['field_rental_state_value']. " <br>"[b];[/b]

And Welcome to WebmasterWorld! :)

[scott815]

Thanks for the help but now i get another error says I have same error on line five. See line five below.

$test = 'SELECT COUNT(*) AS `Rows`, `field_rental_state_value` FROM `content_type_vacation_rental` GROUP BY `field_rental_state_value` ORDER BY `field_rental_state_value` LIMIT 0, 30 ';

[eelixduppy]

Sorry I missed this one. You are also missing a semi-colon after this line:

mysql_select_db("#*$!#*$!xx");

[grallis]

Often if you get a warning or error on a specific line, the error actually lies in the line above that line, so check this line out -
mysql_select_db("#*$!#*$!xx") ... no semicolon there either.

Also, try using double quotes for queries - it makes things easier for creating dynamic queries :)

[grallis]

Damn, shouldnt have answered the phone :P

[scott815]

Thank you for all the help.