can't figure out why i got the error .

[Kamal_6]

<?php
mysql_connect("localhost","root","");
mysql_select_db("test");
$data= mysql_query("select * from tbl_files where sl.no=1");
$rec= mysql_fetch_row ($data)
header("content-type:$rec[2]")
echo $rec[1];
?>

error

Parse error: syntax error, unexpected 'header' (T_STRING) in C:\xampp\htdocs\readfromdb.php on line 6

[David_50]

You never defined 'sl'.

[Kamal_6]

sorry i didn't get you, can you pls elaborate it briefly ???

[almostbob]

line 5 semicolon
line 6 semicolon

without the semicolon terminating line 5, line 6 is determined to continue line 5, and is not semantically correct
fix it,
then fix line 6 or you will get the same error referring to line 7 next run

@ David_50
would have been the answer, if sl.no were outside of quotes in Mysql_query(), inside quotes refers to DB structure already defined.
Went to note on your post,
doing that downgrades post,
not fair for what would usually be correct,
wrote here instead

[David_50]

You need to define sl, such as a table of the from clause: ... from tbl_files sl where sl.no = ...

Not sure what sort of database structure mysql allows you to refer to without a from clause anchor. If sl is a column of some advanced datatype, then I suppose you could dot into the innards.

Is there any reason that you're using deprecated code?

Use PDO/mysqli - mysql_* functions are dead. Don't use them.

[David_50]

Of course, the error is pointing to your header line, which is not the mormal line. Did you want to concatenate the constant 'content-type:' with the variable string $rec[2]? http://php.net/manual/en/language.operators.string.php says try:

header( "content-type:" . $rec[2] );

Semicolons also seem to be missing, as mentioned above. Linefeeds are not so magic in webby languages.

To be pedantic, the reason for the error as mentioned a number of times is the missing ';' on line 5 of your supplied code. However, as pointed out previously there is another omission: semi-colon on line 6.

The SQL:

select * from tbl_files where sl.no=1

Looks a bit squiffy to me too.

If you have a column named 'sl.no', which is not advisable, then you'd have to wrap this name within backticks in order to distinguish it from a table 'sl' - which is not defined elsewhere in your query. So

SELECT * FROM tbl_files WHERE `sl.no` = 1

should work for a column called sl.no. Otherwise the query should fail. It may be a typo on your part and should be sl_no? My 2p - but I'm no expert.