Search Result

newbie93 · Jun 4 '12, 08:30 PM

Hey guys. I'm working on a database with 3 tables, some with overlapping information. A few columns from each table can be updated by the user via the web app that I am creating. But... There is an issue. Not sure what it is, but my updates aren't happening. I am wondering if something is wrong with my query. (Actually, after debugging, I am quite certain there is).

Code:

	if (empty($errors)) { 	
		$query1 = "UPDATE owner SET

...

chocomon · May 13 '12, 07:34 PM

Hi, i want to code a .php file that will take information from an sql database based on a search query and then put the retrieved data into an html table that i've created within another file

essentially, i'm trying to 'add students' into a club table...

my current php code posts my collected data

Code:

<?php

mysql_connect ("localhost", "testuser","")  or die (mysql_error());

...

wisni1rr · Mar 22 '12, 06:31 PM

I was wondering how I could merge two tables that are serving as a 1:1 relationship (although, no relationship is defined).

[TableA]
ID,field1,field 2,field3
[TableB]
ID,field4,field 5

The query would check for matching ID. If there is a match, TableA Should be amended with the results of TableB.

The final result would be:
[TableA]
ID,field1,field 2,field3,field4 ,field5...

AndrewChampion · Mar 12 '12, 08:13 AM

I have a database that tracks student information and grades. I am using a form to enter data and the form will post to a table as information is entered. The form is using a query to select students by class number. I have entered a new class number with 16 students into the form. The table has received all information that has been entered. Now when I try to load the new class number in the form none of the records will show. When i attempt...

AndrewChampion · Mar 10 '12, 08:23 AM

I have a database that records grades for students and then averages them. I need the results of the average expression to post on the table. Every other field works great. I have tried using the expression in the after update property and the before update property with no results still. I am pretty new at this and any help would be appreciated. Thank you in advance for any help you provide.

bretdunlap · Jul 19 '11, 04:30 PM

Hi
If you all could suggest some ideas

I have 2 tables (student Info) and (student attendance)and a form called (DNS (did not show)) basically in the student attendance I record the dates that a student attended class.

What I am trying to figure out it the sql query or VBA to call the records that are not associated with dates from the attendance table between and including 2 dates.

For example:...

MusoFreak200 · Jun 3 '11, 03:42 AM

Can anyone please help me with this code as i cannot get the javascript to display in my product item display.

the product numbers are prices in a separate file but i cannot display it as it is so extensive and it is only declaring the variables prices of products.

Code:

	<div id="ProductBG">
		<div id="MainContentContainer">

			<div id="ProductTitle">

...

Nancy Alexander · May 5 '11, 07:56 PM

Hi,

I know the query WRKOBJLCK but this query is just used for checking the locks on the tables one by one.

I want to know the command to check all the tables in database which has a lock.Anyone has any idea about the command and how to use the command.

Thanks,
Nancy

BaseballGraphs · Apr 13 '11, 06:12 PM

Hello,

I am trying to find resources or an explanation on how to highlight several <td>'s within a table when a click is made and the mouse is dragged across the table while holding the click.

Does anyone have any resources or examples on how to achieve this sort of functionality?

Thanks!

Sunny Sawrav · Mar 15 '11, 12:01 PM

Hi there,
I'm working on a website right now. The website involves frames. 3 frames : top, mid, bot.

Top frame = menu
Mid frame = body
Bot frame = Links

Now, I've designed the webpages using photoshop slices.

Can someone please tell me how can I make the website auto resize according to the size of the browser window?

Please do help.

An example of a webpage...

Fspinelli · Mar 7 '11, 04:10 PM

Hi,

I was given two huge excel sheets; one is of Companies (which includes types and contacts), the other is of Consultants. There are about three thousand company records. A few hundred of the consultants.

I need to create a database with forms for easy end-user entry or viewing. I also have to create a form which allows the user to choose query parameters (if possible)...els e I'll just give them boxes and a button...

ilya Kraft · Feb 9 '11, 04:51 PM

Hi all,

I've been recently making some websites and used tables for loyout. I perfectly knoe how to use div tags, but i find it much more easier with tables.
Is there any difference and do all browsers accept them both the same?

Ricardo de Mila · Jan 31 '11, 03:39 AM

In my small application (msAccess VBA), I don't want to criate group users, but would like to protect the tables, so nobody else can see them or even import the information.
Is it possible?

Best Regards
Ricardo

William Leigh · Jan 27 '11, 10:50 AM

Hi guys,

Hope someone can help.

I have a webpage that I need to adjust the layout on and it is in divs and I've not used them before.

The page as it currently looks is here: http://violetproductions.com/portfolio.html

I want it to look like this:

I am rather out of my depth here and a bit of guidance would be really useful. I need to be able to add more of the thumbs...

David Goldstraw · Jan 25 '11, 09:59 AM

I have two databases and I want to automate a process to find duplicates. I originally linked the table from one into the other but I have now gone down the route of importing the table from one db into the main one because it was running too slow.

Now I have imported the table I am still getting a very slow response from the query. I have tried numerous routes i.e. update, make table and even select and it is till slow. The query...

Search Result

Is something wrong with my query?

How to put information from sql database into html table

Merge Query

My forms will not show the newly added records.....

Expression data entry?

Call records not showing attendance date

Javascript is not displaying when in div and table boxes

To check the locks on all the tables in a database.

Highlight <td> in table as dragging across?

Auto resizing webpage with frames and tables in it

What is the best way to create a contacts database which will have queries?

Is there a difference between <div> tags or <table> for layouts?

How to protect the tables of my msAccess without enabling the group level security?

How to create a new row of boxes using divs?

How to fix Access Query that is running very slow?