Invisible headers already sent - pg_exec

gonsman

Hi all,

I hope I am not missing something really obvious here (as is the case sometimes), but I am having a very annoying problem. I am trying to redirect to another url after performing a query. I think there maybe an error in my SQL, but I don't receive any errors on screen. I tested when the headers get sent and the headers get sent immediately after I call pg_exec(). Here is the code:

$sql = "SELECT DISTINCT users.id as cust_id,
			user_orders.b_prefix,
			user_orders.b_first_name,
			user_orders.b_last_name,
			user_orders.b_address1, 
			user_orders.b_address2,
			user_orders.b_city,
			user_orders.b_state,
			user_orders.b_zip,
			users.company,
			users.phone,
			users.email,
			user_believers.code,
			to_char(users.date_added, 'MM/DD/YYYY') AS date_added
		FROM user_orders, users
		WHERE (users.re7_id IS NULL OR users.re7_id = '')
			AND user_orders.date_printed2 IS NULL
			AND user_orders.date_ordered < '".$today."'
			AND user_orders.xref_user_id = users.id
			AND users.xref_user_believers_id = user_believers.id
			AND user_orders.ref_b_country = '001'
		ORDER BY user_orders.b_last_name";
// Headers not sent yet
$user_result = pg_exec($dbh, $sql);
// Headers have been sent
$user_rows = pg_numrows($user_result);

Any help reviewing my code is extremely appreciated. Thanks.

-Sean

PHPdev

Something as simple as a carrage return on the first line of a file before your beginning <?php can cause headers to be sent to the browser.

I would sudgest posting the code for pg_execute() becasue I think your prolblem lies in there. (Assuming this is a function you have written)

Hope this helps

PHPdev

gonsman

There is no space before <?php or after ?>

pg_exec is a built in function of PHP. It is used with postgreSQL. I have queries very similar to this and they work fine. I had this problem before, but it occurred when I was supressing the error message using @. I am not doing this now so I don't see what could be the problem.

-Sean

PHPdev

Sorry.. I noticed it was a built in function just after I put in this post...

You can try doing a die($sql) just before the execution of the pg_exec(), this can tell you two things... If anything is getting to the browser.. and then you can copy the sql statement and exectue it directly on the database....

Hope this helps...

PHPdev

gonsman

If I use die($sql) it prints the value in $sql and then stops running the script. I need to get the results so I can use them. How do I get the results using this method. I don't understand how to implement this.

-Sean

PHPdev

the die($sql) is for testing purposes only... It will allow you to see what value PHP has stored in each variable in your SQL Query. It will also allow you to cut and paste your query, so that you can test it directly on your database, via comand line or other query engine.

PHPDev

gonsman

Thanks, I ran the SQL output directly on the db and I get the exact results I expect, with no errors. I have found no answers to this peculiar problem. I found this thread in mail, but no answers, just the same stuff.

http://www.phpbuilder.com/mail/php-general/2001082/2254.php

-Sean

PHPdev

One other thing that you probably already have tried, is to view the source of the error code. I mean the page that is showing you the error code. See if there is anything above it in the source?

Sorry could not figure this one out...

PHPDev

gonsman

WOW!!! I think I see what is happenning. I am missing a table in the FROM clause. Although I don't get any error because postgreSQL adds the missing FROM clause and writes an error to the log file. I have no idea why this is not showing up in the browser though. I have 'user_believers.code' in the SELECT but I don't have the 'user_believers' table in the FROM. I am able to redirect once I added the missing table. Is this a possible bug with PHP, not displaying an error but sending headers anyway?

Thanks for all the help,

-Sean