[PHP-DB] Re: subtracting one query from the other
Not sure what your data looks like or what exactly you are trying to do. But what is wrong with the old standard compare for NULL. Something like -- SELECT first_record.id as first_id, second_record.id as second_id FROM second_record LEFT JOIN first_record ON first_record.id = second_record.id ORDER BY something HAVING first_id = NULL Here only the second_records will be selected if there is no matching first_record. HTH.. Good luck .. Dan - Harpreet Kaur wrote: > Please help, I am stuck and my mind is frozen. > > I want to subtrack one query from the other. I have one query that > brings all the records. The second gets another set of records. > I want to subtract the second query from the first one . How do i do this? > > First query produces like 1000 records. Second has like 800 records i > want to display the other 200 that dont exist in the first query. > > Please help. > > I have this but it is too slow and doesnt work in php but does in mssql. > select distinct a.playlist, > a.material_id, > a.destination_locator, > a.destination, > a.air_time, > a.traffic_duration, > a.comment, > a.title, > a.device_name, > m.media_locator as source_locator, > m.medium_name as source > from cch_dubber_dublist_view11 a left outer join lib_copy_view m > on a.material_id=m.material_id where (A.material_id is not null) and > (A.material_id <>'') > and > NOT EXISTS ( >select null >from > dev_device_view d >inner join > lib_copy_view c >on > d.device_name= c.medium_name >where >c.material_id = a.material_id >AND c.media_locator = a.destination_locator >AND d.device_name = a.device_name >) > > > > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] encryption of critical data
Hi, Can someone provide me some information about encryption and decryption of critical data such as credit number card in order to stock them on a mysql database in a secure way. What I want to do is making a web interface secured via SSL in order to be able to consult some people information. As I don't want the critical information to be plaintext on the db, I'm searching for a way to get it encrypted and then decrypted when I'm consulting via the interface. I've read the php.net documentation and many articles about data encryption/decryption but both of them stand theorical about the various algorithms. Do you know the more secures of them and the way to use them ? Do you know people working in the same way or do they prefer another kind of more secure solution ? Thank you for your advice, R.
[PHP-DB] SQL question!
Hi, I need a sql query to join multiple lines into only one line. Ok, I wouldn´t understand this question so I´ll give an example (I´m doing it on mysql but I need it to mssql). Supose I have 3 tables: mysql> select * from test1; ++---+ | id| nome | ++---+ | 1| Bruno | | 2| Jorge | ++---+ mysql> select * from test2; ++-+---+ | id| request | value | ++-+---+ | 1| 1 | 100,00 | | 1| 2 | Mercedes | | 2| 1 | 50,00| | 2| 3 | Sparc Sun | ++-+---+ mysql> select * from test3; ++--+ | id| value| ++--+ | 1| money | | 2| car | | 3| computer | ++--+ test1.id -> test2.id test3.id -> test2.request When I execute: select test1.nome, test3.value, test2.value from test1, test2, test3 where test1.id = test2.id AND test2.request = test3.id I get: +---+--+---+ | nome| value | value | +---+--+---+ | Bruno | money | 100,00 | | Bruno | car | Mercedes | | Jorge | money | 50,00| | Jorge | computer | Sparc Sun | +---+--+---+ But I need this result: +---+--+---++ | nome| money | car| computer| +---+--+---++ | Bruno | 100,00 | Mercedes | NULL| | Jorge | 50,00 | NULL | Sparc Sun | +---+--+---++ Is it possible in Microsoft SQL Server? I´d like to know if it can be executed on mysql and, if not, if there is some way to do it in mysql. Sorry for the big e-mail but it´s something I really need to know. Thank´s Bruno Gimenes Pereti. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Update failing...
In need of some help. I have a PHP form page that is updating a MySQL database that is not working. Here is the code for the three pages that work together for this application. The oncall_new.php works fine to insert new records into the database, and the oncall_log.php works fine to display the database items. The oncall_update.php is the one that is failing to update the database. I cannot find anything wrong with the code, and I making an initial presentation of this in a couple hours. I was hoping another set of eyes might spot something obvious or simple. Thanks in advance. <> <> <> Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL Update failing...
I didn't get your attachements. Maybe paste them in a row into the email? -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:07 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL Update failing... In need of some help. I have a PHP form page that is updating a MySQL database that is not working. Here is the code for the three pages that work together for this application. The oncall_new.php works fine to insert new records into the database, and the oncall_log.php works fine to display the database items. The oncall_update.php is the one that is failing to update the database. I cannot find anything wrong with the code, and I making an initial presentation of this in a couple hours. I was hoping another set of eyes might spot something obvious or simple. Thanks in advance. <> <> <> Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL Update failing...
Figured it out. Thanks to anyone who started looking at this. The problem was not having my variables in the correct order in the $updateSQL. Once I corrected this, the posting now works fine. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 11:07 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL Update failing... In need of some help. I have a PHP form page that is updating a MySQL database that is not working. Here is the code for the three pages that work together for this application. The oncall_new.php works fine to insert new records into the database, and the oncall_log.php works fine to display the database items. The oncall_update.php is the one that is failing to update the database. I cannot find anything wrong with the code, and I making an initial presentation of this in a couple hours. I was hoping another set of eyes might spot something obvious or simple. Thanks in advance. <> <> <> Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP and msql Error
The error is in your MySql statement. Sounds like you are calling the wrong data field / column. Check you spelling and syntax to make sure all of that is in order. If you can't find it, copy it and post it. We'll help you out gl -- Seth Comp Boy wrote: > I am getting the following error: > > Warning: Supplied argument is not a valid mSQL result resource in > /usr/local/apache/htdocs/inc/listings.inc on line 24 > > listings.inc: 24 > $numRows = msql_numrows( $result ); > > The manual on php.net says that it takes no variables msql_numrows(void) > however it says it is another version of msql_num_rows(int msql); > > The code I am trying to run, runs perfectly fine on another one of our > systems. I was just setting up a development server and now I am getting > this problem. The specs are the same except for the version of Apache > production is 1.3.9 and development is 1.3.26 > > PHP vesrion 4.1.2 > > ./msqladmin version > Version Details :- > msqladmin version 2.0.11 > mSQL server version 2.0.11 > mSQL protocol version 23 > mSQL connection Localhost via UNIX socket > Target platform Linux-2.2.14-5.0-i686 > > PHP was configured: > ./configure --with-apxs=/usr/local/apache/bin/apxs --with-msql > > msql was a default install. > > Does anyone know what I did wrong? Do I need to recompile with some > different options? > > TIA > Jason > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 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 Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 27 June 2002 17:43 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] Re: PHP and msql Error > > > The error is in your MySql statement. Sounds like you are calling the > wrong data field / column. Check you spelling and syntax to make sure > all of that is in order. If you can't find it, copy it and post it. > We'll help you out > > gl -- Seth > > Comp Boy wrote: > > > I am getting the following error: > > > > Warning: Supplied argument is not a valid mSQL result resource in > > /usr/local/apache/htdocs/inc/listings.inc on line 24 > > > > listings.inc: 24 > > $numRows = msql_numrows( $result ); > > > > The manual on php.net says that it takes no variables > msql_numrows(void) > > however it says it is another version of msql_num_rows(int msql); > > > > The code I am trying to run, runs perfectly fine on another one of our > > systems. I was just setting up a development server and now I > am getting > > this problem. The specs are the same except for the version of Apache > > production is 1.3.9 and development is 1.3.26 > > > > PHP vesrion 4.1.2 > > > > ./msqladmin version > > Version Details :- > > msqladmin version 2.0.11 > > mSQL server version 2.0.11 > > mSQL protocol version 23 > > mSQL connection Localhost via UNIX socket > > Target platform Linux-2.2.14-5.0-i686 > > > > PHP was configured: > > ./configure --with-apxs=/usr/local/apache/bin/apxs --with-msql > > > > msql was a default install. > > > > Does anyone know what I did wrong? Do I need to recompile with some > > different options? > > > > TIA > > Jason > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] XML
MySQL has xml support...have you looked at the docs at mysql.com for anything that might help you input the data directly... B i g D o g - Original Message - From: "Peter Lovatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 3:03 PM Subject: [PHP-DB] 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 > > Peter > > > > --- > Excellence in internet and open source software > --- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > --- > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: 27 June 2002 17:43 > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: [PHP-DB] Re: PHP and msql Error > > > > > > The error is in your MySql statement. Sounds like you are calling the > > wrong data field / column. Check you spelling and syntax to make sure > > all of that is in order. If you can't find it, copy it and post it. > > We'll help you out > > > > gl -- Seth > > > > Comp Boy wrote: > > > > > I am getting the following error: > > > > > > Warning: Supplied argument is not a valid mSQL result resource in > > > /usr/local/apache/htdocs/inc/listings.inc on line 24 > > > > > > listings.inc: 24 > > > $numRows = msql_numrows( $result ); > > > > > > The manual on php.net says that it takes no variables > > msql_numrows(void) > > > however it says it is another version of msql_num_rows(int msql); > > > > > > The code I am trying to run, runs perfectly fine on another one of our > > > systems. I was just setting up a development server and now I > > am getting > > > this problem. The specs are the same except for the version of Apache > > > production is 1.3.9 and development is 1.3.26 > > > > > > PHP vesrion 4.1.2 > > > > > > ./msqladmin version > > > Version Details :- > > > msqladmin version 2.0.11 > > > mSQL server version 2.0.11 > > > mSQL protocol version 23 > > > mSQL connection Localhost via UNIX socket > > > Target platform Linux-2.2.14-5.0-i686 > > > > > > PHP was configured: > > > ./configure --with-apxs=/usr/local/apache/bin/apxs --with-msql > > > > > > msql was a default install. > > > > > > Does anyone know what I did wrong? Do I need to recompile with some > > > different options? > > > > > > TIA > > > Jason > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle Stored Proc, PHP
I am trying to work with a stored procedure that has no arguments and returns a cursor. I cannot seem to get a grasp on how the ociparse, ociexecute, ociBindByName, etc. work with this type of stored proc. Has anyone tried this? -Fenn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] encryption of critical data
HI If you are using MySql look at ENCODE() on mysql.com http://www.mysql.com/doc/M/i/Miscellaneous_functions.html Most databases support some sort of encryption. Encrypting by php is probably more secure - somebody might be able to sniff data going to the database if it still plain text, but that is a small risk IMHO, and getting the database to do it is easy . HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: youx [mailto:[EMAIL PROTECTED]] > Sent: 27 June 2002 14:12 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] encryption of critical data > > > Hi, > Can someone provide me some information about encryption and > decryption of critical data such as credit number card in order > to stock them on a mysql database in a secure way. > > What I want to do is making a web interface secured via SSL in > order to be able to consult some people information. As I don't > want the critical information to be plaintext on the db, I'm > searching for a way to get it encrypted and then decrypted when > I'm consulting via the interface. > > I've read the php.net documentation and many articles about data > encryption/decryption but both of them stand theorical about the > various algorithms. > > Do you know the more secures of them and the way to use them ? > Do you know people working in the same way or do they prefer > another kind of more secure solution ? > > Thank you for your advice, > R. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: XML
> 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) XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a database, you store data. When you fetch the data from the database, you wrap it in XML and send it on its way. Does that make it simpler? sql,mysql -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
On the other hand, proclaimed "native" XML databases (eg, Software AG's Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no need to wrap and unwrap the metadata, document/data structure from the data. - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: "Peter Lovatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 7:10 PM Subject: RE: XML > > 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) > > XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a > database, you store data. > > When you fetch the data from the database, you wrap it in XML and send it on its way. Does that make it simpler? > > sql,mysql > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: XML
> On the other hand, proclaimed "native" XML databases (eg, Software AG's > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no > need to wrap and unwrap the metadata, document/data structure from the data. Isn't that more than a bit stupid? Databases are for storing data, not metadata. Ask Monty why he doesn't store data natively as XML. Short answer: it's stupid, unless all you ever want to see from your database is XML-wrapped data and never want to see it any other way. The whole world isn't XML, nor should it be. 40+ years of working with data tells us that you ALWAYS want to store data in its simplest form. sql,db,mysql -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote: > > On the other hand, proclaimed "native" XML databases (eg, Software > AG's Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the > database...no need to wrap and unwrap the metadata, document/data > structure from the data. That doesn't make it smart. :-) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 29 days, processed 630,288,757 queries (251/sec. avg) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
All depends on what you're trying to accomplish and the drivers behind the path you wish (or need or have been mandated) to take. Having said that, I make no claims with respect to the smartness of others (I find I too often question that in myself to serve as a judge of others). Nice little philosophical exchange...good to break the monotony of real life from time to time. Cheers to all and hope ya find the answers you seek. Mike - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "MikeParton" <[EMAIL PROTECTED]> Cc: "Ed Carp" <[EMAIL PROTECTED]>; "Peter Lovatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 9:10 PM Subject: Re: XML > On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote: > > > > On the other hand, proclaimed "native" XML databases (eg, Software > > AG's Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the > > database...no need to wrap and unwrap the metadata, document/data > > structure from the data. > > That doesn't make it smart. :-) > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.51: up 29 days, processed 630,288,757 queries (251/sec. avg) > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
Would be interesting to hear from Peter on why he feels the urge to store XML docs in MySQL (or, better said: I would be interested in hearing what he is trying to accomplish and why he...or someone...feels XML stored in a relational database is the way to go). mysql, sql, xql, xquery, querywhat did I miss? Mike - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: "MikeParton" <[EMAIL PROTECTED]>; "Peter Lovatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 9:14 PM Subject: RE: XML > > On the other hand, proclaimed "native" XML databases (eg, Software AG's > > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no > > need to wrap and unwrap the metadata, document/data structure from the data. > > Isn't that more than a bit stupid? Databases are for storing data, not metadata. Ask Monty why he doesn't store data natively as > XML. Short answer: it's stupid, unless all you ever want to see from your database is XML-wrapped data and never want to see it any > other way. > > The whole world isn't XML, nor should it be. 40+ years of working with data tells us that you ALWAYS want to store data in its > simplest form. > > sql,db,mysql > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
At 21:33 -0400 6/27/02, MikeParton wrote: >Would be interesting to hear from Peter on why he feels the urge to store >XML docs in MySQL (or, better said: I would be interested in hearing what >he is trying to accomplish and why he...or someone...feels XML stored in a >relational database is the way to go). C'mon. XML is just data. There's no particular reason *not* to store it in a database. Is there? But usually people who ask about storing XML in MySQL seem to think MySQL should do something for them other than *just* store and retrieve it. The question is, what? That's what doesn't seem to get answered. > >mysql, sql, xql, xquery, querywhat did I miss? > >Mike > > >- Original Message - >From: "Ed Carp" <[EMAIL PROTECTED]> >To: "MikeParton" <[EMAIL PROTECTED]>; "Peter Lovatt" ><[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Thursday, June 27, 2002 9:14 PM >Subject: RE: XML > > >> > On the other hand, proclaimed "native" XML databases (eg, Software AG's >> > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the >database...no >> > need to wrap and unwrap the metadata, document/data structure from the >data. >> >> Isn't that more than a bit stupid? Databases are for storing data, not >metadata. Ask Monty why he doesn't store data natively as >> XML. Short answer: it's stupid, unless all you ever want to see from your >database is XML-wrapped data and never want to see it any >> other way. >> >> The whole world isn't XML, nor should it be. 40+ years of working with >data tells us that you ALWAYS want to store data in its >> simplest form. >> > > sql,db,mysql -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
If: An XML database is analogous to a "pure data" database Then: An XML document is the analog of a table XML Entities are analogs of columns XML Attributes are analogs of column properties (aren't these "metadata"?) So: Not sure there is much more metadata in an XML database than in a data database. - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: "MikeParton" <[EMAIL PROTECTED]>; "Peter Lovatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 9:14 PM Subject: RE: XML > > On the other hand, proclaimed "native" XML databases (eg, Software AG's > > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no > > need to wrap and unwrap the metadata, document/data structure from the data. > > Isn't that more than a bit stupid? Databases are for storing data, not metadata. Ask Monty why he doesn't store data natively as > XML. Short answer: it's stupid, unless all you ever want to see from your database is XML-wrapped data and never want to see it any > other way. > > The whole world isn't XML, nor should it be. 40+ years of working with data tells us that you ALWAYS want to store data in its > simplest form. > > sql,db,mysql > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: XML
> Not sure there is much more metadata in an XML database than in a data > database. In a standard database, the data and metadata are stored separately, not so with XML. When the next new "latest and greatest" thing comes along, you'll have to strip all that metadata out of your data. It also makes for bigger databases, and a lot more wasted space, like comparing normalized and unnormailzed tables. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how can i save a photo in mysql use php?
hi all how can i save a photo in mysql use php? can you tell me the data type too>? thx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how to save a picture in mysql?
hi all i am a newer in here, can you give me a example for save a picture in mysql use php? and type me which data type use in mysql thx chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Indexing Size
hi all I want to know storage required for my database. How i can determine size required for indexing a column ? (my column's type that indexed is varchar(15)) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Indexing Size
hmm... index it - and you will know olinux --- [EMAIL PROTECTED] wrote: > hi all > I want to know storage required for my database. > How i can determine size required for indexing a > column ? > (my column's type that indexed is varchar(15)) > Thanks > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how can i save a photo in mysql use php?
On Friday 28 June 2002 11:29, Msolutions wrote: > hi all > how can i save a photo in mysql use php? > can you tell me the data type too>? In most cases you shouldn't store a binary file in a database. It is more efficient to store a pointer (eg the name of the file) then have the actual file in the filesystem. If you still want to store the file in the db then the datatype you need is BLOB. For full details search the archives. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* To be who one is, is not to be someone else. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php