[HELP] PHP Code

[Kazco]

Hey HxF users!

I have this code, and it seems to be giving me an error.

Here's the full code (it isn't mine, its off techtuts).


<?php
$base_host = "localhost"; # your sql host (usualy 'localhost')
$base_name = "your_database_name"; # your database name
$base_user = "your_database_user"; # your database username
$base_pass = "your_database_password"; # your database password
$base_table= "banners"; # the table your going to use?

# Connect to the database
$db = mysql_connect($base_host,$base_user,$base_pass); # connect to the database
mysql_select_db ($base_name) or die ("Cannot connect to database"); # or die (if theres a problem it will echo, cannot connect to the database.

$query = mysql_query("select * from ".$base_table.""); # SQL query
$total = mysql_num_rows($query); # count up all the rows in the table
$query = mysql_query("select * from ".$base_table.""); # SQL query
$total = mysql_num_rows($query); # count up all the rows in the table
$random = (rand()%$total); # Create a random number
$query = mysql_query("SELECT * FROM ".$db_table." LIMIT $random, 1"); # Retrieve the random banner from the database.
{ # echo the query
echo"<a href="$row->addr" target="_blank" title="$row->text"><img src="$row->ban_image" alt="$row->text" width="468" height="60"></a>";
$view = $row->views + 1; # update the times viewed
mysql_query("update ".$base_table." set views = $view where id = $row->"id"); # another query
} # close while()
?>I'm getting the error on this line:


echo"<a href="$row->addr" target="_blank" title="$row->text"><img src="$row->ban_image" alt="$row->text" width="468" height="60"></a>";Any help would be appreciated, thanks.

[DeejayMachoo$]

echo"<a href=\"$row->addr\" target=\"_blank\" title=\"$row->text\"><img src=\"$row->ban_image\" alt="\$row->text\" width=\"468\" height=\"60\"></a>";

[Kazco]

echo"<a href=\"$row->addr\" target=\"_blank\" title=\"$row->text\"><img src=\"$row->ban_image\" alt="\$row->text\" width=\"468\" height=\"60\"></a>";


Nope, still errors.

Any other ideas?

This is the error code I get:

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /home/habtownn/public_html/Banner/bannner.php on line 19

[Tomm]

echo"<a href=\"$row->addr\" target=\"_blank\" title=\"$row->text\"><img src=\"$row->ban_image\" alt=\"$row->text\" width=\"468\" height=\"60\"></a>";

[Kazco]

echo"<a href=\"$row->addr\" target=\"_blank\" title=\"$row->text\"><img src=\"$row->ban_image\" alt=\"$row->text\" width=\"468\" height=\"60\"></a>";


Thanks..

However now I'm getting this line error'd.


mysql_query("update ".$base_table." set views = $view where id = $row->"id"); # another query

[Beau]

Urgh, can I suggest you use upper case for SQL functions? eg. SELECT, ALTER, UPDATE. Makes reading code a lot easier.



mysql_query("UPDATE $base_table SET views='$view' WHERE id='{$row->"id"}'"); # another query
Should work.