COAddOns project site-Add-Ons for MiaCMS, Mambo & Joomla CMS

 Home arrow FAQs arrow FAQ: MosQ arrow MosQ: How to build search form and hyperlink in result set?
Pick Language to Auto Translate:
AR | BG | CA | CS | DA | DE | EL | ES | FI | FR | HI | HR | ID | IT | IW | JA | KO | LV | LT | NO | NL | PL | PT | RO | RU | SK | SR | SL | SV | TL | UK | VI | ZH | ZT
SiteMap :: Contact Us :: About Us :: Member Blog :: Newsfeeds :: How-To :: News :: CMS Info :: MosNews :: Web Tools :: IRC Chat  

Main Menu
Home
Forums
Downloads
CMS Category
Web Links
FAQs
Blog
MoseCMS
COAddOns Wiki
COAddOns Docs
Drupal resources
Who's Online
We have 496 guests online
MosCmenuTree

FAQs

Feature Sites
Web Hosting
Q's quickdeals
OpensourceCMS
CMS Matrix
Joomla Extensions
Joomla Templates
Login Form
Username

Password

Remember me
Password Reminder
No account yet? Create one
Donate
Support OngETC in making a small donation:
Syndicate

MosNewsWriter

MosQ: How to build search form and hyperlink in result set? Print E-mail
User Rating: / 6
PoorBest 
MosQ is using a standard SQL syntax in the logic center so any SQL function of your particular database will work in the logic.  It is up to your amagination!

In this article I will be using mysql database syntax here.

Q: How to build search form?
A: You just use "LIKE '%|Category|%'" in your where clause which will turn your logic into a search form.

For example:
sql@
SELECT c.title AS Category, b.Title
FROM  mos_weblinks AS b, mos_categories AS c
WHERE c.id=b.catid and
c.title LIKE '%|Category|%'
ORDER  BY c.title, b.title

Q: How do I build a hypertext link into a result set?
A: You can use "Concat" function in your select statement when create a column for the result set.

For example:
concat('<a href=\"index.php\">',title,'</a>') as Name
Comments

This is very hard to troubleshoot since MosCom strip off any html code. May I suggest you post a thread and the forum so I can see your complete code there so if I might spot something.

Posted by Chanh Ong, on 07/12/2007 at 17:16

Hello,

I tried:

sql@select concat('', tekst,'') from jasper_bol_affiliates where keyword='sonjabakker' ORDER BY RAND() limit 4

and:

sql@select concat('', tekst,'') from jasper_bol_affiliates where keyword='montignac' ORDER BY RAND() limit 4

and:

sql@select concat('', tekst,'') from jasper_bol_affiliates where keyword='montignac' ORDER BY RAND() limit 4

But all the same result s shown in the picture/ screenshot.
I did a google search earlier but i don't see the error.

Jasper

Posted by jasper, on 07/12/2007 at 17:06

oh, my MosCom strip off all html code. You can just copy the sample code from my article about that should do the trick!

Posted by Chanh Ong, on 07/12/2007 at 15:50

Hello,

No this will only print ',tekst,' on the screen....
Is it supposed to work normally? Maybe my php settings are wrong somewhere?

http://www.snelafvallen.info/phpinfo.php

Jasper

Posted by jasper, on 07/12/2007 at 15:42

Try something like this:
concat('',title,'')

Thanks

Posted by Chanh Ong, on 07/12/2007 at 13:21

 1  2  3  Next Page >
Page 1 of 3 ( 12 Comments )

You are not authorized to leave comments. Please login first.
<Previous   Next>




Sponsors

Reseller hosting (free)

000webhost (free)

HostUpon (w/ ssh)

Hosting24 (w/ ssh)

Free TK domain

CO.CC:Free Domain

Get Chitika Premium

Free Windows Hosting


Credit Counseling - Credit Consolidation - click fraud protection - Phoenix Landscaping
Validate XHTML
Validate CSS