remote connection php code

2004-07-20 Thread Business A2Z
Hi All Could someone give me a clue or a snippet of PHP code I can test a romte connection to my MySQL DB for my website please? Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: oscommerce online offline replication

2004-07-12 Thread Business A2Z
ell> mysqladmin drop db_name >shell> mysqladmin create db_name >shell> mysql db_name < backup-file.sql > >see also: >http://dev.mysql.com/doc/mysql/en/mysqldump.html > >olinux > > >--- Business A2Z <[EMAIL PROTECTED]> wrote: >> Hi All >> &

oscommerce online offline replication

2004-07-11 Thread Business A2Z
Hi All This may be a longshot or it could just be the place where the answer is. I have asked something similiar before regarding this but never could a clear view of the way to proceed. Anyway, here it is. Simply I have an offline mirror of oscommerce what I woould like to do is keep the onlin

html stored not rendering in output

2004-07-03 Thread Business A2Z
Hi All I have a spate of questions about mysql fields but I'll start with this one as its probably the simpliest of mistakes I am making, I am using php echo to retrieve records echo "$fieldrecord"; where the field have yet the page it is displayed in does't show the break looking at the source t

RE: odbc reverse

2004-06-15 Thread Business A2Z
Administrative interaction (leaving me to deal >with other issues). > >What will work for you depends on what you have available in terms of time >and options and maintainability. > >Shawn Green >Database Administrator >Unimin Corporation - Spruce Pine > > &g

RE: odbc reverse

2004-06-15 Thread Business A2Z
umentation of >OLE DB, ADO, ODBC, VBA, and the product Excel as some combination of those >will allow you to create and keep a "live" connection to your data. If you >do not need interactive database connectivity, try the bulk export/bulk >import method I described

RE: odbc reverse

2004-06-14 Thread Business A2Z
ou >logically think it should be. > >http://msdn.microsoft.com/ > >Sorry I can't be more helpful but I haven't used EXCEL+ADO+ODBC to bind to >a live dataset in a VERY long time and I am sure to say the wrong thing. > >Shawn > > > > >

RE: odbc reverse

2004-06-14 Thread Business A2Z
h. >That site has a **LOT** of information but it's not always where you >logically think it should be. > >http://msdn.microsoft.com/ > >Sorry I can't be more helpful but I haven't used EXCEL+ADO+ODBC to bind to >a live dataset in a VERY long time and I am su

RE: odbc reverse

2004-06-14 Thread Business A2Z
combination you are using. > >Eventually it all boils down to 3 different SQL commands: SELECT, INSERT, >and UPDATE. > >Please give us more details so that we can understand what you are trying >to do. > >Yours, >Shawn Green >Database Administrator >Unimin Corporati

odbc reverse

2004-06-14 Thread Business A2Z
Hi All I have a puzzle or more like a mental block that needs some sensible thought inputs please. If I odbc inot mysql and pull out records and make chnages how do I put the changes back into mysql ? Hope there is a simple response to this Andrew -- MySQL General Mailing List For list archi

query problem

2003-11-10 Thread Business A2Z
Hi All MySQL users I am having a slight problem and getting inot a bit of a tizz. I have two tables and I am trying to produce a dropdown select menu whilst creating a join. The two tables are as follows... CREATE TABLE itinerary ( i_id int(3) unsigned NOT NULL auto_increment, i_title varch