I'm looking for a way to compare 2 lists of keywords and return the number of matches. I'm currently working with PHP and MySQL, but I'm not sure how to go about this task. Any suggestions are appreciated. Thanks, J_

Member Avatar
Member Avatar
+0 forum 3

Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye

Member Avatar
Member Avatar
+0 forum 1

Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to be able to choose from for updates. Example: I have 745 different tools in one toolkit. If that tool deploys to Iraq or Afghanistan I would check the appropriate yes/no. If it deploys to another location, I would have to write that location in the text box. Instead of checking …

Member Avatar
+0 forum 0

I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the inventory for each one of the tool kits, I want to just import the info from excel. I've done this before with a database that I made about 3 years ago, but I can't remember how, and I can't find my access bible to look up the answer there. Help …

Member Avatar
+0 forum 0

I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem.

Member Avatar
Member Avatar
+0 forum 5

Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I have little or no help. this is what I want to do although I am not very sure how to do it. I want to develop the front end for SQL SERVER 2000 using HTML using the middleware ODBC!!! though not very sure how to go about it. The other …

Member Avatar
Member Avatar
+0 forum 8

How can i display result of a single cell query? my query is [code]$author=$_POST["authorname"]; $q="Select authorid from authors where AuthorName=$author"; $resultauthor=mysql_query($q,$connect); $num=mysql_num_fields($resultauthor); [B]<<Error coming here![/B] :( mysql_num_fields(): supplied argument is not a valid MySQL result resource in[/code]

Member Avatar
Member Avatar
+0 forum 2

I have the following code: [php]$rebate_query = tep_db_query("select * from " . TABLE_REBATES . " where product_id = " . (int)$HTTP_GET_VARS['products_id']); $rebate_information = tep_db_fetch_array($rebate_query);[/php] This should return only 1 row of data I have this code - " [php]$rebate = $rebate_information['rebate_amount'];[/php] " for extracting the rebate amount. For the life of me I cannot understand why this isn't working. It doesn't error out, but nothing is returned, and I know that the value exists. I would very much appreciate any help you can give. Thanks.

Member Avatar
Member Avatar
+0 forum 5

The computer is a Dell Optiplex GX270, running Windows XP Pro., and Office 97 Pro. I've had Office 97 running on this computer for a few months and Access was fine. I went to open it and got an error saying it couldn't be opened because there was no license for it on the computer. This is a legal copy of Office 97 that I bought myself and have been using. I've tried uninstalling and reinstalling Office itself as a whole and I've tried uninstalling and reinstalling Access alone and get the same error each time. Any help would be …

Member Avatar
Member Avatar
+0 forum 3

The End.