Member Avatar for mmcdonald

In a SQL field I have this:

GroupManager 2.0 (2.9.3) (Phoenix)<br/>MultiInv 3.1.3<br/>Ptweaks 4.2<br/>WorldEdit 1232-0bc9369

Which spits out this:

GroupManager 2.0 (2.9.3) (Phoenix)
MultiInv 3.1.3
Ptweaks 4.2
WorldEdit 1232-0bc9369
Multiverse-NetherPortals 2.4-b530

How can I make it so it's two text columns like this when I echo it onto a page:

GroupManager 2.0 (2.9.3) (Phoenix)               WorldEdit 1232-0bc9369
MultiInv 3.1.3                                   Multiverse-NetherPortals 2.4-b530
Ptweaks 4.2

I've done my searches with no results :/

  • 2 Contributors
  • 1 Reply
  • 115 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by LastMitch
Member Avatar for LastMitch

@mmcdonald

Try this:

SELECT table.*
FROM tablename t1, tablename t2
WHERE t2.t1id = t1.id
ORDER BY t1.id
LIMIT 0, 1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.