jeffshen Posted August 8, 2006 Share Posted August 8, 2006 Hey all,I've written this piece of code and an error is coming up as:Parse error: parse error, unexpected T_VARIABLE in /var/www/html/stocks/test.php on line 21I've tried googling the topic and see that its something to do with missing punctuation... but I cant find the mistake... can someone please help?[code]1 <table border="1" cellspacing="2" cellpadding="2"> <tr> <th><font face="Arial, Helvetica, sans-serif">Symbol</font></th> <th><font face="Arial, Helvetica, sans-serif">Name</font></th>5 <th><font face="Arial, Helvetica, sans-serif">Time</font></th> <th><font face="Arial, Helvetica, sans-serif">Date</font></th> <th><font face="Arial, Helvetica, sans-serif">Last</font></th> <th><font face="Arial, Helvetica, sans-serif">Change</font></th> <th><font face="Arial, Helvetica, sans-serif">High</font></th>10 <th><font face="Arial, Helvetica, sans-serif">Low</font></th> </tr> <?php 15 //Connect to MySQL Database include("login.php"); mysql_connect("localhost",$username,$password); @mysql_select_db($database or die("Unable to select database") 20 //Select All Records from Stocks Database $query = "SELECT * FROM stocks"; $result = mysql_query($query); //returns the row of the MySQL Query25 $row = mysql_num_rows($result); $i = 0 //Selects the Stock Code of the Stock $asking = mysql_result($result,$i,"code")30 //add .hk to the end of the stocknumber, required for Yahoo! Finance $standard = ".hk"; //Put the two together to allow one stock number with .hk at the end for YahoO!35 $findquote = "$asking$standard"; //Connects to Yahoo! and retrives the records from Yahoo!'s database Class yahoo {40 function get_stock_quote($symbol) { $url = sprintf("http://finance.yahoo.com/d/quotes.csv?s=%s&f=snl1d1t1c1ohgv" ,$symbol); $fp = fopen($url, "r"); if(!fp)45 { echo "error : cannot recieve stock quote information"; } else {50 $array = fgetcsv($fp , 4096 , ', '); fclose($fp); $this->symbol = $array[0]; $this->name = $array[1]; $this->last = $array[2];55 $this->date = $array[3]; $this->time = $array[4]; $this->change = $array[5]; $this->open = $array[6]; $this->high = $array[7];60 $this->low = $array[8]; $this->volume = $array[9]; } } }65 //loop the function for multiple database entries while ($i < $row) { //Executes the script for the records retrival70 $quote = new yahoo; $quote->get_stock_quote("$findquote"); ?> //Print the information into a tabular format75 <tr> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->symbol"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->name"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->time"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->date"; ?></font></td>80 <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->last"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->change"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->high"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$quote->low"; ?></font></td>85 </tr> </table> <?90 ++$i ?>[/code]Thanks,Jeff Link to comment Share on other sites More sharing options...
ToonMariner Posted August 8, 2006 Share Posted August 8, 2006 only probelsm i can see there are missing ';' //returns the row of the MySQL Query25 $row = mysql_num_rows($result); $i = 0; //HERE //Selects the Stock Code of the Stock $asking = mysql_result($result,$i,"code"); // HERE30 <?90 ++$i; // HERE ?>ALSO Good practice NOT to use short tags (<?) for php use <?php instead..... Link to comment Share on other sites More sharing options...
jeffshen Posted August 8, 2006 Author Share Posted August 8, 2006 Thank you for pointing out my silly mistakes, however the problem on line 21 still exists... Can anyone spot the error please?Thanks a lot,Jeff Link to comment Share on other sites More sharing options...
zq29 Posted August 8, 2006 Share Posted August 8, 2006 [code]15 //Connect to MySQL Database include("login.php"); mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die("Unable to select database");[/code] Link to comment Share on other sites More sharing options...
jeffshen Posted August 8, 2006 Author Share Posted August 8, 2006 HeyThanks for yet spotting another silly mistake... however it still states that Parse error: parse error, unexpected T_VARIABLE in /var/www/html/stocks/test.php on line 21Thanks,Jeff Link to comment Share on other sites More sharing options...
Orio Posted August 8, 2006 Share Posted August 8, 2006 Can you post the script after the first fixes?Orio. Link to comment Share on other sites More sharing options...
jeffshen Posted August 8, 2006 Author Share Posted August 8, 2006 Hey all,I found the mistake at like 18, I forgot the ) and ; 15 //Connect to MySQL Database include("login.php"); mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die("Unable to select database"); <-- ) after $datavase and ; wasnt in the original scriptThanks a lot for everybody's prompt reply,Jeff Link to comment Share on other sites More sharing options...
Recommended Posts