|
|
Posted by Decadre on 09/28/72 11:44
Hmm, just noticed that it only does it when viewing the page through
Firefox.
It's fine in IE.
"Decadre" <rogue_3d@hotmail.com> wrote in message
news:q6gZf.14817$cY3.14429@news-wrt-01.rdc-nyc.rr.com...
> I'm attempting to add some content to a site I'm tooling around with for
> experience basically. I startes dabbling with php just recently. The web
> host that I have has mysql space available to me, so I created a DB. I
> then got this code from them that retrieves a queries and prints the data
> on my site in a table.
>
> What it's doing that has me puzzled is that it seems the data in the table
> is cycling from visible to not visible. Below is the code that I got from
> my webhost, and I left the variables such as user, password, etc the way
> they had it so I don't give away anything. Oh the query I'm runing is
> different, but I don't think that has any effect on what's happening.
>
> here's the site where I have the code.
> http://www.decadre.com/games/eq2Collect.php
> <?php
> /* Start of PHP3 Script */
> /* Data of SQL-server */
> $server= "db1.perfora.net"; /* Address of 1&1 database server
> */
> $user= "xxxxxx"; /* Database username */
> $password= "yyyyyyy"; /* Database Password */
> $database= "dbxxxxxx"; /* name of database */
> $table= "puretest"; /* Name of table, you can
> select that */
>
> /* Accessing SQL-Server and querying table */
> MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server
> unreachable</H3>");
> MYSQL_SELECT_DB($database) or die ( "<H3>Database non
> existent</H3>");
> $result=MYSQL_QUERY( "SELECT * FROM $table order by name");
>
> /* Output data into a HTMl table */
> echo "<table border=\"1\" align=center width=50%";
> echo "<tr>";
> echo "<div color=\"#ffff00\">";
> while ($field=mysql_fetch_field($result)) {
> echo "<th>$field->name</A></th>";
> }
> echo "</font></tr>";
> while($row = mysql_fetch_row($result)) {
> echo "<tr>";
> for($i=0; $i < mysql_num_fields($result); $i++) {
> echo "<td align=center>$row[$i]</td>";
> }
> echo "</tr>\n";
> }
> echo "</table><BR><BR>";
>
> /* Close SQL-connection */
> MYSQL_CLOSE();
> ?>
>
Navigation:
[Reply to this message]
|