[PHP-DB] Re: [PHP] Headers in body - what am I doing wrong???

seperators... Thanks to y'all ... now I just gotta figure out why Mercury doesn't process the commands. ... commands sent by regular mail are processed ... so it must be a problem with the script... Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff

[PHP-DB] Compiling 4.2.3 with MySQL ... what does it look for?

other SQL for that matter, so got 0 experience in getting the system up and running with it... TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] How to do error feedback when adding to indexed table?

field btw). TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to do error feedback when adding to indexed table?

to this project, I'll happily ask them. If it's about the game, better keep it offlist, thank you. Thanks for the help Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

the single record. So I've been mixing code from various places. And I don't even know if it retrieves the right record, or any record at all (how do I test that?). Any help is highly appreciated :) TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other

[PHP-DB] MySQL 4.x: Access denied for users when password is set...

install guides I could find ... atm I'm running on a restored version of the default mysql DB with the % users set ... since the firewall locks out remote access, I didn't think it's a big deal)... n00b at SQL TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools

Re: [PHP-DB] **Happy New Year**

A day early =) ... but happy new year to you too Rene Fate would have it, that on Tue, 30 Dec 2003 12:17:29 +0530, [EMAIL PROTECTED] wrote: Hi PHP Coders, Wishing you all a very happy and prosperous 2004. Aynsoft www.aynsoft.com Rene Brehmer aka Metalbunny http://metalbunny.net/ References

[PHP-DB] Selecting last record only

is history, and only have 3 fields: histID, date, entry I need it to pick the last record without knowing the date of it. Got picking specific records down good, but be damned if I can figure this one out... TIA Rene Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other

Re: [PHP-DB] Selecting last record only

ORDER BY date DESC LIMIT 1 to get the latest dated item. -Micah Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CREATE TABLE problem

] wrote: I have had similar problems before. I have just created your table in MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED. Doesn't mention this in the manual though. Neil Morgan Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff

[PHP-DB] How to do freeform text search across multiple fields ??

Thunderbird in the type field... also ... how do I do range searches ... like listing all speeds from 500 to 1000 or something like that ??? yeah, I seriously need some decent documentation for constructing SQL search strings TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net

Re: [PHP-DB] PHP and mail forms

=post . and then you use: $id=$_GET['id']; --- if this is the same than $HTTP_GET_VARS['id'] this wont work Where does that mail function (is it a function?) go? The function sends an email, for more details consult the php manual. -- Rene Brehmer aka Metalbunny http://metalbunny.net

[PHP-DB] Not having mysql_close() ... is that a big problem ???

protential problems, or should I go through the files and put it in where missing the thing is that it does a few includes criss-crossing a few files ... so finding where to put the damn thing is not always possible, with SQL pulls from 7 tables and such ... Rene -- Rene Brehmer aka Metalbunny

[PHP-DB] how to do query on partial field contents ???

; } } The order part is of course not that relevant in this case, but I left it in the snip for the variables set in the query part to make sense... Question is simple: What do I change in the code to make it do partial field matches, instead of complete ??? Hoping for help :) ... TIA Rene -- Rene Brehmer

[PHP-DB] Looking for simpler way to do this...

the number of queries down, as it has to do join searches on a couple of these to handle the perms and other things on each page... TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] What's the difference here????

/forumID these uses, so they won't be called unless that particular category/forum exists. So there shouldn't be a problem combining the two statements into 1 ... (other than it not exactly being textbook coding :p ) TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References

RE: [PHP-DB] Tree structure - how to show only current branch ??

as long to convert that to something workable in PHP, as it will figuring out how to do it in PHP Rene At 14:15 30-03-2004, you wrote: Already been done: http://www.destroydrop.com/javascripts/tree/ Mark -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read

[PHP-DB] How to get only 2nd row in result set ???

this is a kludge to do it this way ... but it's what I need for now ... later I'll get to do it a more brilliant way... TIA Rene -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http://metalbunny.net/ References, tools, and other useful stuff... Check out the new

Re: [PHP-DB] Overhead on mylsam type mysql database

. This is what i see.Data 362,692 Bytes Index 5,120 Bytes Overhead 22,568 Bytes Effective 345,244 Bytes Total 367,812 Bytes Your help will be very much appreciated. Thanks Piet -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http

