Blank Screen still happening...

[koager]

I know there have been various questions about blank screens from php but I've looked around and they aren't helping me at all.

I wrote a .php page and put it up on the hosting server but the page keeps on returning blank. I've checked that I have all my brackets and semicolons placed correctly.
I've added

<?php
//turn on error reporting
ini_set('display_errors',1);
ERROR_REPORTING(E_ALL);
?>

to the top of page but it is still returning blank without any error reports.
I found my php.ini file and checked that also. The display_errors is set to ON. Also, there isn't anything logged in a .txt file.
I wrote in phpinfo(); previously and it worked; the server has php up and running correctly. The version is 4.3.11
However, I did notice that even though I changed display_errors to ON it still says OFF in the info that shows up, however that shouldn't matter since I specified having error reporting on in the specific page.
_______________
I deleted everything and just put this in the body

<?php
//turn on error reporting
ini_set('display_errors',5);
ERROR_REPORTING(E_ALL);
?>
<?php
echo "Hello World
?>

I still get a blank screen when there should be an error showing.

[koager]

I ended up inputting it line by line to see where the error is.
Found that and fixed it. However I have another problem now...
It seems that it is now not connecting to the database.
I believe I have the host, username, and password correct.

$con = @mysql_connect("FAAMDLDatamysql.db.2233605.hostedr esource.com","________","******");

I've checked, double checked, and triple checked my username and password and they are spelled correctly and with capitals and everything.
For the host I've also tried their IP 10.6.186.63 but still no connection.

The server version is 5.0.67.d7-ourdelta-log
and I tried
running this sql

SET PASSWORD FOR user@localhost = OLD_PASSWORD('******');

but it didn't work

[dlite922]

can you ping the host? can you telnet form a command line to that host on the MySQL default port 3306?

The problem is most likely your connection rather than PHP.

Remove the @ sign in front of mysql_connect and append this:

....****") or die("Could Not Connect, here's the error<br>" . mysql_errno()); 
 

Let us know,



Dan

[koager]

I deleted the @localhost part and it worked.
Right now I'm trying to solve the problem of the string that I return with my form needs to be stored with " " around it for my SELECT * WHERE to be able to locate the data.
I have $_GET['stock'] stored into $stock but I need it to be stored along with " " to be usable as it is a string and it needs to be defined as one with the quotes for it to be found in the database. /" isn't working...
_______________
Maybe not...
I got quotes around it with
$stock = '"' . $_GET['stock'] . '"';
but my SELECT * WHERE Stock_code="$stock" still doesn't seem to be locating the data

Unless it's my display code that is not functioning correctly

//Display result
    //create header cells
echo "<table border='1'>
        <tr>
            <td><b>Stock Code / Component</b></td>
            <td><b>Description</b></td>
            <td><b>System Model #</b></td>
            <td><b>Rotocraft Make</b></td>
            <td><b>Rotocraft Applicable Models</b></td>
            <td><b>STC</b></td>
        </tr>";
//input data into cells of table
while ($row=mysql_fetch_array($result)){
    echo "<tr>";
    echo "<td>".$row['Stock_code']."</td>"; 
    echo "<td>".$row['Description']."</td>";
    echo "<td>".$row['System_Model']."</td>";
    echo "<td>".$row['Rotocraft_Make']."</td>"; 
    echo "<td>".$row['Rotocraft_Applicable_Models']."</td>"; 
    echo "<td>".$row['STC']."</td>";
    echo "</tr>";
    }
echo "</table>";

[koager]

Nevermind about the echoing out the data retrieved.
I replaced $stock in the SELECT * WHERE statement with a stock code that I know and it would display it fine.

Logically, it makes sense for it to work
I retrieve the string that is inputted, add quotes around it, insert that into the SELECT * WHERE statement, which then takes that to the database and locates anything that matches the string, stores it as $result, and, from my while statement, displays it in a table.