Jump to content

Archived

This topic is now archived and is closed to further replies.

Unholy Prayer

Unexpected T VARIABLE?

Recommended Posts

Ok, I am trying to make an affiliates management program, but I keep getting this error on the index display page... here it is:
[code]Parse error: syntax error, unexpected T_VARIABLE in /home/mutantde/public_html/programs/index.php on line 4[/code]

This is line 4:
[code]$result = mysql_query("SELECT * from affiliates");[/code]

This is probably a noob question, but this is my first PHP program so I guess I am a PHP Noob.

Thanks in advance for the help.

Share this post


Link to post
Share on other sites
I don't see anything wrong with it, but it might be the line above or below line 4...I think if you missed a semi-colon on line 3 it'd say that it is an error on line 4.

Share this post


Link to post
Share on other sites
Going to need a few lines around line 4. Php syntax errors are not line accurate.

Share this post


Link to post
Share on other sites
This is the whole page:
[code]<?php
require_once('database.php')

$result = mysql_query("SELECT * from affiliates");

while($r=mysql_fetch_array($result))
{  
  $site_name=$r["site_name"];
  $site_url=$r["site_url"];
  $banner_url=$r["banner_url"];
  echo "<a href='$site_url' target='new'><img src='$banner_url' width='88' height='31'></a>"
}
?>[/code]

I know... not that much coding, right?  But hey, with a PHP noob like me, this kind of stuff is expected.

Share this post


Link to post
Share on other sites
Your missing the colon from the end of your only echo() line.

Share this post


Link to post
Share on other sites
And also from the require_once() line.

Share this post


Link to post
Share on other sites
Jeremysr, a simple yes / no. Do you understand the meaning of your (our) avitar?

Share this post


Link to post
Share on other sites
Ok, that's wierd because semicolons have never been a problem in my other scripts in both the require_once() and echo lines.  Where exactly do I put them?  Just at the end?

Share this post


Link to post
Share on other sites
[quote author=thorpe link=topic=104587.msg417245#msg417245 date=1155795777]
Jeremysr, a simple yes / no. Do you understand the meaning of your (our) avitar?
[/quote]

Yes. I read the "How to be a Hacker" article and the emblem faqs.

And Unholy Prayer, semi-colons signify the end of a line.

Share this post


Link to post
Share on other sites
Jeremysr, cool. I have the book.

[quote]that's wierd because semicolons have never been a problem in my other scripts[/quote]

You should have... there are a required part of php synatx.

Yes, you'll need them at the end.
[code=php:0]
<?php
require_once('database.php');

$result = mysql_query("SELECT * from affiliates");

while($r=mysql_fetch_array($result))
{  
  $site_name=$r["site_name"];
  $site_url=$r["site_url"];
  $banner_url=$r["banner_url"];
  echo "<a href='$site_url' target='new'><img src='$banner_url' width='88' height='31'></a>";
}
?>
[/code]

Share this post


Link to post
Share on other sites
Ok, there's no error now, but it's not displaying anything...  Here it is:
http://www.mutant-designs.com/programs/index.php

Note:  That is the correct URL, I just forgot to add the "affiliates" directory and put all the files in it.  I'll get to it when I'm done with the program.

Share this post


Link to post
Share on other sites
You never check to see if your query actually works before using it. Get in the habbit.

[code=php:0]
<?php
require_once('database.php');

if ($result = mysql_query("SELECT * from affiliates")) {
  while($r=mysql_fetch_array($result))
    $site_name=$r["site_name"];
    $site_url=$r["site_url"];
    $banner_url=$r["banner_url"];
    echo "<a href='$site_url' target='new'><img src='$banner_url' width='88' height='31'></a>";
  }
} else {
  echo "query failed ".mysql_error();
}
?>
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.