Help with database Design

2002-12-22 Thread Ricardo Fitzgerald
Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other

Permissions -- After grant all on *.* to admin@localhost --- I got access denied

2002-06-12 Thread Ricardo Fitzgerald
Hi, I added a table to my phpnuke database, all connections to this db work perfectly, except this custom table, it gets data from a form. Before I was using it just to show data was succesfully retrieved, and it was working now I added these lines: ? $db = mysql_pconnect(localhost, admin,

Syntax dilemma

2002-06-02 Thread Ricardo Fitzgerald
Hi, I'm having trouble trying to insert form data into a mysql db, the thing is my client wants table data to be splitted, I mean some data comes from the first form, and the rest from another form. This is a portion of the php script. // Add together proper fields to enter birth date

Newbie question : Can't connect to database through a web interface

2002-05-31 Thread Ricardo Fitzgerald
Hi, I'm developing a web application using mysqld as a localhost but accessed from anywhere. My problem is simple, after entering form data, and execute the php script, always returns an error I wrote in case of unsuccesful connection to the db. I did everything , create a user with many

Newbie -- Error codes

2001-08-09 Thread Ricardo Fitzgerald
Hi, I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql server as root and trying to use a sample database from Paul Dubois book MySql, I ' ve got the error 13, can't create directory/file ./samp_db/president.xxx. The thing is I'm using an example DB, any help ?