0

Hello, i have the following column in mysql table.
number | name
123 | ABC XYZ
456 | DEF QRS

hre is my mysql query:

$query = "SELECT name, extension FROM users ORDER BY name ASC";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<AddressBook>\n";
for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
$row = mysql_fetch_assoc($resultID);
$xml_output .= "\t<Contact>\n";
$xml_output .= "\t\t<LastName>" . $row['name'] . "</LastName>\n";
$xml_output .= "\t\t<FirstName></FirstName>\n";

for the moment my First name is blank..i need to retreive the name column and display it into different output. can someone advise how to split the data.

thanks in advance.

2
Contributors
2
Replies
25
Views
3 Years
Discussion Span
Last Post by shaqib
1

Hi,
you could explode by the spaces between the names:

$names = explode(' ', $row['name']);
echo $names[0];
echo $names[1];

BUT you cannot distinguish between name, middlename and lastname. The correct solution would be to normalize this information during the collection step. Which means:

firstname: <input type="text" name="firstname" /><br />
middlename: <input type="text" name="middlename" /><br />
lastname: <input type="text" name="lastname" /><br />

And then insert it in the appropriated columns:

insert into users (firstname, middlename, lastname) values($fname, $mname, $lname);

More information here:

0

thanks i will try the explode and revert back as i cannot modify the input form.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.