Ruth

I took out the constraint pk_placement. I changed the data type for pay to money. Now I'm getting the following error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' start_date datetime, pay money, primary key (pclient_id, pagent_id, plog, pemp_' at line 5 As far as I can see the date data type is correct I'm not sure about money. But it still throws the error regardless.

I'm using mysql 5.1 I have four tables, I'm trying to use the fifth to link them together. I have a client, agency, phone log, and employers table that is created. I'm getting the following error when I try to create my link table placement: ERROR 1005 (HY000): Can't create table './netpro/placement.frm' (errno: 150) Here is my create table statement: create table placement ( pclient_id int, pagent_id char(20), plog int, pemp_id int, start_date date, pay int, constraint pk_placement primary key (pclient_id, pagent_id, plog, pemp_id), constraint fk_pclient foreign key (pclient_id) references client on update cascade on delete cascade, constraint fk_pagent foreign key (pagent_id) references agency on update cascade on delete cascade, constraint fk_plog foreign key (plog) references phone_log on update cascade on delete cascade, constraint fk_pempid foreign key (pemp_id) references employers on update cascade on delete cascade ) engine = innodb;

I'm using sql 5.1 running on unix. I have four tables I'm trying to link together through one table. I have a client, agency, phone log and employers table already built. When I try to create my placement table (link table) I get the following error: ERROR 1005 (HY000): Can't create table './netpro/placement.frm' (errno: 150) Here is my create table statement: create table placement ( pclient_id int, pagent_id char(20), plog int, pemp_id int, start_date date, pay int, constraint pk_placement primary key (pclient_id, pagent_id, plog, pemp_id), constraint fk_pclient foreign key (pclient_id) references client on update cascade on delete cascade, constraint fk_pagent foreign key (pagent_id) references agency on update cascade on delete cascade, constraint fk_plog foreign key (plog) references phone_log on update cascade on delete cascade, constraint fk_pempid foreign key (pemp_id) references employers on update cascade on delete cascade ) engine = innodb; can anyone help me

Ok guys I can't figure this one out. I'm am trying to restore a database. I've created the database and then tired to restore my backup file. Here is my syntax: restore database NorthwindReportData from disk = 'G:\Program Files\Microsoft SQL Server\MSSQL\Backup\NorthwindReportData_FullBackup./BAK' with norecovery, move = 'NWRD_Data' to 'G:\Program Files\Microsoft SQL Server\MSSQL\Data\NorthwindReportData.mdf', move = 'NWRDLog' to 'D:\sql_logs\NWRDLog.ldf' I keep getting the error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'to' I know the medianame and mediapassword or optional, so what am I doing wrong? R

r u still there?

nope still nothing. the background image is in a seperate folder then the html page. that was I though you had to move up a directory

I'm sure this doesn't belong here but no one is responding in the css area. I've forgotten how to move about my directories. I have a folder WWW for html files and a folder images. For some reason I can't pull up my background image through css. background-image: url(.../images/background.jpg); What am I forgetting?

Ok guys this is going to be a stupid question but I forgot how to move through directories. I have a folder WWW for my html files and a folder for images. I'm trying to get my background image displayed through my css but I'm forgetting something. Here is what I have background-image: url(.../images/background.jpg); of course my background image is not showing up. what am I forgetting?

Gee thanks thats what i'm striving to be. I'll just play around with photoshop and see what i can do.

I'm just looking for something that will make it look nice and not some bland links with submenus. Like the examples you gave on the link. I'm working with photoshop now but everything is looking like a child drew it.

All the HTML and CSS examples are pretty generic and bland. Is there no way to get it to look other wise using html and css

One work frowns on downloads. Two I'm trying to learn more code.

The menus off the link looks great but is there a example that doesn't involve me downloading. I'm looking for a code example.

Hey guys I'm trying to create a menu that includes sub menus. Is there a way to create a really nice visually appealing menu without javascript or flash?

I got it I just keep forgetting to do the permissions. Thanks for your help