display mysql data in PHP with explode

Question

enter image description here

I want to display only the specific user details as shown in link. For kind information, I just want to say that I am using php and mysql and need to display 'user2' details from that previous table(customer) given as picture link].help with valuable suggestion.

if I use sql- SELECT id,rcvusr FROM xyz WHERE rcvusr='user2' ORDER BY eid desc LIMIT 10. it display only 2 records(id 13 and 14) — rathins
– rathins, Commented Nov 20, 2013 at 11:32
Hello, Jaywalker anti-pattern! //Hint: do not store multiple values in one column — Alma Do
– Alma Do, Commented Nov 20, 2013 at 11:33
try sql like -- SELECT id,rcvusr FROM xyz WHERE rcvusr like '%user2%' ORDER BY eid desc LIMIT 10 — Anish
– Anish, Commented Nov 20, 2013 at 11:34
Dear Aneesh, Thanks. It's good, atleast i can make it on my way. Thanks once again. — rathins
– rathins, Commented Nov 20, 2013 at 11:42

Naveenkumar · Accepted Answer · 2013-11-20 11:35:42Z

1

Try this

SELECT id,rcvusr FROM xyz WHERE rcvusr like 'user2%' ORDER BY eid desc LIMIT 10

answered Nov 20, 2013 at 11:35

Naveenkumar

74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lorenz Meyer · Accepted Answer · 2013-11-20 11:42:36Z

0

Select id, sndusr, SUBSTRING_INDEX(rcvusr, '@@', 1), title
From xyz
Where rcvusr = 'user2' or
    rcvusr like 'user2@@%'

Here is the documentation : http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index

answered Nov 20, 2013 at 11:42

Lorenz Meyer

20.1k23 gold badges83 silver badges129 bronze badges

Collectives™ on Stack Overflow

display mysql data in PHP with explode

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related