a query question1031 (1/30/2012 6:53:50 AM) comp.databases.ms-access Hello I have a table with some 20 columns one of which can have the text "yes" in it or is left blank. I would like to have a query which only shows those columns with "yes" in them. At the moment I see all... geoff
a strange error message?2664 (12/30/2011 8:38:31 AM) comp.databases.mysql Hello I asked this question a few days ago but am not getting any further suggestions so am trying again! I have just exported a table as .sql from one server and imported it into mysql on another server. Th... Geoff
what does this error message mean?267 (12/25/2011 8:12:55 AM) comp.databases.mysql Hello I have just exported a table as .sql from one server and imported it into mysql on another server. The table seems to have loaded OK but I see the following -------------------- Error SQL query: /*!40... Geoff
odd display of mysql table contents?2342 (5/31/2011 4:55:42 PM) comp.databases.mysql Hello I have come across an new oddity, to me - perhaps someone can see why? I am displaying the contents from 2 different tables in a browser using php files which are identical except for the names of the ... geoff
a more elegant way?431 (5/30/2011 2:52:17 PM) comp.lang.php Hello No doubt there is a better way of expressing this?! Pointers please ... if ($value > 0 && $value 10 && $value 20 && $value 30 && $value 40 && $value 50 && $value 60 && $value 70 && $value 80 &&... geoff
further table design questions3445 (5/29/2011 7:31:52 AM) comp.databases.mysql Hello I had some very helpful comments in my earlier post but am still struggling to get a better table design. I have made a small step (?) by using an auto increment id in the p2_users table and by using my... geoff
mysql table order and php sort() ?335 (5/23/2011 7:19:07 AM) comp.databases.mysql Hello Using the code, echo "Order: $key, Number: $value "; I see $value as 11 to 20 followed by 51 to 60 but when the data goes into the mysql table I see 59 down to 51 followed by 20 down to 11 followed by ... geoff
silly mistake in the mysql part?627 (5/22/2011 11:32:17 PM) comp.databases.mysql Hello I have this php for adding data to mysql table, for ($num = $first_num; $num "; echo "(" . "'" . $_SERVER['REMOTE_USER'] . "','" . mysql_real_escape_string($_POST['usercode']) . "','" . mysql_real_escap... geoff
too many columns/rows?2646 (5/21/2011 8:43:46 PM) comp.databases.mysql Hello I know that I could organise the data better but does phpmyadmin or mysql have a problem with a table which has 600 columns and 100 rows? Each column holds approx. 10 chrs. Cheers Geoff ... geoff
according to MS, stricmp is deprecated2010 (4/25/2013 8:32:53 PM) comp.lang.c++ According to Microsoft Visual C++ 2005, stricmp
is deprecated and they want us to use _stricmp.
Does anyone know why?
Does anyone recommend a good replacement?