I wanted to created a searh engine for our site with indexed content of the pages
being stored in MYSQL full text index.
I wanted to know how fulltext index scales if I have about 200,000 pages indexed.
Is it wise to use MYSQL for this or go with other options like SWISH-e etc.
--
I need help writing query that would give me parent categories of catID from
categories table.
For example, if catID=030 then it should give me:
Birthday | Special Birthday | Special Birthday
If catID=028
Birthday | General Birthday | NULL
>desc categories
+---+--+--
I am creating site for greeting cards and need help desiging tables for DB
Currently I have three tables..
1) maincat which has following fields:
maincatid (autoincrement)
main_name (name of category)
2) subcat which has following fields:
subcatid (autoincrement)
maincatid
sub_name (name of sub ca
Hi,
I've got item table as follwoing:
itemno|item_name
1 item one
2 item two
3 item three
4 item four
2 item two
3 item three
I want to right a query so I get three rows of each item I specify in WHERE
for example
SELECT itemname from i
I've got the following query executing in my php code:
$query = "INSERT INTO table1(created,updated,ses)
values(now(),now(),'$this->PNPSES->ses')";
MYSQL_QUERY($query);
query executes fine, but when I look at the ses column in inserted row it says
Object->ses instead of a value.
Any ideas
Hi,
I need help with buliding a query from following two tables.
TABLE biz
| bizid| int(9) |
| bizname | varchar(50)|
| state| tinyint(2) |
TABLE coupons
| coupo
Hi,
I need help with buliding a query from following two tables.
TABLE biz
| bizid| int(9) |
| bizname | varchar(50)|
| state| tinyint(2) |
TABLE coupons
| coupo