Sql gurus

Hi I am working on a search logging script to count the most popular word or phrases searched for. Table I could add a line for each search, and aggregate the results for reports, but I was wondering about the following which would keep table sizes down. | search word | count |

RE: Sql gurus

--- -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 17:58 To: Peter Lovatt; [EMAIL PROTECTED] Subject: Re: Sql gurus Hi Peter, I am working on a search logging script to count the most popular word or phrases searched for. Table

Rebooting MySql

Hi Is there any reason to reboot MySql periodically? My server has been up for just under 6 months without a reboot, and some of the queries are noticeably slower. This may well be because the data has grown, but I wondered if there is any memory leakage at all. Anybody with more experience

RE: Is The MySQL Mailing List On Crack?

no! about 150 messages today Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

Logging visits using a database

Hi Excuse the cross post I am thinking about building a logging tool to do visit analysis using SQL, rather than doing log file analysis. The aim is to analyse requests for dynamic pages called via php as well as static pages. Static pages will use an include for logging. Php calls may have

RE: Security concerns on webserver with PHP InnoDB

-Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 21:31 To: [EMAIL PROTECTED] Subject: Security concerns on webserver with PHP InnoDB I'm creating a web application with MySQL, PHP, InnoDB and I need to know whether I should split the one large

RE: [ANN] Blue World ...

Hi A few points 1. 1 (?)Spam, 40 people filling my in box with complaints about it. We get very little Spam on this list, if you don't like it, bin it. 2. MySql users are diverse. We have php, perl, c++, Delphi, Access and VB mentioned regularly. So why shouldn't we be interested in

RE: SQL query question - using LIKE

Hi $query = 'SELECT * FROM Table WHERE FirstName LIKE %'.$firstname.'%' ; if($lastname)$query.= ', AND LastName LIKE %'.$lastname.'%'; if($region)$query.= ', AND Region LIKE %'.$region.'%'; if($loan_officer)$query.= ',

RE: Copying a Table

select * from table1 insert into table2 both tables need the same structure Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473

RE: A rookie question

--- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Paul Romanic

RE: Need to match similar words

SOUNDEX might meet your needs http://www.mysql.com/doc/en/String_functions.html Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473

RE: Performance Question.

Hi I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run queries on datasets of 220,000 SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time than I can count (0.1 sec at a guess) The insert/update bit is the bit which will dictate the speed - how many

RE: Performance Question.

--- -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: 06 October 2002 21:08 To: Peter Lovatt; Robert H.R. Restad; [EMAIL PROTECTED] Subject: RE: Performance Question. I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI

RE: using php to connect to a 2nd mySQL server

the port is part of the server parameter in the connection eg port 3307 mysql_connect ( localhost:3307 , username , password ) http://www.php.net/manual/en/function.mysql-connect.php has the details HTH Peter --- Excellence in internet and open

RE: Updating the same Databases with new fields automatically

hi ALTER TABLE `database1`.`tablename` ADD `newfield` TINYINT NOT NULL; ALTER TABLE `database2`.`tablename` ADD `newfield` TINYINT NOT NULL; ALTER TABLE `database3`.`tablename` ADD `newfield` TINYINT NOT NULL; ALTER TABLE `database4`.`tablename` ADD `newfield` TINYINT NOT NULL; etc or script

RE: Urgent Help! Importing Data from Text File...

Hi Two thoughts try \r\n instead of \n or if you are getting warnings it may be that there is a problem with the data - illegal characters or something? if neither works email me offlist and I will take a look, if that helps. HTH Peter ---

RE: Inserting Master and Details records

Hi insert_id returns the key value. I use php, and the mysql_insert_id is the last insert_id on that connection, so even if other processes have added new records in the time the script runs the insert_id is the correct one. You can then use that as the key in the detail records. HTH Peter

RE: Tips for LARGE system

Hi Bigger than my experience, so just a suggestion - have you looked at replication? If you have a master which does all the processing and (multiple) slaves which handle all the reads then you might benefit from cheaper Intel hardware and have a more robust system to boot. Good luck! Peter

RE: mysql access via php function, hlp with syntax

Hi If this is the full code you are missing the final } to close the function I find it helps to comment the closing brackets HTH Peter function dtb_qry_tbl_dsp($qry, $qry1, $qry2) { $result = mysql_query($qry); $result1 = mysql_query($qry1); $result2 = mysql_query($qry2); $i = 0;

RE: Re[4]: [PHP-DB] database synchronization

--- -Original Message- From: Martin Hudec [mailto:corwin;corwin.sk] Sent: 29 October 2002 09:18 To: Peter Lovatt Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re[4]: [PHP-DB] database synchronization Hello Peter, okay :)))so far I understand...buthmmm let me

