Hey ranchcharm,

No, I sort of let it go a while back and focused on other things. I kept thinking about it though, on and off. I have a feeling I could possibly apply a stack model used to store...

jwaldron82:

It is incorrect to assume that the choice of a database system "requires" a scripting language. In fact, in many cases a scripting language will support many database systems. For...

There's nothing like posting a question to find the answer yourself shortly after...

I solved my problem by adding this at the beginning of my script:

putenv("PATH=" .$_ENV["PATH"]....

Hi all,

I'm using exec() to launch external commands from a web application under OS X Leopard. To put my problem in context, when I launch this:

exec ("export", $output);

I get this:
...

Moxdillin, I disagree that mySQL plays a major role in application functionality. Here's my philosophy on the subject.

As the application designer, you have to decide first what your application...

I suggest you start a new thread for that since I never used either Dreamweaver, IIS or ASP. I'm of the AMP (Apache, MySQL, PHP) school of thought and do all the scripting myself in a programming...

One thing I learned about databases is that you should never spare the number of tables. Fewer tables might appear less complex but often don't represent reality as it is.

Overall, it's looking...

Ok, it's a good first draft. Few pointers:

- In an ERD, we usually don't bother with PKs and FKs, that's something that comes later in the data model diagram. ERDs only define entities and their...

The way I designed it so far, the users actually don't need to know the structure of the database. I present them with a web form that contains select boxes for tables, fields, operators and even...

There's certainly merit to the idea as it solves reason #2 in my previous post. It makes it somewhat harder however when wanting to edit the query, I would have to:

a) parse the WHERE clause
b)...

Actually, mysql is connect to PHP, not to Apache and no, they don't have to be in the same directory. The php.ini file on your system must have a line like this:

extension=mysql.so (or mysql.dll...

I remember having connection problems when I started which I resolved by appending the mysql socket address to the host.

mysql_connect (host:socket, username, password)

I can't remember...

Try opening a command window and check if you can connect with the root user and 'password' as a password:

> mysql -u root -p
Enter password: password

(make sure the mysql command is in your...

First of all, entities are supposed to be real-life objects or concepts. In my opinion, a student status cannot be considered an entity but rather an attribute of a student. In other words, a status...

Correct.

I feel we're going a little off topic here but if you really must know, the data is medical and I already have a controlled ad-hoc environment with everything you suggest.

The purpose...

Since it's the only place left with no error detection, how about trying:

if (!mysql_select_db("users", $con))
die ("Database 'users' not found");

Do you have any knowledge of web programming? Database design?

I suggest you buy yourself a good book to get started, something like this (http://www.oreilly.com/catalog/webdbapps2/) or this...

You're welcome!

So...

$query = "SELECT kusy FROM ciste_media WHERE medium='$medium' AND typ='$typ' AND kusy=$kusy AND obal='$obal' AND znacka like '%$vyraz%' ORDER BY kusy ASC";
die ($query);

Oops, $kuzy should be $kusy, my mistake.

Also, %vyraz% should be %$vyraz%, my mistake again... I apologize, I don't know these words... ;)

I'm looking at your previous reply (#7) in more detail now and I just noticed that a few things have changed since your reply #5.

Try this:

$query = "SELECT kuzy FROM ciste_media WHERE...

Ah yes, also I never had any luck with select * from... Try selecting specific fields (for example select field1, field2 from ...).

It appears you would need single quotes around your text litterals, like this:

select * from ciste_media where medium='CD' and typ='R' and kusy=15 and obal='rolka' and znacka like '%verbatim%'...

A good way to debug this is to run this command before you run the mysql_query:

die ($query);

It will list the content of the $query variable and stop the script. Could you post the result?

Did you give you file a .php extension or .htm? It needs .php in order to work.

ERDs are always a tad difficult when you haven't done that many. I'd be glad to help but first could you please give more details on what a "Project Allocation System" is? What does the system do?...

No, since the expressions translate to SQL statements (the WHERE clause to be more specific), I'm sticking to the usual AND and OR operators for the moment.



Yes, in the current model there is...

Fair enough, here's a little more information.

I'm writing a data mining application where the database has about a hundred tables sharing close to a thousand fields among them. The application...

Here's a few questions in an attempt to clarify your problem:

1) Can a given User also be a Client and a Service Provider at certain times?
2) Inversely, are Service providers and Clients always...

I guess where I'm going with this question is: do you care about anything at all? Salary? Working hours? What kind of company you'll work for, either big corp or small biz? Do you see yourself...

Good luck!

I understand the problem differently. Here's my view, not in pseudo-code but just giving the overall logic.

Problem 1:
Get from the user a list of students but no test scores. When the student...

Hmm, that's a simple question that requires a long answer. Here's a few pointers.

1) First, HTML alone does not allow linking a website to a database. You need another language in between that...

Further on the StudentSubjects table...

You have a one-to-many relationship between StudentSubject and ExamResults. Is that a true representation of life, in other words can one student, for one...

I'll help, what's your issue?

Hi all,

(this is a repost from here (http://www.daniweb.com/forums/thread112412.html))

I'm working on a relational data model in which I'd like to store boolean expressions. I'm a little rusty...

Joe, welcome to the field! I'll be glad to provide my 2¢ worth of experience.

My first question to you: where (and I mean this in the geographical sense) do you see yourself working? Is it in an...

As a brief introduction, my name is Burt, French Canadian (thus LeBurt), I live in Québec City, previously lived in Las Vegas 'coz my wife performs with Cirque du Soleil.

I'm a computer scientist...