Help using "CONCAT" ?

Rob (SA) · #1 06-15-2009, 05:12 PM

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 · #2 06-15-2009, 09:12 PM

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

navaldesign · #3 06-15-2009, 10:43 PM

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) · #4 06-16-2009, 12:06 AM

Hi George,

Thanks it works like a dream.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)