vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Small pagination problem (https://vborg.vbsupport.ru/showthread.php?t=186999)

veenuisthebest 08-02-2008 04:57 PM

no.. i am not using searchid at all ! ... will try these methods..:)

one more thing plzz..

How do I search for some text ??? Say, we add a site with all the details.. Now I want to search with keyword "Tech555" and I want that all the sites that has this term in any of their fields should retrieve.

Thank you

Lynne 08-02-2008 05:37 PM

You would add another input field to your links.php form to include the keyword. Then, in your query, you would add in the search for that keyword in the correct column.

veenuisthebest 08-02-2008 06:10 PM

ofcourse we'd be adding a input field..

i was asking for query only !
will it be something like this?

PHP Code:

SELECT from mytable WHERE sitetitle LIKE '%$keyword%'

where $keyword is the variable that contains the search value.


Thanks

Lynne 08-02-2008 06:19 PM

I think you want to do it like:
PHP Code:

$query="SELECT * from mytable WHERE sitetitle LIKE '%" $keyword "%'"


veenuisthebest 08-02-2008 06:26 PM

ahh... thank you so much ! you're so nice..

How does it look now ? I also removed that table border look.
http://www.tech555.com/forum/links.php

Lynne 08-02-2008 07:08 PM

It's looking really nice!


All times are GMT. The time now is 03:19 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02386 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete