[PHP-DB] database sends unclear messages

2003-12-10 Thread Merlin
Hi there, I have a LAMP appplication which sends a report via email if a database error occures. This workes pretty fine. The message contains sql statement and error message from the db server. Lately there are lots of errors showing up every few days which look not like sql errors. Sometimes

[PHP-DB] Re: database sends unclear messages

2003-12-10 Thread pete M
Looks like there a crawler/search emgine indexing your site .. pete Merlin wrote: Hi there, I have a LAMP appplication which sends a report via email if a database error occures. This workes pretty fine. The message contains sql statement and error message from the db server. Lately there

[PHP-DB] {PHP-DB} password generator

2003-12-10 Thread Nikos Gatsis
Hello list Is there any PHP script that generate password with digits from [a-zA-Z0-9] to suggest me? Thanx

Re: [PHP-DB] Slashes

2003-12-10 Thread John W. Holmes
Ng Hwee Hwee wrote: just a quick question.. does it mean, i don't have to worry that my user may type any commands in my text field that may hurt my system since magic_quotes_gpc is on? Heh...of course not. :) All magic_quotes is going to do for you is escape quotes within your text. This will

RE: [PHP-DB] password generator

2003-12-10 Thread Peter Lovatt
Hi HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 ---

Re: [PHP-DB] {PHP-DB} password generator

2003-12-10 Thread David T-G
Nikos -- ...and then Nikos Gatsis said... % % Hello list Hi! % % Is there any PHP script that generate password with digits from [a-zA-Z0-9] to suggest me? This just came up on the php list recently... The best one that I saw was a one-liner which peels the first N chars from an md5

Re: [PHP-DB] User defined function in a mysql query

2003-12-10 Thread Miles Thompson
1. Is the function allowed by MySQL? 2. Can you execute the function before the query, assign what it returns to a var, then place the var in your query? Miles At 04:43 PM 12/10/2003 +0100, antonio bernabei wrote: Hi, I need to make a join between two tables. And I can use the mysql_query

Re: [PHP-DB] password generator

2003-12-10 Thread Roger Spears
Here's one I've used recently with success http://www.devhood.com/tools/tool_details.aspx?tool_id=784 Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] User defined function in a mysql query

2003-12-10 Thread CPT John W. Holmes
From: antonio bernabei [EMAIL PROTECTED] I need to make a join between two tables. And I can use the mysql_query function: this is ok. The problem arises because I need to apply a user defined function to a field of one of the two tables and the rule for the join is WHERE

[PHP-DB] Cookies with fopen

2003-12-10 Thread Peter Westergaard
Hi all, Attempting to use PHP to navigate a foreign website, to collect data. This is thus only tangentially related to databases, so I apologize if some feel it's too off-topic. Is there any way to do something similar to fopen() except to also have PHP present a cookie to the foreign

[PHP-DB] Re: Cookies with fopen

2003-12-10 Thread Justin Patrin
Peter Westergaard wrote: Hi all, Attempting to use PHP to navigate a foreign website, to collect data. This is thus only tangentially related to databases, so I apologize if some feel it's too off-topic. Is there any way to do something similar to fopen() except to also have PHP present a

[PHP-DB] ordering output

2003-12-10 Thread redhat
I have a page that I put together that pulls in data for the time in individual fields - hour, minute, am/pm, month, day. I am going to alter the db to add year as well. I want to order this list by multiple criteria - first by year, then by hour, am/pm, minute. It is a page that lists shows

[PHP-DB] Missing Data in Columns

2003-12-10 Thread Ken Colburn
Only six of ten columns in a php table show up on the web. I've been using a standard format for many months now and the only difference here is that I'm drawing on more (seven) tables. Even more curious, running the select and where statements in mysql produces the full table. Also,

Re: [PHP-DB] ordering output

2003-12-10 Thread CPT John W. Holmes
From: redhat [EMAIL PROTECTED] I have a page that I put together that pulls in data for the time in individual fields - hour, minute, am/pm, month, day. I am going to alter the db to add year as well. I want to order this list by multiple criteria - first by year, then by hour, am/pm,

Re: [PHP-DB] Missing Data in Columns

2003-12-10 Thread Matt Matijevich
snip Any ideas? /snip could you post the code you use to output each table row? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Missing Data in Columns

2003-12-10 Thread Ken Colburn
On Wed, 10 Dec 2003 16:21:39 -0600, Matt Matijevich [EMAIL PROTECTED] wrote: snip Any ideas? /snip could you post the code you use to output each table row? *** Here's the code requested along with column headings and sort code: # write out table heading echo table width='75%' border='1'

Re: [PHP-DB] Missing Data in Columns

2003-12-10 Thread George Patterson
On Wed, 10 Dec 2003 17:10:46 -0500 Ken Colburn [EMAIL PROTECTED] wrote: Only six of ten columns in a php table show up on the web. I've been using a standard format for many months now and the only difference here is that I'm drawing on more (seven) tables. Even more curious, [snip] Any