blank pages and error display

[gabucknall]

I am writing a database using php mysql. I have a page which works fine but if I add one extra query it just produces a blank page. I remember once that someone said I could put in some code at the start of the page and it would display any errors but can't remember the code!

 

Could someone let me have the code and does anyone have any suggestions as to why this blanking is happening?

 

Many thanks

[trq]

Could someone let me have the code

<?php

error_reporting(E_ALL);
init_set('display_errors', 1);

does anyone have any suggestions as to why this blanking is happening?

Sorry, Ive lost my crystal ball.

[Jacques1]

Doing the error configuration at runtime doesn't help if the error happens before the script runs. This is not the case here, but you're likely to run into more errors in the future.

 

So the proper solution is to open your php.ini and fix your global configuration: display_errors must be On, error_reporting should be -1. Of course you only do this in your local test environment. On a live server, you log the errors, not display them.

 

Note, however, that PHP does not automatically display MySQL errors. If the query itself fails, then you will not see that by default. How to get the error message depends on the database extension you're using. As trq already said, your question is very vague.