Unholy Prayer Posted August 17, 2006 Share Posted August 17, 2006 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. Quote Link to comment Share on other sites More sharing options...
Jeremysr Posted August 17, 2006 Share Posted August 17, 2006 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. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Going to need a few lines around line 4. Php syntax errors are not line accurate. Quote Link to comment Share on other sites More sharing options...
Unholy Prayer Posted August 17, 2006 Author Share Posted August 17, 2006 This is the whole page:[code]<?phprequire_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. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Your missing the colon from the end of your only echo() line. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 And also from the require_once() line. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Jeremysr, a simple yes / no. Do you understand the meaning of your (our) avitar? Quote Link to comment Share on other sites More sharing options...
Unholy Prayer Posted August 17, 2006 Author Share Posted August 17, 2006 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? Quote Link to comment Share on other sites More sharing options...
Jeremysr Posted August 17, 2006 Share Posted August 17, 2006 [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. Quote Link to comment Share on other sites More sharing options...
Unholy Prayer Posted August 17, 2006 Author Share Posted August 17, 2006 Oh, silly me. I was thinking of : instead of ; Lol. I am officially embarressed. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 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]<?phprequire_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] Quote Link to comment Share on other sites More sharing options...
Unholy Prayer Posted August 17, 2006 Author Share Posted August 17, 2006 Ok, there's no error now, but it's not displaying anything... Here it is:http://www.mutant-designs.com/programs/index.phpNote: 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. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 You never check to see if your query actually works before using it. Get in the habbit.[code=php:0]<?phprequire_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] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.