Thread: Help using "CONCAT" ?

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

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

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";
?>

Hi George,

Thanks it works like a dream.