Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

combine multiple row that have same id

Codes here !

Moderators: macek, egami, gesf

Postby Redcircle » Thu Feb 27, 2003 11:33 pm

I am curious on what you are trying to accomplish with this data. There may be a way if I know the end results.
User avatar
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA

Postby Romantik » Fri Feb 28, 2003 2:16 am

I think, you have wrong structure of base

table name
id name
1 Matt
2 Sarah
3 Tom

table surname
id ind name
1 1 John
2 2 Gina


SELECT AS name, AS surname
FROM name INNER JOIN surname ON

$name= $row["name"];
$surname= $row["surname"];
echo $name." ".$surname."<BR>";
New php-forum User
New php-forum User
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.