php-general Digest 23 Feb 2004 17:11:59 -0000 Issue 2607 Topics (messages 178511 through 178540):
Re: PHP or MSIE Problem? -- SOLVED 178511 by: Beau Hartshorne Re: using xp home 178512 by: Jason Merrique Re: ftp software 178513 by: Jason Merrique SQLite: getting field information (type etc) 178514 by: Robert S Re: tow dimenshional arrays 178515 by: joe-at read and modified getting data 178516 by: Tommi Virtanen 178517 by: Tommi Virtanen 178518 by: "Miguel J. Jiménez" 178519 by: Richard Davey 178520 by: Jason Merrique Re: Slight cleaning of code needed in str_replace command. 178521 by: Dave G 178524 by: Jason Wong Split a string on a space, not in side an HTML tag. 178522 by: Stuart Gilbert Character Encoding Problem 178523 by: roland 178526 by: Lucian Cozma Php and GpG 178525 by: Paul Marinas 178537 by: Sam Masiello Embedded MySQL server (libmysqld)? 178527 by: user.domain.invalid Connection handling and output_buffering 178528 by: neko 178530 by: Matt Matijevich hello 178529 by: gnat.frii.com Re: [PEAR] Re: PEAR DB 1.6.0 has been released 178531 by: Justin Patrin 178533 by: Richard Davey Re: [PHP-DB] Embedded MySQL server (libmysqld)? 178532 by: Adam Voigt 178538 by: user.domain.invalid 178539 by: Adam Voigt Re: delete a function 178534 by: Michal Migurski preg guru again..... 178535 by: pete M Re: Self Submitting Form 178536 by: Sam Masiello Can anyone tell me why this code doesn't insert anything? 178540 by: Brian Dunning Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] ----------------------------------------------------------------------
--- Begin Message ---I described a situation where MSIE for Windows would not post all of a form's fields under fairly unique circumstances. This problem occurs in MSIE 5, 5.5, and 6 (with the most recent hotfixes applied). No other browsers seem to be affected. When: 1. A form is submitted with the enctype attribute set to "multipart/form-data". 2. No http header is sent to explicitly select a character encoding that matches form input, or if the http header and xml prolog and/or meta http-equiv="content-type" tag do not select the correct character encoding[1]. 3. The user has input a character into one of the form fields, such as [TM], a curly quote, or some other character that could have been copy-pasted from a word processor, that is not defined in the character set identified by some combination of an http header, xml prolog, and meta tag. 4. There is at least one unchecked checkbox on contained in the form (thanks Pablo!). MSIE will not return all of the name/value pairs sent in the posted form to the server. If you check the checkbox, the form will post normally. The earliest reference to this problem that I could find was in a German Usenet post[2,3], where the special character was the Euro sign. Although the behaviour is a little buggy, we can't blame MSIE for getting it wrong. I've posted a new version of my page that sends the correct header: <?php header('Content-type: text/html; charset=utf-8'); ?> And that uses the correct meta tag: <meta http-equiv="content-type" content="text/html; charset=utf-8" /> I've omitted the xml prolog because of other problems that it can cause with MSIE 6. The page is still posted here: http://hartshorne.ca/sandbox.php Thanks!! Beau 1. <http://ppewww.ph.gla.ac.uk/~flavell/charset/checklist> 2. <http://ppewww.ph.gla.ac.uk/~flavell/charset/form-i18n.html> 3. <http://groups.google.com/groups?selm=afmkl9%24fghgm%243%40ID-16486.news .dfncis.de>
--- End Message ---
--- Begin Message ---Hi Danny, If you're going to be using PHP for testing purposes on your home PC, I'd recommend installing EasyPHP. It's basically Apache MySQL and PHP bundled together. It's pretty easy to set up, just run the installer, then start the program and you have a PHP enabled webserver. You should be able to get it at www.easyphp.org Cheers Jason > -----Original Message----- > From: danny cobbinah [mailto:[EMAIL PROTECTED] > Sent: 22 February 2004 00:12 > To: [EMAIL PROTECTED] > Subject: [PHP] using xp home > > is it better to use apache 1.3.29 or apache 2.0.48? > > i am having the worst trouble ever trying to get this thing to work > > -- > PHP General Mailing List (http://www.php.net/) To > unsubscribe, visit: http://www.php.net/unsub.php > > >
--- End Message ---
--- Begin Message ---I second that, What I like the most about WSFTP is that you can edit files on the remote site. Very handy! > -----Original Message----- > From: Pooya Eslami [mailto:[EMAIL PROTECTED] > Sent: 22 February 2004 21:47 > To: [EMAIL PROTECTED] > Subject: [PHP] Re: ftp software > > WS FTP is not bad.you cand download the LE version for free > here: (the last one at the end of the page!) > http://www.ipswitch.com/downloads/index.html > > -Pooya > > > "Nathan McIntyre" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hello! > > > > I am new both to PHP and web dev, and I am wondering what > ftp software > > would be best for me to use. > > -- > PHP General Mailing List (http://www.php.net/) To > unsubscribe, visit: http://www.php.net/unsub.php > > >
--- End Message ---
--- Begin Message ---I am trying to port a small database application (php, MySQL) to sqlite. How can I find the type of an arbitrary field? In other words, what is the equivalent of mysql_field_type() and mysql_field_flags() in sqlite? I read something on the sqlite group recently that recommended using pragma_show_datatypes in a query, but I couldn't get this to work and the example on the newsgroup was written in C. Could somebody please enlighten me?
--- End Message ---
--- Begin Message ---Like I supposed there is no efficient way how to do. Thank you for the functios and the help of all of you. Best regards, joe-at "Manuel VáZquez Acosta" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Namaste Adwinwijaya: > > I meant there's no PHP function neither to get a column nor to transpose the > matrix. > > The first answer you gave us, retrieves the amount of items in the column, > not the column itself as an array. And the second one, just prints the > matrix, but does not transpose it. > > Joe-At: I suggest you to tell us your exact problem, maybe there's a way to > solve it avoiding matrices, maybe there's a more suitable representation to > the problem's parameters. > > Manu. > > PS: > > This function retrives the j column, assuming that the matrix has no > non-numerical indeces: > > function getColumn($arr, $j) > { > if (isset($arr[$j]) && count($arr[$j])>0) > { > $result = array(); > foreach($arr[$j] as $which) > $result[] = $which; // You could make reference > instead > } > } > > function getTranspose($arr) > { > if (count($arr)>0) > { > $result = array(); > for($i=0; $i<count($arr); $i++) > for($j=0; $j<count($arr[$i]); $j++) > { > if (!isset($result[$j])) > $result[$j] = array(); > > $result[$j][$i] = $arr[$i][$j]; > } > } > } > > Keep in mind this are inefficient functions. > > Manu. > > > "Adwinwijaya" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hello Manuel, > > > > Sunday, February 22, 2004, 5:47:02 AM, you wrote: > > > > MVA> As far as I know, there is no such a function. Maybe you should use a > > MVA> different approach. > > MVA> Manu. > > > > MVA> "Joe-At" <[EMAIL PROTECTED]> wrote in message > > MVA> news:[EMAIL PROTECTED] > > >> Hallo, > > >> 1) I want to work with the rows und columns of a tow dimensional > > >> array[i][j]. With array[i] I get the i'th row. But how can I get the > j'th > > >> column? > > >> 2) Is there any command to transpose a two dimensional array? > > >> Thanks for help > > > > > > 1. $array_j = $array[$i] ; > > count($array_j) ; > > > > 2. > > foreach($array as $sub_array){ > > foreach($subarray as $key=>$value) > > echo $key.'=='.$value ; > > } > > > > > > cmiiw > > > > -- > > Best regards, > > adwinwijaya mailto:[EMAIL PROTECTED]
--- End Message ---
--- Begin Message --- Hi!
I have quite simple form (it has textarea input), where I can write for example:
Data 1 Data 2
This is text
So, input contains spaces, linefeeds and so on...
When I make page, which read data from this textarea-field, data came from without
spaces and linefeeds. How to correct this problem?
Regards,
gustavus
--- End Message ---
--- Begin Message --- Hi!
I have quite simple form (it has textarea input), where I can write for example:
Data 1 Data 2
This is text
So, input contains spaces, linefeeds and so on...
When I make page, which read data from this textarea-field, data came from without
spaces and linefeeds. How to correct this problem?
Regards,
gustavus
--- End Message ---
--- Begin Message --- You must convert "\n" to <br> and spaces to You can use strreplace() or some other function that exist in PHP just for that...
Tommi Virtanen wrote:
Hi!
I have quite simple form (it has textarea input), where I can write for example:
Data 1 Data 2
This is text
So, input contains spaces, linefeeds and so on...
When I make page, which read data from this textarea-field, data came from without
spaces and linefeeds. How to correct this problem?
Regards,
gustavus
-- Miguel J. Jiménez ISOTROL, S.A. (Área de Internet) [EMAIL PROTECTED] TLFNO. 955036800 ext. 111
--- End Message ---
--- Begin Message ---Hello Tommi, Monday, February 23, 2004, 10:25:10 AM, you wrote: TV> So, input contains spaces, linefeeds and so on... TV> When I make page, which read data from this textarea-field, data TV> came from without spaces and linefeeds. How to correct this TV> problem? The characters will still actually be there (view the source to see) it's just that HTML won't render them the way you're expecting. The spaces will be converted into a single space and the line-feeds/carriage returns won't do anything either unless you're using a fixed-width font. Two choices: Convert the non-displaying characters to their HTML equivalents (i.e. space to ) or wrap the text in a <pre> tag. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html
--- End Message ---
--- Begin Message ---> From: "Miguel J. Jiménez" [mailto:[EMAIL PROTECTED] > You must convert "\n" to <br> and spaces to You can use > strreplace() or some other function that exist in PHP just for that... nl2br() should do that. Usage: nl2br($foo) $foo is your textarea variable.
--- End Message ---
--- Begin Message ---Jason, Have no worries, I'm not looking for anyone to write my code for me. It's precisely because the str_replace command is so simple that I figure if the results are strange that there is something I don't understand. And I want to understand it, not just be given code to copy and paste. As it turns out, by experimenting with the var_dump() command that you recommended (which I wasn't aware of), I learned that what was going wrong was that the line breaks coming out of my MySQL DB aren't just \n, but \r\n. So swapping around the elements I was replacing, and experimenting, was not going to do me much good until I knew this. So now it's working, and largely thanks to the suggestions you gave. I would never have been able to guess on my own at using var_dump() in order to get at the solution. Please don't assume that just because a query is simple that it means that the person asking is not willing to work or that they haven't already attempted to work at it. Sometimes it just means that the person asking doesn't know all the angles possible. Thanks for your help. -- Yoroshiku! Dave G [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---On Monday 23 February 2004 19:12, Dave G wrote: > So now it's working, and largely thanks to the suggestions you > gave. I would never have been able to guess on my own at using > var_dump() in order to get at the solution. Please don't assume that > just because a query is simple that it means that the person asking is > not willing to work or that they haven't already attempted to work at > it. Sometimes it just means that the person asking doesn't know all the > angles possible. It's good to know you've solved your problem. I hope you appreciate that my suggestions will be of more use to you in the long run than a straight forward answer to your problem. It's better to teach someone how to fish than to do the fishing for them. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* You may easily play a joke on a man who likes to argue -- agree with him. -- Ed Howe */
--- End Message ---
--- Begin Message --- Hi, I'm trying to get a 500 character split of a string, I only want about the fist 500 characters, I would like to split on a space, which I have managed to do so far, but I would also like the split to not take place inside an HTML tag, so that I don't end up with weird looking pages.
I was trying to use strip_tags() error checking to tell me whether I my string was valid html or not. If it's not valid html then I would like to split before that part of the html begins. Possibly even as simply as removing the last 10 characters (to the nearest space) until I get valid HTML.
Can anyone help me get a way to split my text at around the 500 character mark without breaking any HTML which may be inside the string I am displaying on the page?
Also, if you're interested in the strip_tags() problem I was speaking about then take a look at: http://better.domain.name/php/strip.php there is a link to the source on the page.
Regards, Stuart Gilbert.
--- End Message ---
--- Begin Message ---Hi I'm trying to encode text entered into an html form. In dreamweaver, special characters seem to be encoded as “ (a curly quote) for example, which I assume is utf-8. Here is my code snippet: htmlentities(html_entity_decode(strip_tags(stripslashes(trim($data)))), ENT_QUOTES), ENT_QUOTES, "utf-8") but this does not seem to return the encoded value. I've tried all the character sets, but none of them seem to do anything apart from the windows specific character set, which doesn't return the value I want. I've tried using html_entity_decode with uft-8, but it throws an error saying that the function doesn't support MBCS (Multibyte character sets???) I've also tried using utf8_encode() before trying to html encode, but this doesn't work either. Any help gratefully appreciated Thanks In Advance Roland
--- End Message ---
--- Begin Message ---Try multibyte functions (http://www.php.net/manual/en/ref.mbstring.php): mb_decode_numericentity mb_encode_numericentity mb_convert_encoding See below: <?php function n_to_c($str) { return mb_decode_numericentity($str, array(0x0, 0x2FFFF, 0, 0xFFFF), 'UTF-8'); } function c_to_n($strt) { return mb_encode_numericentity($strt, array(0x0, 0x2FFFF, 0, 0xFFFF), 'UTF-8'); } echo n_to_c('“'); echo '<br/>'; echo c_to_n(n_to_c('“')); ?> Hope it helps, Lucian "Roland" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > I'm trying to encode text entered into an html form. In dreamweaver, > special characters seem to be encoded as “ (a curly quote) for > example, which I assume is utf-8. > > Here is my code snippet: > > htmlentities(html_entity_decode(strip_tags(stripslashes(trim($data)))), > ENT_QUOTES), ENT_QUOTES, "utf-8") > > but this does not seem to return the encoded value. I've tried all the > character sets, but none of them seem to do anything apart from the windows > specific character set, which doesn't return the value I want. > > I've tried using html_entity_decode with uft-8, but it throws an error > saying that the function doesn't support MBCS (Multibyte character sets???) > > I've also tried using utf8_encode() before trying to html encode, but this > doesn't work either. > > Any help gratefully appreciated > > Thanks In Advance > Roland
--- End Message ---
--- Begin Message ---Those anyone know hoh to use php with gpg. I've tryed gpgext, but doesn't seems to work maybe my php is not compiled with some kind of support. thanks Paul GnuPG Key http://sgi.rdscv.ro/~paulm/paulm.PGP
--- End Message ---
--- Begin Message ---What is the error that you get when you try to use gpgext? --Sam Paul Marinas wrote: > Those anyone know hoh to use php with gpg. I've tryed gpgext, but > doesn't seems to work maybe my php is not compiled with some kind of > support. > > thanks > > > Paul > GnuPG Key http://sgi.rdscv.ro/~paulm/paulm.PGP
--- End Message ---
--- Begin Message --- Howdy --
Would someone point or provide me with an example of PHP + libMysqld (Embedded MySQL server)?
My problem is my churchs web site doesn't provide a MySQL database as a default package (add $15.95/mo)for a MySQL Db.
TIA, David
--- End Message ---
--- Begin Message --- Hi guys,
Was reading through: http://uk.php.net/manual/en/features.connection-handling.php
And I was wondering how PHP handles script termination when you have 'output_buffering = On' in your php.ini?
If I have a long script that does lots of database stuff for example, and is riddled with echo() function calls, how will php handle a user clicking stop in their browser half way through?
I'm guessing that it WILL continue execution to the end, then when you send the buffer back to the client it determines that the client stopped the request and it terminates.
I guess some simple testing will suffice!
Neko
--- End Message ---
--- Begin Message ---<snip> Was reading through: http://uk.php.net/manual/en/features.connection-handling.php And I was wondering how PHP handles script termination when you have 'output_buffering = On' in your php.ini? If I have a long script that does lots of database stuff for example, and is riddled with echo() function calls, how will php handle a user clicking stop in their browser half way through? </snip> I think http://www.php.net/manual/en/function.ignore-user-abort.php will give you some of the info you want
--- End Message ---
--- Begin Message ---read it immediately!<<attachment: release.zip>>
--- End Message ---
--- Begin Message --- Lukas Smith wrote:
Justin Patrin wrote:
I think you're confusing the issue. PEAR DB does support many databases, but it only loads the code for the ones that you are currently using. So if you're using one database it is effectively a one database API.
Jakes wrote:
What is performance like using this class? I've gone through the class and
it just seams to be over kill, for a DB API (13 databases).
Are there any time stats showing the different time in using a single DB API
class to the PEAR class.
Yes things are really not that bad. However expect to give up somewhere a fairly significant amount of performance. If you are using an abstraction layer you have to do it with a good reason (you need to support multiple databases mainly :-) ).
Here is a benchmark John Lim came up with: http://phplens.com/lens/adodb/
It only tests MySQL though and it implements a very unrealistic scenario. The reason that ADODB scores so high can be read here:
http://marc.theaimsgroup.com/?l=pear-dev&m=100793507904834&w=2
Well, yes, you're going to lose some processing time using an abstraction layer, but IMHO the pros far outweight the cons, even if you don't need ot support multiple DBs.
1) Many very useful utility functions which will give you the data you want and automatically free resources for you, such as getRow(), getAll(), and getOne().
2) Good and easy to use error handling (this is very important, believe me).
3) A unified architecture for mysql and Oracle. You don't have to remember different functions for use with different databases.
4) You never know when you might want to switch to another DB.
5) You never know someone else using your code might want to switch to another DB.
The company I'm at now had an abstraction layer of their own (for all of these reasons) and it wasn't nearly as good as PEAR DB even after all of the work I put into it. I just didn't have the time to deal with it all on my own. I'd much rather use PEAR DB which has lots of developers working on it and using it, finding bugs and making patches. :-)
-- paperCrane <Justin Patrin>
--- End Message ---
--- Begin Message ---Hello Justin, Monday, February 23, 2004, 4:11:40 PM, you wrote: JP> 3) A unified architecture for mysql and Oracle. You don't have to JP> remember different functions for use with different databases. That abstraction only abstracts the functions to connect to, select and query the database, surely? Oracle/SQL Server/MySQL all use slightly different SQL syntax - so if the query you pass in has to be unique depending on the database in hand - you're already having to remember a stack of system specific SQL and will have to code your application to take into consideration all of those different syntax. What I'm trying to say is that abstracting the connection to the database is the easy part, writing an application that will support them all is another matter. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html
--- End Message ---
--- Begin Message ---Check these guys out: http://spenix.com/WebHostingPlans.aspx Very cheap, very reliable, great features, and support is second to none I've ever experienced, and before you ask, no I'm not now nor have I ever been an employee or shareholder. =) Just a satisfied customer. On Mon, 2004-02-23 at 09:53, [EMAIL PROTECTED] wrote: > Howdy -- > Would someone point or provide me with an example of PHP + libMysqld > (Embedded MySQL server)? > > My problem is my churchs web site doesn't provide a MySQL database as > a default package (add $15.95/mo)for a MySQL Db. > > TIA, > David -- Adam Voigt [EMAIL PROTECTED]
--- End Message ---
--- Begin Message --- Adam Voigt wrote:Check these guys out:
http://spenix.com/WebHostingPlans.aspx
Very cheap, very reliable, great features, and support is second to none I've ever experienced, and before you ask, no I'm not now nor have I ever been an employee or shareholder. =) Just a satisfied customer.
Admin -- There is no shortage of good cheap hosting package. The choice of hosting providers is out of my hands.
What I'm looking for is a way to implement a relational database in docuument_root of the web site (ie. /home/username)?
David
--- End Message ---
--- Begin Message ---Alright, well with any txt based system, your probably going to run into problems with multi-users (multiple browsers) updating the DB. Reguardless, if you must use txtbased, I recommend SQL-Lite, it supports SQL statements, and is very small and very fast. http://www.sqlite.com On Mon, 2004-02-23 at 11:53, [EMAIL PROTECTED] wrote: > Adam Voigt wrote: > > Check these guys out: > > > > http://spenix.com/WebHostingPlans.aspx > > > > Very cheap, very reliable, great features, and support is second to none > > I've ever experienced, and before you ask, no I'm not now nor have I > > ever been an employee or shareholder. =) Just a satisfied customer. > > > Admin -- > There is no shortage of good cheap hosting package. > The choice of hosting providers is out of my hands. > > What I'm looking for is a way to implement a relational database in > docuument_root of the web site (ie. /home/username)? > > David -- Adam Voigt [EMAIL PROTECTED]
--- End Message ---
--- Begin Message --->There are two (or more) different functions on my web site, that have the >same name (an action). They are called depending on the permittions of >the end user. .... I want to have the code clean so I don't want to put >the switch or if operators to it. I will call the wrapper that will check >the grant of the user and call apropriate function. (For example: >Load_action("List")) You're going to have to put that switch logic someplace, though - the usual way to approach this situation is to have a central dispatch function/file which checks the user's permissions, and then makes subrequests to specific display functions for drawing the individual parts of an interface - disply_nav(), display_login(), etc. Adam suggested the Factory pattern, but your desired behavior sounds much more like the Command pattern to me: http://www.phppatterns.com/index.php/article/articleview/96/1/1/ It's probably cleaner to have all your permissions logic in one place, and not mess with multiple identically-named functions. It feels like asking for trouble, to me - your philosophy of laziness is truly admirable, but you could be creating a serious maintenance headache for yourself down the road. :) --------------------------------------------------------------------- michal migurski- contact info and pgp key: sf/ca http://mike.teczno.com/contact.html
--- End Message ---
--- Begin Message --- Am trying to do a strange thing with php..
Extract the urls from the Internet Explorer index.dat history files (dont ask why!)
Here is a snippet ð:2002020720020208:[EMAIL PROTECTED]://www.lyricsworld.com/cgi-bin/search.cgi?q=Bruce +Springsteen&m=phrase&ps=20&o=0&wm=wrd&ul=&wf=22221ðððð
it breaks down in the following elements the :date: in the format yyyymmddyyyymmdd The expression I'm using is (":16[0-9]:") ie matching the : with 16 digits :
I'm using to match the url part (taken from php manual - thanks).. however am getting all the illegal characters - nulls, binary, etc back as its a binary file
preg_match("/^(.*:\/\/)?([^:\/]+):?([0-9]+)?(.*)/", $contents, $match);
also I want to allow / ~ ? & characters as well as http: file: protocols
Complete string is
preg_match(":16[0-9]:/^(.*:\/\/)?([^:\/]+):?([0-9]+)?(.*)/", $contents, $match);
Of course it doesnt work !!!
any help would be appreciated
Pete
--- End Message ---
--- Begin Message ---Ah ha! I think I found where the problem lies(and also our confusing disconnect). Even though you and I were doing pretty much the same thing, your case worked fine in the instance where the parameter being submitted in the self submitting form was only one word. If you changed your test case to something like "hi there" (which is what I was using in my testing), it breaks. Why? The parameter needs to be urlencoded first. Thank you very much for your help and suggestions, Toby! I really appreciate your time and effort in helping me to see the light. --Sam Toby Irmer wrote: > Hi Sam, > > I did that only because I was too lazy to upload and did the testing > locally so I could grab the value in Javascript. > > Of course it works with post as well... > > test.html > > <form name="myform1" method="get" action=""> > <input type="hidden" name="myvar1" value="testing"> > <script> > window.open("test2.html", "test"); > </script> > </form> > > > test2.html > > <BODY onLoad="document.forms[0].submit();"> > <form name="myform1" method="post" action="test.php"> > <INPUT TYPE="hidden" NAME="do_preview" VALUE="1"> > <script> > document.write('<INPUT TYPE="hidden" NAME="itworks" > VALUE="'+opener.myform1.myvar1.value+'">'); </script> > </FORM> > </BODY> > > test.php > > <? > print_r($_POST); >> > > Outputs: > > Array ( [do_preview] => 1 [itworks] => testing )
--- End Message ---
--- Begin Message --- This inserts nothing into the database, but returns no error that I can see. How come? What's wrong with it?
$dbname = "my_database";
$dbconnection = mysql_connect("mysql05.powweb.com","my_user","my_pass");
mysql_select_db($dbname, $dbconnection);
$query = "INSERT INTO invoices ('ip','total','creation','first_name','email','session','last_name') VALUES ('0.0.0.0','0.00',NOW(),'Bob','[EMAIL PROTECTED]','12345','Smith')";
$result = mysql_query($query);
--- End Message ---