Search results for query: *

I still get nothing, even when i do it from my MYPHPADMIN window

smallint(6)

yes i did say that. Allow me to correct myself. there is 1 record in the table that has that flag delfg set to 1. there however 9 records in the table in total. when i do the NOT EQUAL to SELECT i hope to return 8 records. What i am saying is, when i do the SELECT equal to the 1 record it...

Thanks, i've tried that and it still doesn't work.... the thing is... It works when i ask it to return record equal to it. but not when i ask not equal to it... any other suggestions?

Hi, i have a field called date, and a field called delfg. I'm using this in a php webpage, and it returns no results when i execute it. When i execute it without the [AND delfg <> '1'] part it works fine. there is 1 record in table that has the value "1" in the field delfg...

i've tried it as $result = mysql_query("SELECT * FROM practicelist WHERE date >= now() AND delfg = '1' ORDER BY date ASC"); and it returns 1 record (which is the correct result) i've tried $result = mysql_query("SELECT * FROM practicelist WHERE date >= now() AND delfg != '1' ORDER BY date...

i have a field called date, and a field called delfg. I'm using this in a php webpage, and it returns no results when i execute it. When i execute it without the [AND delfg <> '1'] part it works fine. there is 1 record in table that has the value "1" in the field delfg. mysql_query("SELECT *...

Hi, This morning we noticed that there was a corrupt disk in our raid array. We quickly tried to rebuild the disk on the array, but later discovered it was a faulty Hd. We got onto dell and they are sending a replacement ASAP. - Which is fine. However.... Now a lot of this seem to be wrong...

Thanks shadedecho! Perfect, works really well... i didn't know about te foreach loop... i do now. Regards, Ian

Hi, I’m sure this is simple one to most people, I just probably been thinking too hard... :) problem : I have a mini CMS I’ve created. As usual i have an add, edit & remove screen for each item. (i.e. products). how do I get a value from my MYSQL and auto select the right one in the combo...

Hi, Unfortunately, I don't know ISA at all well so please bare with me. At present ISA 2004 is installed on our Windows 2003 SBS. We would like to be able to use the web traffic facility to limit and monitor staff internet usage. I know that to control the filtering by user we have to buy...

Thanks for everyone's help. Earthand fire - nice method, thanks. TipGiver - Useful false on dispose. Cheers

Will do SavantMan, I aint beaten yet... It just makes me think if i have trouble doing something simple. how on earth am i gonna be able to do anything complicated! anyway. i'll keep bothering this board with questions when i get stuck. Cheers

Caoamo, That explains everything. Thank you very much.... i dont' know how im gonna get on with .net it seems to be 1 step fwd 3 steps back...! I'll keep at it. Thanks everyone for the help. Cheers

SavantMan, When i step through the code, it gets to the .close and closes the login form... Then when it steps past the end sub of that piece of code it closes the whole application. I don't really want to use .hide. What am i doing wrong, why it it so confusing compared to vb6? Thanks

Doesn't hide just hide the form though. I don't want to have it still loaded into memory. how do i unload it. What .dispose() do..? sounds dangerous :) Thanks for the post djj55

Hi, I am new to vb.net (but have been using vb6 for a while), and i am trying to do something extremly simple. But it is frustrating me...! Basically i have 2 forms. 1) Loginfrm 2) Userfrm I load the login form, and when i press ok on it i want it to close the login form and open the user...

Thanks guys. Magic! Just what i needed! sleipnir214, i have used code based on your example, becuase i needed it to open in a new window. Cheers Ian

Hi, On my site i have 3 command buttons labelled Google, Yahoo & MSN. With 1 'search' text box above. I would like to be able to press either of the search buttons and for it to search from the single text box and then open a new window from that specific search. Could you give me a hand in...

Hi, On my site i have 3 command buttons labelled Google, Yahoo & MSN. With 1 'search' text box above. I would like to be able to press either of the search buttons and for it to search from the single text box and then open a new window from that specific search. Could you give me a hand in...