RE: select using regexp

Hi You could use either normal or fulltext searches. Regexp may well be a good answer (not used it myself). The following should also work SELECT * FROM table WHERE field LIKE % cat % OR field LIKE % cat. % OR field LIKE % cat, % (note the spaces to make sure you get only complete words) or if

FW: php J2EE .NET

Hi There is an article on sitepoint.com about benchmarking J2EE and .NET and some controversy over the result http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52 Does anybody have experience of php/MySql in comparison with either of the above in terms of efficiency or ultimate

RE: SCHEMA, ARCHITECTURE ???

-Original Message- From: William Martell [mailto:willmartell;yahoo.com] Sent: 11 November 2002 20:02 To: MySQL Main List Subject: SCHEMA, ARCHITECTURE ??? Hello All, How do I determine the best architecture for my MySQL database? Years of painful but fulfilling experience :) Seriously

RE: Table solution

phpMyAdmin has an 'export to csv or Excel' function. If you are running php this will produce a CSV file you can import directly into Excel http://www.phpwizard.net/projects/phpMyAdmin/ hth Peter --- Excellence in internet and open source software

RE: assigning a user/passwd to a database

Hi have you looked at GRANT http://www.mysql.com/doc/en/GRANT.html I think it is what you are looking for Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net

RE: access denied 1045

Hi Cobalt uses 'cobalt-mysql' as the default mysql root password. I spent hours trying to sort this one out, reinstalled the whole thing, manually recreated Mysql database all sorts Stupid to use non standard setup really. If that doesn't work come back to me. Peter

RE: Does this list work??????

Hi Yes the list works! It sounds as though you do not have support for the character set you are using. Check the MySql manual for supported character sets. HTH Peter --- Excellence in internet and open source software

RE: i'm just missing something

Look at GRANT Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473

RE: converting from foxpro to mysql ???????

Hi Postgre might be a better bet, as it supports more of the features you are looking for. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel.

RE: Warning: Supplied argument is not a valid MySQL result resource

Hi It means you are refering to/using a result id that does not exist. Maybe the query changed or the database is down? Try echoing the query and the error echo mysql_error ( [resource link_identifier]) if not could you send more details to give us a little more to go on Peter

RE: MySQL on Cobalt Raq2

Hi Installation packages for the Raq range can be found at http://pkgmaster.com/packages/raq/ From the main control panel go to 'Control Panel' and 'Install Software' MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps worth a try. I installed it and it was almost

RE: -- e-shop

Hi We are in the process of developing Ultra High Availability ecommerce sites based on php and MySql. 1. The software itself is well tested 2. The site is duplicated on two or more servers in separate data centres, with live replication. 3. Nameservers for the domain are on the

RE: Help w/Query

Hi Change your WHERE statement to WHERE stns.stns_id=1 AND table.ent_nws_id 3 ' HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel.

RE: Sage Line 50 and importing into MySQL with ODBC

Hi I did some digging on this going back. From memory, the ODBC drivers vary a little from version to version of Sage. I think they are also read only, which may not be a problem if data is only being imported into mysql. I contacted a local Sage reseller who was very helpful, and knew Sage

RE: Uppercase first letter of each word

this is for php, if you are not using php then try something similar //use explode to create an array with one word in each item $sql_array = explode( , $sql_text) //loop thro the array while(list($val) = each($sql_array)) { $val = ucfirst ($val); $new_sql_text .= $val ;

RE: Newbie Question

Hi If you are developing for a Windows desktop, MyODBC with Access, Paradox or Delphi all workm, from experience. If you are developing for Linux desktop, then not sure, but perhaps others have experience Peter --- Excellence in internet and

RE: Two database servers, same physical server

Hi If the databases are not too big, and are on the same machine, you could just copy the directory with the databases in. If you need to restore the database just copy it back. I think this is OK, though you might want to stop mysql to lock the database. I have only done this a couple of

RE: Maximum number of rows in the table

Jeremy at yahoo quoted one with 280 million rows, I think. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: Distributed MySQL : How to synchronize ?

Hi I have built and am testing a php module that is capable of this. I have an ultra high availability project where it must survive a server or network failure and switch seamlessly to the backup server. All queries are executed through a db abstraction class. It basically does the same as

RE: Project Time

Hi Seems to be offline, can't get it from here too - its giving 500 server error Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: Problem with DDL

