Array ( [0] => 196 [topicid] => 196 [1] => samsung sgh-z140 [topictext] => samsung sgh-z140 [2] => samsungz140.gif [topicimage] => samsungz140.gif [3] => samsung sgh-z140 [topicname] => samsung sgh-z140 )
samsungsgh-z140americasarmy
SELECT t.topicid, t.topictext, t.topicimage, t.topicname FROM nuke_topics as t WHERE t.topictext!="" AND "samsung_sgh-z140_americas_army" REGEXP CONCAT(LCASE(REPLACE(t.topictext, ' ', '_')), '_.*')
196
select s.sid, s.catid, s.aid, s.time, s.title, s.hometext, s.bodytext, s.topic, s.informant, s.notes, s.acomm, s.haspoll, s.pollID, s.score, s.ratings, t.topictext FROM nuke_stories as s, nuke_topics as t where LCASE(REPLACE(CONCAT(t.topictext, s.title), ' ', '')) = 'samsungsgh-z140americasarmy' AND (s.associated REGEXP "^196-.*" OR s.associated REGEXP ".*-196-.*")Si ha llegado a este mensaje, por favor reporte el error a limicom@hotmail.com