SQl Query

[miztas]

I keep getting this error message at the top of my php script that retrieves user details from a database.

Warning: Cannot send session cache limiter - headers already sent (output started at c:\apache\htdocs\user_details.php:5) in c:\apache\htdocs\user_details.php on line 6

Any ideas?

[anurag]

It seems you have a echoed out some output before using session functions (probably session_start etc).
"output started at c:\apache\htdocs\user_details.php:5" this indicates the line that echos out the text
"c:\apache\htdocs\user_details.php on line 6" this indicates the session function u are using. I would advice you to move line 6 above line 5 to make it work.
Remember a blank line (not within php delimiters/tags ie "<?php" , "?>") is considered as an output
Regards Anurag

[frewuill]

It seems you are writing to the output before setting a session, be sure you don't do any "print" or "echo" before calling a session function.

I hope it helps

[miztas]

This is my script, still getting the error:

<?php
session_start();

mysql_connect("localhost", "root", "");

mysql_select_db("users");

$result = mysql_query("select * FROM users WHERE Username = '$valid_user'");
$array = mysql_fetch_array($result);

echo "Your user name is: ". $valid_user. "<p>";
echo "Your Password is: ". $array['Password']. "<p>";
echo "Your Surname is: ". $array['Surname']. "<p>";
echo "Your Firstname is: ". $array['Firstname']. "<p>";
echo "Your age is: ". $array['Age']. " years. <p>";
echo "Your sex is: ". $array['Sex']. "<p>";

?>

[anurag]

Since this still gives error Just make sure that your php delimiter tag ie "<?php" is right at the top of the page (no blank line before that... not even a space"
What line does it show error this time?
Regards Anurag

[frewuill]

Is this the very start of the page? or are there blank lines, html code or something else.. i agree with anurag... there must be something in the output before the <?php tag

[foofoobar]

I usualy get that error when trying to write the content of the page prior to the header. For instance, putting an echo() or print() before a header() function will always give you this error.

That's because you are writing the content on the page prior to the header being written. In effect, you try to write the body of the page and follow it by the header info.

[sid]

you must have some html printed out prior to this.
either by white spaces, normal html, echo/print/... or includes - if you have any included files prior to that sequence, you must check those (and the files they include, and the files they include,...) for the same issues!