Re: [PHP-DB] Re: Tree structure - how to show only current branch ??

their subfolders attached ... Sofar I'm a bit blank in regards to this especially because I'm doing it to figure out how to do it, but don't really have anything specific I want to use it for yet, that requires more than 2 level of folders... Rene -- Rene Brehmer aka Metalbunny ~ If you

Re: [PHP-DB] Mail() - Preposterous Accusation

... Rene -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http://metalbunny.net/ References, tools, and other useful stuff... Check out the new Metalbunny forums @ http://forums.metalbunny.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

RE: [PHP-DB] Mail() - Preposterous Accusation

() command). ... Is there a way to get the bounces to go to the reply to address? I've never really cared to, but now that he mentions it ... It would be nice. Ryan -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http://metalbunny.net/ References, tools

Re: [PHP-DB] Mail() - Preposterous Accusation

, but try to reuse as much of the code as entirely possible ... so yes, code reuse is good, but if you don't understand the code you reuse, you're not really benefitting much of it (other than ending in the same category as script-kiddies)... Rene -- Rene Brehmer aka Metalbunny ~ If you don't like

Re: [PHP-DB] How to write file store file-name to DB...

to database.. Each page contain information of certain user.. How to save page to HTML file with PHP...?? Nicholas Sk2 -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http://metalbunny.net/ References, tools, and other useful stuff... Check out the new

[PHP-DB] Handling missing rows on joins

??? I know it looks like deleting levels will cause problems as well, but the code for that has been made so deleting a level will move all users assigned to that level to a different one. Any suggestions for handling this better would be appreciated ... TIA Rene -- Rene Brehmer aka Metalbunny

Re: [PHP-DB] Handling missing rows on joins

... -- Rene Brehmer aka Metalbunny ~ If you don't like what I have to say ... don't read it ~ http://metalbunny.net/ References, tools, and other useful stuff... Check out the new Metalbunny forums @ http://forums.metalbunny.net/ -- PHP Database Mailing List (http://www.php.net

[PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

4.3.0 ... Any ideas for optimizing this will be greatly appreciated, esp since I'm not all that great with the more complex SQL syntax... TIA Rene -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake

Re: [PHP-DB] unsubscribe me

[EMAIL PROTECTED] wrote: From: CJ Koh [EMAIL PROTECTED] unsubscribe me -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http

[PHP-DB] How to optimize select of random record in DB ?

'.mysql_error()); $personID = mysql_result($personquery,0); -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http://metalbunny.net/ References

Re: [PHP-DB] MySQL max records

wrote: I tried a little research on the mysql list but didn't find what I was looking for.What is the limit of a MySQL database? How many hundreds of thousands of records can a database hold before it gets too sluggish to work on a production server? thanks, -- Rene Brehmer aka Metalbunny If your

[PHP-DB] How do I reverse-finding root entry in tree-structure ?

for the visual part... Using MySQL btw ... TIA Rene -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http://metalbunny.net/ References

Re: [PHP-DB] Database Design Recommendations

of the running system database. Securing sensitive information goes beyond just having a fancy login system, you'll need to control access to the system that stores the information as well. Rene -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping

[PHP-DB] Using an array(-ish) in SQL queries

the OR statements that has to be transformed first. Sorry if I'm just a blind mouse that can't seem to find things in the MySQL manual. It's not really my best friend... TIA Rene -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping

Re: [PHP-DB] Using an array(-ish) in SQL queries

, maybe somone else will chime in. thanks a whole bunch ... can't believe how close I was ... and I couldn't even find it in the manual :-/ and for some reason I've never thought of implode :-s ... anyways, live and learn ... thanks :) Rene -- Rene Brehmer aka Metalbunny If your life was a dream

RE: [PHP-DB] Using an array(-ish) in SQL queries

that those records indeed are to be deleted. I prefer to mark the record as deleted for a time before permanent deletion. That way its recoverable should something really bad happen. bastien -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping

[PHP-DB] Book recommendation for using MySQL w. PHP

is coming up, and my girl wants to know what to give me ... heh :P Rene -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http

Re: [PHP-DB] Book recommendation for using MySQL w. PHP

Thanks ... the reviews for that one are pretty promising :p Rene At 04:37 04-11-2004, David Orlovich wrote: I'd recommend Welling and Thomson PHP and MySQL Web Development. It's nice and thick and a new (3rd) edition has just come out. David. -- Rene Brehmer aka Metalbunny If your life

Re: [PHP-DB] Re: Book recommendation for using MySQL w. PHP

At 04:42 04-11-2004, Manuel Lemos wrote: Hello, On 11/04/2004 01:22 AM, -{ Rene Brehmer }- wrote: Any recommendations for a book that goes into depth with the SQL language and specifically MySQL's variant, and especially using that with PHP I don't need a beginner's guide, cuz I've gotten

RE: [PHP-DB] Book recommendation for using MySQL w. PHP

decision. Rich -- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http://metalbunny.net/ References, tools, and other useful stuff

[PHP-DB] Looking for more optimal way to do multiple similar inserts at once

Hi gang I'm in need of, if at all possible, cutting down the processing time for sending messages to multiple recipients with my insite messenger. The current version runs 1 query to get the names of all recipients, then 1 query per recipient, and then 1 query to deliver a copy to the sender.

Re: [PHP-DB] how to find

1. learn the basics of arrays 2. RTFM At 12:27 11-11-2004, peppe wrote: Hi , I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how can I find the first 1 and the last is there a function for it -- PHP Database Mailing List

Re: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

At 13:42 11-11-2004, Sebastian Mendel wrote: // send Messages $sql = ' INSERT INTO `hf_privmessages` (`ownerID`,`fromID`,`toID`,`from_name`,`to_name`,`priority`,`date`,`subject`,`message`,`folder`) SELECT `userID` AS `ownerID`, ' . (int) $userID . 'AS `fromID`,

RE: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

yeah, I noticed that ... haven't had a chance to check for certain, but I believe the server I have to work with is 3.23 ... and since my space is rented, I don't have alot of say in upgrading ... although it might be possible to get them to do it ... their PHPMyAdmin is really old too ... :-s

[PHP-DB] Why does this code/query hang time out ?

Hi gang My CPU database (http://metalbunny.net/computers/cpudb.php) - still a work in progress - used to be in 1 table, but for several reasons I've decided it's better to split the data into multiple related tables. Obviously this means I have to rewrite the query tool for it, and that's where

RE: [PHP-DB] Why does this code/query hang time out ?

... inline ... for ease: At 23:53 31/03/2005, Juffermans, Jos wrote: So far, I have found a few mistakes in your SQL: $query .= OR `variant` LIKE '%.$_GET['search'].%'; Why do you have backtick-quotes around variant? Know that backticks are used to call system commands. You also use these

Re: [PHP-DB] registration form with activation code sent to user

Documented research indicate that on Thu, 16 Jun 2005 16:20:31 +0100 (BST), babu wrote: Ya joseph u r right, i am thinking of the url to be generated to be send to the user. I followed u r steps but did not understand some points. 2.) Store that string to the database somewhere

Re: [PHP-DB] Re: UPDATE command

Documented research indicate that on Mon, 20 Jun 2005 12:47:56 +0100, [EMAIL PROTECTED] wrote: The trick is your using the wrong ' instead you need ` ... go away from kl;-' and go to `-123 ;) The key above the (Tab) key, or the key next to the number 1 above the q. I hope you realise

Re: [PHP-DB] Delivery reports about your e-mail

failed mail delivery viruses ... It should help a bit if the server simply refused any post that contains attachments, or routed it to /dev/null, whatever's simplest... -- Rene Brehmer aka Metalbunny We have nothing to fear from free speech and free information on the Internet, but pop-up

Re: [PHP-DB] Re: Beginners Problem

a session active, that's why this part of the code doesn't check for it. I made it this way so I can run the login/logout script at any phase of the code, without having to worry about setting sessions and cookies before it sends the headers. FWIW Rene -- Rene Brehmer aka Metalbunny We have

Re: [PHP-DB] Re: Beginners Problem

handling for multiple accounts (perhaps unnecessary, excepting very secure applications). Andy -- Rene Brehmer aka Metalbunny We have nothing to fear from free speech and free information on the Internet but pop-up advertising! http://metalbunny.net/ References, tools, and other useful