WHEN is a reserved word, so you need to choose another name for that field hth Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: job payment.

Hi How long is a piece of string..? Hourly rate for independent work in the UK is £20-35 ish, roughly US$35-60. I think US programmers are forbidden to discuss rates, as it is considered price fixing! You could access Access through ODBC, using php. This will not support a busy site

RE: password for databases

Hi look into GRANT on MySql Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

RE: query

insert into table (auto_inc_field) values (1000); mysql will carry on from there Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: Help needed with JOIN on 3 tables

Hi SELECT b.* //all fields from builder FROM builder b //define tables and aliases , builder_category_link l , category c WHERE (b.builderID = l.builderID) //linking builder to link table AND (l.categoryID = c.categoryID)

RE: Creation query problem!!

is read a reserved word? --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original

RE: Can I be an ASP with PHP?

No problem I have a mysql server sited 150 miles from the php server (more by accident than design, but it works day in day out) Just set the connection parameter with the IP of the Mysql server and it works. php doesn't know or care whether mysql is on the same machine or one the other side of

RE: Referring Page in PHP/SQL

if(ok) { include('zap.htm') } else { include('zip.htm') } --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: Understanding relational database setup/construction

Hi Not sure about sites but try searching for 'database normalisation tutorial' I found http://www.codelearn.com/rdb/rdbd_nt1_s.html which looks to be a reasonable start. Peter --- Excellence in internet and open source software

RE: Field Naming Standards

I share most of these conventions, and I think the key is consistency. Consistency makes the database usable, without guessing or having to refer back to notes or other uses of the table or field. My golden rules are 1. Key names are unique within the database this avoids any confusion

RE: MySQL to MS' Access '97

