[PHP-DB] Re: problems with variables

2003-02-03 Thread no-spam----me
Marcel <[EMAIL PROTECTED]> wrote: Can you clarify? Possibly show how the result should look in the page after parsing. I'm sure I can help but your question is a bit unclear. > I want to pass some variables named a1, a2...aX in a form. So I wrote a > couple of lines to do the trick: > for($i=1;

[PHP-DB] Re: heredoc and coding standards

2003-02-03 Thread no-spam----me
Rob, I've come across the same dilema. To keep things clean while using the convenience of heredoc you can write the heredoc in a seperate file and include_once() the file. Larry Rob Day <[EMAIL PROTECTED]> wrote: > I try to write very clean code. However, there is one thing that always bugs >

[PHP-DB] Re: To quote or not to quote?

2003-02-03 Thread no-spam----me
Unknown Sender <[EMAIL PROTECTED]> wrote: As mentioned in another reply, in MySQL all fields can have quotes regardelss of type. If you really need to tell, use this: if(!is_numeric($value)) { $value = "'" . $value . "'"; } > I guess this is mostly a MySQL question, but perhaps PHP has a sol

[PHP-DB] Re: problems with variables

2003-02-03 Thread no-spam----me
OK, now I get it: $input = '" . "\n"; print($input); This one isn't well known so don't forget it!! ;) Larry Marcel <[EMAIL PROTECTED]> wrote: > Sorry, I see that I've got the a's and q's mixed up. > I'll try to clarify it some more by giving an example with 2 variables. > $q1 = "first_var"

[PHP-DB] Re: efficient next/prev page generation

2003-02-14 Thread no-spam----me
SELECT COUNT(*) FROM (only on initial page). Then pass that count from page to page. Then only one query will be necessary for subsequent page requests. The count will not always be accurate if records are added during the users visit. But it's a quicker solution. David Chamberlin <[EMAIL PRO

Re: [PHP-DB] dump data, and save as a file

2003-02-14 Thread no-spam----me
Use Content-Type: application/octet-stream Gary Every <[EMAIL PROTECTED]> wrote: > Header("Content-type: text/plain"); > Header("Content-Disposition: attachment; filename=topsellers_dvd.csv"); > Gary Every > Sr. UNIX Administrator > Ingram Entertainment > (615) 287-4876 > "Pay It Forward" > mai

[PHP-DB] Re: sorting a multimensional array

2003-02-19 Thread no-spam----me
http://www.php.net/array_multisort is your answer. Mark Snijders <[EMAIL PROTECTED]> wrote: > hello, > i've got the next array: > Array > ( > [testsubnet] => Array > ( > [2690910720] => 255.255.255.0 > ) > [GLN-subnetsirangevoorgedelegeerddomein] => Array >

[PHP-DB] Re: Storing images in MySQL table

2003-02-19 Thread no-spam----me
Do NOT store images in a DB, the overhead kills performance. If it's a tiny app with very little traffic, the fine. Otherwise, store images in the filesystem. [EMAIL PROTECTED] wrote: > Hi everybody, > i want to store some articles and images to them in MySQL > db. could you just give ad