Posted by plato on 10/13/75 11:27

"Tim Streater" <tim.streater@dante.org.uk> wrote in message
news:tim.streater-3C69F9.12100522092005@individual.net...
> In article <433287e7@news.rivernet.com.au>,
> "plato" <platoTAKETHISOUT@telpacific.com.au> wrote:
>
>
> [trillions of copies of unnecessary stuff deleted]
>
> > I followed your advice and have created the table :courses and inserted
2
> > fields course and places and populated them with course 1 and 11 places
> > (integer) and course 2 and 15 places (integer) running this script:
> >
> > <?PHP
> >
> > //alter you variables here
> > $host = "localhost";
> > $username="";
> > $password="";
> > $database="paul";
> >
> > // create link to database
> > $link = mysql_connect($host, $username, $password)
> > or die("Cannot connect to database");
> >
> > mysql_select_db($database)
> > or die("Cannot select database");
> >
> > //now we make the query which will ask the database for the course
> > information
> > //change the my_table to your course table name
> >
> > $query = "SELECT course,places FROM courses";
> > $result = mysql_query($query)
> > or die("Query cannot be executed");
> >
> > //now we are going to print the information to your screen
> > while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
> > printf ("course: %s places: %s<br>", $row['course'],
> > $row['places']);
> > }
> > ?>
> >
> > Still getting this error:
> >
> > Parse error: syntax error, unexpected T_VARIABLE in
c:\wamp\www\Untitled.php
> > on line 20
> >
> > but I can't see anything wrong with that line??
>
> There's nothing wrong syntactically with line 20. Its line 17 that's the
> problem. What's PHP supposed to do with the word "information" sitting
> there all by itself?
>
> -- tim

You're a bloody genius Tim thanks

[Back to original message]