[RESOLVED] connecting to db

[darko886]

Hello, I have a database called "darko886_table" and a table inside labeled 'table'. I want on my website for it to make an actual table with the info from 'table' and I want it to be in descending order of the field 'Pts'. So this is the script I have come up with and it just shows a black page. I will also include my database file.

<?

<br />
include("database.php");
$query = mysql_query("SELECT * FROM table");
$query = mysql_query

("SELECT * FROM `table` ORDER BY `Pts` DESC LIMIT 0 , 8"); 
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {
echo "This is my field: ".$row[fieldname].";
}
?>

and this is the database.php

<?php
$host = "supremecenter47.com";
$username = "darko886_table";
$password = "mypassword";
$dbname = "darko886_table";
mysql_connect("$host", "$username", "$password") or die(mysql_error());
echo "Connected to Server.";
mysql_select_db("$dbname") or die(mysql_error());
echo "Connected to Database";
?>

With those two the page resulting is http://premierpes.com/table.php
a blank page....

Can someone pleeeeeeeeeeeasseeee help me

Thanks
Darko

[cgraz]

First change <? to <?php

What's likely going on is you're getting a parse error, but your server is set to not display errors, so you just get a blank page. So add this to the top of your script after the PHP tags

// set the error_reporting level
error_reporting( E_ALL ^ E_NOTICE );
ini_set('display_errors', 1);

Now reload the page and you'll likely get a parse error along with a line number. I would guess the problem is occurring at the end of the first file you posted

echo "This is my field: ".$row[fieldname].";

should be

echo "This is my field: ".$row[fieldname];

There may be more, but this is the only error that really stood out to me at first glance.

As a sidenote: you don't need quotes surrounding the variables here

mysql_connect("$host", "$username", "$password") or die(mysql_error());

[Pooptart]

To me, it seems the problem is that he isnt even connected to the server.
He has is it set so when he is connected, it should
echo "Connected to Server.";
echo "Connected to Database";

but it doesnt.

[darko886]

Thanks, but that code didnt show up an error it was still blank and when I changed what you recommended the page is still blank... Here is the new code:

<?php

// set the error_reporting level
error_reporting( E_ALL ^ E_NOTICE );
ini_set('display_errors', 1);

<br />
include("database.php");
$query = mysql_query("SELECT * FROM table");
$query = mysql_query

("SELECT * FROM `table` ORDER BY `Pts` DESC LIMIT 0 , 8"); 
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {
echo "This is my field: ".$row[fieldname]; 

}
?>

[darko886]

actually i decided to get a whole new code, now i get an error 🙂

the code is

<?php 
$database="darko886_table"; 
mysql_connect ("supremecenter47.com", "darko886_table", "nikonezna"); 
@mysql_select_db($database) or die( "Unable to select database"); 
$result = mysql_query( "SELECT * FROM table" ) 
or die("SELECT Error: ".mysql_error()); 
$num_rows = mysql_num_rows($result); 
echo "There are $num_rows records.<P>"; 
echo "<table width=400 border=1>\n"; 
while ($get_info = mysql_fetch_row($result)){ 
echo "<tr>\n"; 
foreach ($get_info as $field) 
echo "\t<td><font face=arial size=1/>$field</font></td>\n"; 
echo "</tr>\n"; 
} 
echo "</table>\n"; 
?> 

and the error i get is

SELECT Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1

Never mind, i got it 😃😃😃

Thanks a lot for all the help 🙂