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

Ding frys are done I'm still not used to php sql I'll create the permissions thanks

Come to think of it I never assigned permissions when I created the database does that affect anything?

I don't know the username I just pulled something out my bum and I have no password. How do I find the db username. When I created the database i just did the usual create database client2;

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'user'@'localhost' (using password: YES) in Same error

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\projects\new_client\WWW\dbconnection.php on line 19 I don't know anything about odbc all I've ever used is mysqli or mysql

It doesn't like the $dsn or the other vars, it says its unexpected

Are there any parameters? I've always used mysqli but for some reason it just doesn't want to work now. I don't understand why all of the sudden it doesn't want to work.

Access denied for user 'username'@'localhost' I've tired root and it didn't work either. I was reading on another form that using root leaves a hole for people to get into.

ok wtf i get Access denied for user 'ODBC'@'localhost' (using password: NO) Why would my access be denied when I can access it through the command prompt and run queries through there?

echo mysqli_error($db); gave me this Couldn't fetch mysqli