Help using "CONCAT" ?

[Rob (SA)]

Hi folks,

I have a table with data surname and name and currently some info populates a field in page www.gnjgf.co.za/rankings.php

I would like to know how to make a change that the field shows the surname, name of the player and not just the surnames as is currently veiwed.

Your help would be appreciated

[Watdaflip]

Re: Help using "CONCAT" ?

Assuming both "surname" and "name" as different columns you can just echo both right next to eachother on your webpage that displays it.

[navaldesign]

Re: Help using "CONCAT" ?

Change the code in the drop down Inside Tag to :


><?php
$query = mysql_query($query1);
while($row = mysql_fetch_assoc($query))
{
echo '<option value="'.$row['surname'].' '.$row['name'].'">'.$row['surname'].' '.$row['name'].'</option>';
}
?

You will also need to change the "before Tag" code in:

<?php
$connect = mysql_connect("localhost", "?????_?????", "?????") or
die ("Hey loser, check your server connection.");
mysql_select_db("?????_Members");
$query1="select * from _Form_Nr_2 ORDER BY `surname` ASC, `name` ASC";
?>

[Rob (SA)]

Re: Help using &quot;CONCAT&quot; ?

Hi George,

Thanks it works like a dream.