Re: [MANY to MANY] relationship with MySQL ???

2002-04-17 Thread Robbie Newton
> ...So the table song_x_artist contains references to all artists in a > song and vice-versa. (Field names correspond between tables.) How does song_x_artist reference the other databases? Is there a way to set up a field to always be a reference to another table? I am not quite sure what you

[MANY to MANY] relationship with MySQL ???

2002-04-17 Thread Robbie Newton
Hello all, [~~I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist~~] I have a sampling section on a site that I am working on and am trying to find out how to display a table of the artists featured in that song. The sample section works as follows

HELP! MySQL service will not startUp

2002-02-17 Thread Robbie Newton
I have been working all night on something then Outlook Express crashed my machine and now after restarting, MySQL service will not start. I am running it on Win2K Pro and have had no probs until just now. I right click on it and choose WinNT::Start the service. The dialog comes up asking if I wan

Re: Warning: mysql is deprecated???

2002-02-17 Thread Robbie Newton
I just started going into some of the other files that will need updating and I have run into another little prob dealing with the same thing Here it is, maybe you can shed some light on it for me. $result=mysql_db_query("$DBName","SELECT Date,BuyerID,OrderNumber FROM Buyers"); The $Result v

Re: Warning: mysql is deprecated???

2002-02-17 Thread Robbie Newton
> .. if mysql_db_query is what you're using. Actually below is waht I am using... mysql("$DBName","INSERT INTO Category VALUES('$Category','')"); After your response, I changed it to... mysql_select_db("$DBName"); mysql_query("INSERT INTO Category VALUES('$Category','')"); Works like a charm

Re: Warning: mysql is deprecated???

2002-02-17 Thread Robbie Newton
> It means something is out of date...looks like you need an update of > something... This is the line 7 that it is talking about How do I know what is out of date and how to fix it? Are there any utilities out there for updating scripts or do I need to manually go into each .php file and upd

Warning: mysql is deprecated???

2002-02-17 Thread Robbie Newton
mysql_query() instead ) what the warning says??? Any help would be greatly appreciated. TIA -Robbie Newton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the