combing field name

[pradeepjain]

hii guys i have a small problem
i hve a filed called fname1,lname2 ......fname6,ln ame6 and pauthor which stores say 1..6 which says who is the author ...so is there any way to combine 2 field name like this fname.pAuthor ...so tht i get author name ....i am using php.

[bilibytes]

hii guys i have a small problem
i hve a filed called fname1,lname2 ......fname6,ln ame6 and pauthor which stores say 1..6 which says who is the author ...so is there any way to combine 2 field name like this fname.pAuthor ...so tht i get author name ....i am using php.

instead of putting "....." try to explain what you want with words, it would help to understand what your problem is in order to get a solution.

if what you want is to get the values of the "fname" and "pAuthor" assuming they are on the same table, write:

$recordset = mysql_query('SELECT fname, pAuthor, FROM tablename', $link);

(WHERE id=123): optional

then from php simply get the row by looping the rows in your MySQL resource with:

$i=0;
while($row = mysql_fetch_array($recordset)){
$entire_names[$i] = $row['fname'].' '.$row['pAuthor'];
$i++;
}

then you could print the $entire_name array content with

print_r($entire_names);

if in your query you use the WHERE clause then you would not need to use the while(), that is: assuming you get one single record
Just do:

$row = mysql_fetch_array($recordset);
$entire_name = $row['fname'].' '.$row['pAuthor'];

best regards

bilibytes

[pradeepjain]

hey tht "....." meant to say that upto fname6,thts its...
Hey i want to do it in one query like
select fname.pAuthor from table or
select fname{pAuthor} from table is there any way of joining like this.....i store the number of the author in pAuthor field and if pAuthor says 1 then fname1 is the name of author

[Banfa]

You question is unclear.

Perhaps you should start with the number of tables you are interested in extracting data from, the exact structure of those tables and exactly what you are trying to retrieve (contents of the rows order of number of rows in the result set i.e. expecting 0 or 1 or many).

At the moment it appears that you have a single table where pAuthor is one of the fields so your own code "select fname.pAuthor from table" should work fine.

Please also remember that everyone on this site is volunteering they time and expertise for free, if they ask for more detail it is because what has been written so far has not made the problem clear to them.

[pradeepjain]

You question is unclear.

Perhaps you should start with the number of tables you are interested in extracting data from, the exact structure of those tables and exactly what you are trying to retrieve (contents of the rows order of number of rows in the result set i.e. expecting 0 or 1 or many).

At the moment it appears that you have a single table where pAuthor is one of the fields so your own code "select fname.pAuthor from table" should work fine.

Please also remember that everyone on this site is volunteering they time and expertise for free, if they ask for more detail it is because what has been written so far has not made the problem clear to them.

select fname.pAuthor from table is not working da...

[r035198x]

Have a look at CONCAT

[pradeepjain]

Have a look at CONCAT

tried that also ..did not work .

fname is just a string and pAuthor a field name and when i combine like fname.pAuthor
it should become a field name like fname1,fname2

[r035198x]

Post what you tried that doesn't work.

[pradeepjain]

select fname.pAuthor from abstract;

[r035198x]

Where is the CONCAT?