ok, thank you.
I have read it.
What I intend to upload is .doc files or pdf files.

It is not advisable to store the entire file in the database..
but does it means it is possible?
If so how?...

Hi,
Is it possible to upload a file that contains some data
and directly save the data in specific fields as in database using php?.

this is important as the data retrieved according to their...

Hello,
Anyone can help me to solve this problem?

thank you.

ok, thanks for your reply.
really appreciate it.
I am trying to expand the code so that it works according to my need.

Many thanks.

Result of the search will be displayed in rank.
The most similar record to the query will be at the top of the result list..followed by the 2nd most similar and so on.
this similarity is calculated...

yup..that is just a sample interface..it will be editted later according to the databse structure

The main problem is I do not know how to refer to several lookup tables. How can I do this ?
many...

query is the keyword that user key-in
cases are records in database..
query and cases are compared..the similarity is taken from the llokup table..
& overall similarity is calculated.

many...

ok..thanks..
Attached herein is the interface of the search page.
the similarity should be reffered to other tables
(similarity table)

Hi,
I need to refer to the lookup table for each keyword inserted by user
to compare query and record in database and find the similarity.
this similarity is then times by the weight chose by...

thanks a lot.
I am trying to run it.

yes , you are right. Furthermore each column has another textbox for the weight.


yes please..really appreciate it

thank you

Hi cwarn23,

attached here is one of the table- form and the main table: lessonplan
the other 4 tables (subject ,skills ,time ,ability) follow the same structure...however the record need to be...

ok,
but users' search should contains the fields in the first table with weight-
form - (user's input- eg: form2) :5
subject - (user's input- eg: science) :4
skills - (user's input- eg:...

ok, thanks.
I need to do searching from the database records.
users need to key-in keywords together with the weight of each searched keyword.
the result should be shown in ranking..

So I need...

Hello,
Anyone know how to solve this problem?

I have several tables.
1. the main table namely lesson contains several fields that used for searching.
2. weight is assigned by users for each...

Hello,
thanks for your suggestions..
It was settled ..

Thanks sDjH,
I have tried as what you suggest.
here is the error..
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...

Hi everybody,
here is my update query ..there is no error but the record is not updated.

anybody know of what should I edit?
Many thanks


mysql_query("UPDATE lesson SET(`subject`=...

if you see from the example- case base value- it looks like 2 dimensional table..
any input?

Thank you

ok..thanks..
I just had a look at the demo..

but what I intend to do is to just keep the value ( similar as shown in the link) anywhere.. (anyone know??) and use the value later to compare with...

Hi, anybody know on how to create table like this- table editor (http://mycbr-project.net/tableEditor.html)- in MySQL?

I need to retrieve the value & compare it with the query value ( I am doing...

thanks..
i have solved this

thanks cwarn23 and shawncplus..
I have tried before..
there is no error now..but the new record is not saved .
What I intend to do is to save a new record after customization.
I do not use update...

I have error on this line..
what should I change..thank you

mysql_query("INSERT INTO lesson (subject,year,learningArea,objectives,ability) VALUES
('<?php echo...

thanks all..
I have succesfully customised the textboxes,
however when I try to save it as a set of new record..
nothing happened to the database.
no record is added.

As suggested before..I...

Search records from database.
tq

Hello,
anybody can suggest me on how to do exact match in php ( for search purpose).
From my reading I understand that we need to use " ".
What is the correct syntax for this?
Is preg-match...

Thanks all..
I have done this ..not in text area.
just a normal link..using the same syntax & then print <br/> at the end of that code.

thanks Menster..
I have tried like this

<?php
for ($i =0; $i < $ValuenumtableChildren; $i++)
{
$str1 = substr($Valuechild[$i],0);
$str2 = substr($Valuechild[$i],1);
...

Hello,
since there is no solution for a link in text area..
I just make it a normal link-not in textarea

<?php
for ($i =0; $i < $ValuenumtableChildren; $i++)
{
echo '<a...

Hello,
I have tried to do this bacic MySQl query expansion but there is an error..Could anyone who know how to correct it tell me. thank you

$myquery = "SELECT learningArea,subject,ability FROM...

ic, ok..thanks:$
but I would like to retain the value that is currently displayed.
by using this $flag="";
the textbox is enable..it's correct..but the value inside is emptied.

thank you

HI adatapost,
I am sorry for coming to this thread again
several questions to ask:



to enable the textboxes after click edit, can we code like this ?

$unflag="enabled=\"enabled\"";
I...

$query= 'SELECT * FROM ' . $_GET[$tablename] . ' WHERE id = ' . (int) $_GET[$row2[$cols]] . ';' ;

I have changed it to the above statement..but there is an error as well
mysql_fetch_array():...

Hi..is this a correct SQL statement to display details of a record from
table and column that is variable


$query= (SELECT * FROM $_GET['$tablename'] . "' WHERE id = '" . $_GET[' $row2[$cols']...

Hi,
I am trying to apply ranking to the output of my search result based on the relevance of the searchterm & record in database.
when I run the below code..there was a query error
...

thanks guys for your help, suggestions, comments etc.
however it is still unsolved.

thanks anyway

it was a typing mistake..
It just to make an underline
but What I intend to do is to make a hyperlink from that variable to a detail page.

someone has commented this..


maybe javascript can...

yes..I know that..I just to make an underline
but What I intend to do is to make a link from that variable [Childvalue]to a detail page..

the output is similar as what I got before
<a href="viewingdetails.php?name=Matter in Nature">Matter in Nature</a>

not Matter in Nature..

I do not know what else can I do..huhu