[RESOLVED] Syntax problems - new coder

dj2ball

I'm attempting to write some code to a MySQL database on my server, but am getting the following error:

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /path/beta.php on line 82

My code is as follows:

<?php 
mysql_connect ("localhost", "username", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("carparki_comp");

include('search.php');
	$twitter_query= ('#competiton');
	$search = new TwitterSearch($twitter_query);
	$results = $search->results();
	$counter=1;


foreach($results as $result){
	if($counter==1) {
		echo '<div class="twitter_status">';
		echo '<img src="'.$result->profile_image_url.'" class="twitter_image">';
		$text_n=toLink($result->text);
		echo $text_n;
		echo '<div class="twitter_small">';
		echo '<strong>From:</strong> <a href="http://www.twitter.com/'.$result->from_user.'">'.$result->from_user.'</a>: ';
		echo '<strong>at:</strong> '.$result->created_at;
		echo '</div>';
		echo '</div>';
		mysql_query("INSERT INTO Tweets (ID, username, message, created_at)VALUES ('NULL','.$result->from_user.', '.$result->text', '.$result->created_at')");
		echo "Database Updated with: "$result->from_user. " "$result->text" "$result->created_at;
		$counter=-0;
}
else {
echo '<div class="twitter_status_alt">';
		echo '<img src="'.$result->profile_image_url.'" class="twitter_image">';
		$text_n=toLink($result->text);
		echo $text_n;
		echo '<div class="twitter_small">';
		echo '<strong>From:</strong> <a href="http://www.twitter.com/'.$result->from_user.'">'.$result->from_user.'</a>: ';
		echo '<strong>at:</strong> '.$result->created_at;
		echo '</div>';
		echo '</div>';
		$counter=1;
}
}
?>

TenaciousC

There doesn't appear to be anything wrong with this code at first, but is there more? It says the line 82, but there's only 40 some odd lines of code here.

TenaciousC

Scratch what I just said.

echo "Database Updated with: "$result->from_user. " "$result->text" "$result->created_at;

You forgot to separate the variables from the string with dots.

echo "Database Updated with: ".$result->from_user. " ".$result->text."  ".$result->created_at;

dj2ball

Just a bunch of CSS. Will pase the whole file though:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Beta</title>
<style type="text/css">
.woork{
	color:#444;
	font-family:"Lucida Grande", "Lucida Sans Unicode", Verdana, Arial, Helvetica, sans-serif;
	font-size:10px;
	width:600px;
	margin: 0 auto;
}
.twitter_container{
	color:#444;
	font-family:"Lucida Grande", "Lucida Sans Unicode", Verdana, Arial, Helvetica, sans-serif;
	font-size:10px;
	width:450px;
	margin: 0 auto;
}

.twitter_container a{
	color:#0066CC;
}
.twitter_status{
	height:60px;
	padding:6px 6px 6px 6px;
	border-bottom:solid 1px #DEDEDE;
}
.twitter_status_alt{
	height:60px;
	padding:6px 6px 6px 6px;
	background-color: #f2f2f2;
	border-bottom:solid 1px #DEDEDE;
}
.twitter_image{
	float:left; 
	margin-right:14px;
	border:solid 2px #DEDEDE;
	width:25px;
	height:25px;
}
.twitter_small{
 font-size:9px;
 padding-top:4px;
 color:#999;
}
</style>
</head>

<body>
<div class="twitter_container">
<strong>Proof of concept</strong><br />

<br/>
<p>
<?php 
mysql_connect ("localhost", "user", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("db_name");

include('search.php');
	$twitter_query= ('#competiton');
	$search = new TwitterSearch($twitter_query);
	$results = $search->results();
	$counter=1;


foreach($results as $result){
	if($counter==1) {
		echo '<div class="twitter_status">';
		echo '<img src="'.$result->profile_image_url.'" class="twitter_image">';
		$text_n=toLink($result->text);
		echo $text_n;
		echo '<div class="twitter_small">';
		echo '<strong>From:</strong> <a href="http://www.twitter.com/'.$result->from_user.'">'.$result->from_user.'</a>: ';
		echo '<strong>at:</strong> '.$result->created_at;
		echo '</div>';
		echo '</div>';
		mysql_query("INSERT INTO Tweets (ID, username, message, created_at)VALUES ('NULL','.$result->from_user.', '.$result->text', '.$result->created_at')");
		echo "Database Updated with: "$result->from_user. " "$result->text" "$result->created_at;
		$counter=-0;
}
else {
echo '<div class="twitter_status_alt">';
		echo '<img src="'.$result->profile_image_url.'" class="twitter_image">';
		$text_n=toLink($result->text);
		echo $text_n;
		echo '<div class="twitter_small">';
		echo '<strong>From:</strong> <a href="http://www.twitter.com/'.$result->from_user.'">'.$result->from_user.'</a>: ';
		echo '<strong>at:</strong> '.$result->created_at;
		echo '</div>';
		echo '</div>';
		$counter=1;
}
}
?>
</div>
</body>
</html>

dj2ball

TenaciousC;10942248 wrote:
Scratch what I just said.
echo "Database Updated with: "$result->from_user. " "$result->text" "$result->created_at;
You forgot to separate the variables from the string with dots.
echo "Database Updated with: ".$result->from_user. " ".$result->text."  ".$result->created_at;

Brilliant, thanks a ton!

TenaciousC

There are some IDEs out there that will automatically detect parsing errors in your code like that. I use Eclipse PDT, which has that as one of it's many features. You may want to look into something like that.

bradgrafelman

Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

Don't forget to mark this thread resolved (using the link under the Thread Tools menu) if it is!

P.S. Welcome to PHPBuilder! 🙂

dj2ball

cheers for the help and thanks for the tip on the tags 🙂