Use MYODBC (see http://mysql.com ) to connect to the mysql database Within Access database use 'link to external data' for mysql and use an INSERT query to get the data into the Access table HTH Peter -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: 03

RE: Can't access MySQL via PHP

Hi should be mysql_connect(fred.com, fredsusername, fredspassword) or mysql_connect($host, $username, $password) Only needs quotes if you are using actual values HTH Peter -Original Message- From: Imran Aziz [mailto:[EMAIL PROTECTED]] Sent: 03 November 2000 19:49 To: [EMAIL

RE: Securing username and password in script file

I don't think there is a secure way of running php on a shared server. I have a dedicated server which uses this 'property' to have a single shared php codebase for about 20 domains and subdomains. I looked at ways of securing it but, fundamentally, php under apache runs the same user for

RE: OT: Securing username and password in script file

-Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 11 November 2001 14:25 To: [EMAIL PROTECTED] Subject: Re: OT: Securing username and password in script file Peter Lovatt writes: I don't think there is a secure way of running php on a shared server

RE: CREATE syntax wrong?

Hi AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal? not 100% sure but it looks like it Peter -Original Message- From: Cesar Baquerizo [mailto:[EMAIL PROTECTED] Sent: 24 March 2003 20:59 To: MySQL Subject: CREATE syntax wrong? Hello, I am on: mysql Ver 11.18 Distrib

RE: Nested SQL QUERY

HI MySQL does not support sub selects/nested queries :( Peter -Original Message- From: Eric Leupold [mailto:[EMAIL PROTECTED] Sent: 29 March 2003 16:43 To: [EMAIL PROTECTED] Subject: Nested SQL QUERY I hope someone can help me with a syntax error I'm getting with a nested query. I'm

RE: update statement, error free but no affected rows?

-Original Message- From: Christian Calloway [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 18:32 To: [EMAIL PROTECTED] Subject: RE: update statement, error free but no affected rows? update students set counselor_id = 1 , school_attending='Univsity of Maryland' where id = 1; I think

RE: [My Solution] Re: Mailing Labels from MySQL database on web

Hi One more suggestion that does work reasonably well. Generate a basic HTML page with a table laid out to suit the labels, in php, with addresses in place Write the page to your webspace as labels.htm (you will need to set permissions to allow this) You then need a program that will open and

RE: Help NEWBIE!

Hi var/lib/mysql/mysql.sock is created when MySQl runs, it may be a permissions problem with the directory - does MySql have write permission for this directory Peter -Original Message- From: Vishal Thakur [mailto:[EMAIL PROTECTED] Sent: 01 June 2003 10:37 To: ABHIJIT NAIK Cc: MySQL;

RE: MYSQL DB PROBLEM

Hi This is a bug. You can fix it by adding a line to my.cnf. Can't remember what but search the archives as it has appeared before. Peter -Original Message- From: Nick Arnett [mailto:[EMAIL PROTECTED] Sent: 01 June 2003 15:54 To: [EMAIL PROTECTED] Subject: RE: MYSQL DB PROBLEM

RE: Mysql / PHP image link problem.

?php if($row_Recordset1['imagecolumn']) echo 'img src='.$row_Recordset1[imagecolumn].''; ? Peter -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 20:57 To: [EMAIL PROTECTED] Subject: Re: Mysql / PHP image link problem. FWIW, there is a PHP-DB

RE: Which database?

Hi I would echo that support is probably the most important aspect of your choice. Unless you have a particularly technically demanding application that needs features only found in Postgres you would be best with MySql You can get an answer to most support questions via this list, or MySql

RE: Column or Table issue

Hi can you post the form/php code Peter -Original Message- From: Steve Marquez [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:26 To: MySQL List Subject: Column or Table issue I am attempting to insert an article into a MySQL table on a remote server, via a PHP Forms script. I am

RE: Which database?

smaller userbase and no commercial support *combined* mean fewer sources of support. With MySql, support from this *superb* MySQL list :) and MySql AB is likely to be better than Postgres support. Open source support (free or paid for) in general seems to be better than closed source equivalents

RE: selecting DISTINCT and COUNT in MySQL

Hi SELECT COUNT(DISTINCT trEmail ) as clicks , trEmail FROM table GROUP BY trEmail ORDER BY clicks DESC will probably give what you are looking for Peter -Original Message- From: Tim Thorburn [mailto:[EMAIL PROTECTED] Sent: 15 June 2003 00:14 To: [EMAIL

RE: why me??!

Hi You need nothing or backtics - ` - around the table name - you have quotes INSERT INTO products VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '-00-00 00:00:00', '0.00', 1, 1, 1, 0); also better to state the field names - if you add or remove a field

RE: Help : my Server dies : Got an error reading communication packets

Hi If you log into MySQL on the command line and enter mysqlSHOW PROCESSLIST ; this should show you what is running. You may find a runaway query. also check the temp disk space while the system is stalling - large joins can use huge amounts of disk space. If MySql runs out of disk space it

RE: SCO UnixWare porting of MYSQL -- stop supporting SCO

Hi I agree the SCO action sucks but Open source software should be just that - open to all, let the courts decide, if it ever gets that far!. Peter -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 01:18 To: Daevid Vincent Cc: [EMAIL PROTECTED]

RE: Need your help in a search query

You could try SOUNDEX(str) http://www.mysql.com/doc/en/String_functions.html which might do what you are looking for HTH Peter -Original Message- From: Tom Johnson [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 14:23 To: [EMAIL PROTECTED] Subject: Need your help in a search query

RE: mysql server wont start

Hi did you run mysql_install_db ? This sets up the mysql database and initial privilages Peter -Original Message- From: Blake Howe [mailto:[EMAIL PROTECTED] Sent: 29 June 2003 19:27 To: [EMAIL PROTECTED] Subject: mysql server wont start OK i am having problems starting the mysql

RE: Access control via a role based security model

Hi You could achive what you want using grant statements, but you still need a user interface to send queries to the database and display the information sent back in a way that is manageble for non techies. There are many ways of building user interfaces, php ( http://www.php.net ) is probably

RE: phpmyadmin .... ?????

Hi If you open the directory where it is installed with a web browser what happens? Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: How can this Oracle Query converted to MySQL

Not directly, MySql does not support sub selects yet. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473

RE: How to change default mysql data-dir in Linux server ?

Search for 'my.cnf' on mysql.com This is the config file that you can use to set the data dr You may need to create it if it doesn't already exist. HTH Peter --- Excellence in internet and open source software

RE: How to change default mysql data-dir in Linux server ?

--- -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: 27 June 2002 14:19 To: [EMAIL PROTECTED]; Peter Lovatt Subject: RE: How to change default mysql data-dir in Linux server ? Peter, Thanks for the reply... Infact my.cnf wasn't there when I

RE: Hardware Planning

Hi A few thoughts. I am not an expert on this kind of use, so there may be others with better suggestions :) If every search is different then your search efficiency is critical. If you fulltext index the field then it should help. If not then what about indexing the text document words. You

XML

Hi I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) I haven't used XML before. Does it take long to work out how to use php/XML? Are there any problems working with large datasets? Thanks

RE: Root pass

Hi Not sure here, but you have logged in as 'admin' on the system. Unless you su to root mysql will use the same user. try either [admin admin]$ su -l to log in to the system as root and then 'mysql -p' to log into mysql or stay as admin but log into mysql as root, under mysql [admin

RE: Soliciting best approach for storing passwords . . .

Hi Just to throw another thought in If you do change the password and send it to them, you have to allow for the fact that their email could have changed - left work, service provider went bust etc etc, or somebody could just enter their email for a joke 8*} and get their password reset. I

RE: text formatting

I haven't seen the rest of the thread, but form data looses all formatting. Line breaks will remain but HTML ignores them look at nl2br() to convert them to br HTH Peter --- Excellence in internet and open source software

RE: text formatting

Hi Try eregreplace(tab, 4 spaces) Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

RE: fulltext searching

Hi If anybody from mysql is listening / watching, www.mysql.com is down, and has been for a while. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED]

RE: Moving a DB from one Server to another

hi Stop MySql on both servers to avoid changes to database during the move Copy the whole directory to the new server restart both Mysql servers Grant permissions on new server Done :) HTH Peter --- Excellence in internet and open source

RE: A beginners proplems.

try logging in as follows [william@localhost william] mysql - u root -p it will then prompt you for your root password you should have access as root after that HTH Peter --- Excellence in internet and open source software

RE: MySQL on a Cobalt RAQ4

Hi Dont use the rpm, go for the package at http://pkgmaster.com/packages/raq/4/ and install it from there, just point and click! Peter --- Excellence in internet and open source software --- Sunmaia

RE: Utility for importing Paradox tables to MYSQL

Hi Not sure if this is simpler or not but.. install MyODBC, set up a Paradox alias for your MySql database Using Paradox, copy the paradox tables to the MySql database. This converts all the field types and copies the data over. I am not sure if it will do memo fields it may depend

RE: FULLTEXT search questions

an indexed column cannot have null values, so it must be defined as 'not null' To fix alter the table so the two fields are not null ALTER TABLE `message1` CHANGE `Title` `Title` varchar(64) NOT NULL etc then run your alter table hth Peter ---

RE: MySQL Manager Connection Config Problem

Hi Generally root is only allowed access from local host for security. Either use a GRANT statement to give access from the host you are using or create another user with the appropriate permissions. Not sure about the IP missmatch. HTH Peter ---

RE: stripping characters

Hi I have items in a table identified by a Part Number. The Part Number may be selected by inputting into a php search box (perhaps from users memory). Example Original 71HF-9601-AB Searched for 71HF 9601 AB or 71HF9601AB or Original 36 44 A9 Searched for 36-44-A9 or 3644A9 or with other

RE: locking specific rows

Hi What about a table with logged in user ids and a timestamp (I use a sessions table). Update the timestamp when they access the system. Check when a user tries to login. If that user id, but a different person, has accessed the system within the last xx minutes or seconds then consider them

quote marks

Hi I am retrieving data from a mysql table and displaying the contents in a text box for editing. Some of the data contains double quotes eg '15 screen'. Using php4 the data is backslashed and stores without any problem, but when it is displayed in the text box it stops at the , because that

RE: Trouble in unsubscribing

could you be subscribed under two (or more) email addresses? Peter -Original Message- From: Yuxia Li [mailto:[EMAIL PROTECTED]] Sent: 29 January 2002 06:15 To: [EMAIL PROTECTED] Subject: Re: Trouble in unsubscribing Hi: Does anyone know how to unsubcrib from sql

RE: MySQL on the Playstation2? (OT? You betcha)

Anyway they need an SQL database to hold MY high scores grin Peter -Original Message- From: Carsten Gehling [mailto:[EMAIL PROTECTED]] Sent: 31 January 2002 10:03 To: mySQL Mailing List Subject: Re: MySQL on the Playstation2? (OT? You betcha) From: Colin Faber [EMAIL

RE: INSERT confirmation? PHP

hi mysql_insert_id http://www.php.net/manual/en/function.mysql-insert-id.php should do it! Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel.

RE: DBI or CGI perl error?

You are missing a comma update music set cut = '' , mamended = '20021214013349' where mrecno = '1' HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net

RE: An Idea

Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the

RE: An Idea

tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: 30 December 2002 01:35 To: Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea while Paul probably wouldnt say it, I would

RE: An Idea

Hi A faq without questions would be pretty empty! While you have the questions why not keep a note (or send them to me) Once we have some momentum we can put some answers and tutorials together. I thought I would email MySql to see if they like the idea, if not then I will build it. Peter

RE: FAQ hosting site (was Re: An Idea)

Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search

RE: FAQ hosting site (was Re: An Idea)

UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ

  1   2   >