intodesi

Very Cool thank you very much for the example, I can see how what I want to do needs to be done, i didnt know about the "ORDER BY RAND()" string. Thanks again, I will post back as soon as I am able to get it tested.

Hello, What I am trying to do is get semi random data from a MySql table. I have a database named kidpatrol, which has 4 tables under it, kids, parents, cards, and tracking. The first thing in my project that I would like to complete, would be figuring out how to grab a semi random row from the cards table, based on user selection and past events. in the cards table, there are 4 rows, card_id, card_diff, card_name, card_text. card_diff is for card difficulty, what i need to be able to do is when I display a choice of three difficulties (which i can do) and when that specific difficulty is chosen a random card is displayed, if that card has not been displayed before. so my script has to be able to 1) Get a random card based on difficulty. 2) Make sure that the Card has not been used before a) Using the tracking table to accomplish this. Tracking table has three rows. kid_id, card_id, and date. Any help would be great, basically I gave a whole bunch of info, but all i need to do is figured out how to grab the data from the cards table randomly after the kid selects difficulty, and then make sure that the specific card has not been used. Thanks

I am writting ( attempting ) a small app and in the app I need to talk to a mysql db So I have 4 fields for user input server ip dbname dbuname dbpass and two buttons test connection and connect I am using this code for my Test Connection Button Dim conn As New MySql.Data.MySqlClient.MySqlConnection Dim myConnectionString As String myConnectionString = "server=192.168.4.3;" _ & "uid=root;" _ & "pwd=d3dikatian;" _ & "database=eq2server;" Try conn.ConnectionString = myConnectionString conn.Open() Catch ex As MySql.Data.MySqlClient.MySqlException MessageBox.Show(ex.Message) End Try But when I debug and hit the button it says cant connect to 192.168.4.1 but in the code I am not trying to connect to 192.168.4.1, I am trying to connect to 192.168.4.3 So what I am thinking is the code or connector.. isnt trying to connect to the remote mysql.. so I am lost.. Any help would be apreciated

I would like to add http://www.hostony.com can I post my affiliate link ?

Your's looks cool.. I havnt seen AVP yet, guess i should.. looks good

took me about three hours not counting the 2 hours+ of research time figuring out premieire cs3 Let me know what you think

Yeah, as soon as I can get the significant other to do it

Wow, I really must thank you Barand.. I dropped that table, and used the sql you last posted, and all is well.. but i dont understand why i could make PRIMARY KEY (`uid`,`project_id`) from the table i already had... but anyways, thank you nm I see how now its what i get for using phpmyadmin i need to look for the right stuff to do

So this is the table data I get INSERT INTO `projects` VALUES(0, 1, 'Test', 'whatever', 'Finished', 'none', 'ferret.jpg', 'cat.jpg', '0000-00-00 00:00:00'); INSERT INTO `projects` VALUES(3, 2, 'Test', 'teast', 'test', 'test', 'test', 'test', '2008-05-25 00:00:00'); so "0" and "3" are uid's and the second numbers are the project_id's which are auto incrementing, but not starting over for each uid

so my primary key looks like this PRIMARY KEY (`project_id`) not PRIMARY KEY (uid, project_number)

kk and Barand, I dont think i can make two primary keys in the same table? I get a sql error? and how do i move a row up in a table thats already been completed? from what you showed me on how my rows should be, project_id being second, how can i move that down without recreating the table?

well in the client table uid needs to auto increment, I will show my client table CREATE TABLE `clients` ( `uid` mediumint( unsigned NOT NULL auto_increment, `f_name` varchar(60) NOT NULL, `l_name` varchar(60) NOT NULL, `c_name` varchar(60) NOT NULL, `email` varchar(60) NOT NULL, `phone` varchar(60) NOT NULL, `u_name` varchar(60) NOT NULL, `u_pass` varchar(60) NOT NULL, `client_url` varchar(60) NOT NULL, `last_login` datetime NOT NULL default '0000-00-00 00:00:00', `activated` enum('1','0') NOT NULL default '0', PRIMARY KEY (`uid`), UNIQUE KEY `u_name` (`u_name`), UNIQUE KEY `client_url` (`client_url`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; and this is my projects table CREATE TABLE `projects` ( `project_id` mediumint( unsigned NOT NULL auto_increment, `uid` mediumint(9) NOT NULL, `project` varchar(60) NOT NULL, `description` text NOT NULL, `status` varchar(60) NOT NULL, `file_loc` varchar(60) NOT NULL, `invoice` varchar(120) NOT NULL, `proof` varchar(120) NOT NULL, `l_update` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `project_id` (`project_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

ok the IE bug on the contact page is fixed, in IE all width's etc have to be defined for each row/column in a table, while in FF, only the width on the first row/column needs to be defined.. FF makes for slack coding.. makes you lazy i guess

Yeah IE always screws me.. I can fix that though. whats weird is that contact form is in a table of its own, so not sure why its offset.... IE just likes to be difficult easy fix though i think. and padding is fixed, I will have to go through all my pages to check for compatibility issues I am assuming, thats ok though. and thanks for everyones input I am a horrible designer i just like code... and my GF is the hraphics artists.. so its hard to get her to do things right hehe..

yeah project_id is a row as well as uid, the table is projects, i want project_id to auto increment based on each uid, which doesnt auto increment in the project table, uid is part of my clients table, which auto increments there. so each client gets a uid that auto increments in the client table, then in the projects table uid links each project to a customer. but i want each customers project to auto increment starting from 1, its not a nescessary application in my database, most likley its useless, but i would still ike to know if its possible