How to create a word doc using php?

[impin]

word document should display the details about the candidate.

<?php
include("config.php");
 
//$table = 'table_name';
$outstr = NULL;
 
$id = $_GET['id'] ;
 
header("Content-Type: application/msword");
header("Content-Disposition: attachment;Filename=candidate.msword");
 
/*$conn = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("db",$conn);*/
 
// Query database to get column names 
$result = mysql_query(" select * from candidate where cid='$id'");
// Write column names
while($row = mysql_fetch_array($result)){
    $outstr.= $row['cid'].',';
} 
$outstr = substr($outstr, 0, -1)."\n";
 
// Query database to get data
$result = mysql_query("select * from candidate where cid='$id'");
// Write data rows
while ($row = mysql_fetch_assoc($result)) {
    $outstr.= join(',', $row)."\n";
}
 
echo $outstr;
 
?>
 

a blank word doc is created...

if i change this code,

$result = mysql_query(" select * from candidate where cid='$id'");
 

as like this,

$result = mysql_query(" select * from candidate");
 

it works fine...

but i want to display only a particular candidate's details... not all the candidate...
how to do it? plz help.

i tried in pdf, i m also having same problem in that select query...

[JKing]

Use echo "Error: " . mysql_error();after your query to get a better idea of what is going wrong. Is cid numeric or string?

[Antonio Marcos]

If I understand...
Are you get not make a efficient instruction on SQL, isn't?

Where you put the character '*', you should put the fields of the tables in your database.

Example:
If I have a table:
people(id, name, age, address);

And here a simple select:
SELECT name FROM people WHERE id = 2;

with that I'll get a name of the people where your ID equal two.

CYA!

[impin]

$result = mysql_query(" select * from candidate where cid='12'");
 

if i give like this it works. but what's the problem is,
there are several candidates in the table. i want to create each candidate's details as a word doc.

for example,
candidate table consists of several fields like cid,cname,maili d, phone,etc....
my candidate's list is like,
cid cname
14 xxxx
15 yyyy
16 bbbb
17 zzzz znd so on.

when i click the 'yyyy' it will retrieve all the info about 'yyyy' in a separate page(candidated etails.php)... from this page (candidatedetai ls.php) i want to create a word doc that contains all the info about 'yyyy'.

i am passing cid from candidatedetail s.php to createdoc.php.. .


thank you!

[code green]

This is exactly the same problem as your other post.
http://bytes.com/topic/php/answers/9...iles-using-php
You are ignoring advice on how to debug your problem from me and JKing,
instead preferring to repeat the same question.
We can't help you if don't help yourself!