[PHP-DB] printing errors

2005-08-02 Thread umeed

most of the time wen dealing with
mysql,
i get error

bt i want to exactly know wt the error is
due to.

how can i print specific error tht wil make it easy to know 


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] mail function

2005-08-02 Thread hope of life

i m uing a form where user enters its email address
i get it on next page
n email user id n pwd (tht i get from database using query) 
2 the provided email address


?php  
if ($rec_email != ) 
  {

   mail($rec_email, $subject, $message, $from);
echo You will shortly receive our email;
  }

?

bt problm is k i dont recive mail through italthough
i recive msg YOu wil hortly recieve mail.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] IF command

2005-08-02 Thread hope

1st  of all b sure tht wt i the type of $delete

n wt value r u geting in it now
if u echo or print it.

then u can get a bettr idea 
as wt change mite b needd in ur if condition


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: General UPDATE question

2005-08-02 Thread hope

well if u use simple statmnt
update tablename

then it wil update all rows

n if u hv some where criteria
then only those rows (mayb 0,1 or many)
tht match criteria wil b updated

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: printing errors

2005-08-02 Thread David Robley
(umeed wrote:

 most of the time wen dealing with
 mysql,
 i get error
 
 bt i want to exactly know wt the error is
 due to.
 
 how can i print specific error tht wil make it easy to know

u cn us mysql_error() n prnt ur qry as well

And perhaps if you write properly your questions may be better understood



Cheers
-- 
David Robley

Change is inevitable, except from a vending machine.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: printing errors

2005-08-02 Thread Miles Thompson

David,

Amen to that! Vowels do help, don't they?

Started to read this thread, then thought Bah, if he doesn't care enough 
to help us understand his problem, why bother straining to understand 
this  crap?


Miles

At 09:27 AM 8/2/2005, David Robley wrote:

(umeed wrote:

 most of the time wen dealing with
 mysql,
 i get error

 bt i want to exactly know wt the error is
 due to.

 how can i print specific error tht wil make it easy to know

u cn us mysql_error() n prnt ur qry as well

And perhaps if you write properly your questions may be better understood



Cheers
--
David Robley

Change is inevitable, except from a vending machine.

--
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] Inputing a value into a image (?)

2005-08-02 Thread JeRRy
Hi,
 
When I created a header image I made a mistake when I completed it and did not 
relise until some time after it.  Now what has occoured is I through a value in 
the image instead of getting it to update from the database each time the page 
is loaded.
 
What I want to do is rip out the value (it's in red) and replace it with the 
continueation of the image liner.  Than run a query to the database to fetch 
the real updated value and put it in it,  
 
Now I know I can use div to do it but have noticed it's not reliable to place 
it in the right area with some browsers.  Making it messy.  Does anyone have 
any ideas on how to do it that is best with most browser? (the common ones)
 
The links are below so you can see.
 
Now if it's too much hassle I could put the value on another area of the page.  
But prefer there as that image is on all pages on default.  (header.php)
 
Or would I be better to put the image in as a flash and get flash to query the 
database?  Any suggestions/ideas I would appreciate.
 
Okay here is the link:
 
http://getpaid2reademails.com/pages/images/top_pic.gif
 
If that fails please try:
 
http://getpaid2reademails.com/
 
The area I mean is in red text ... Any questions just simply reply. :)
 
Thanks!
 
J


-
Do you Yahoo!?
  Yahoo! Photos: Now with unlimited storage

Re: [PHP-DB] Re: printing errors. .

2005-08-02 Thread Martin Norland

I would like to think that we could be a little nicer to this poor fellow.

He obviously typed all of these messages on a cellphone keypad without 
predictive text entry.  He's in dire straits, and needs our help.


At least, I really hope that's the case.

thrws i m gnna gt mdvl n hs ss

Incidentally - I *think* in some of these he's actually answering 
questions, but they must be fairly old, I archive every two months or so 
and I don't see any matches in my current.


cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International 
Outreach x3257
The opinion(s) contained within this email do not necessarily represent 
those of St. Jude Children's Research Hospital.



Miles Thompson wrote:

David,

Amen to that! Vowels do help, don't they?

Started to read this thread, then thought Bah, if he doesn't care 
enough to help us understand his problem, why bother straining to 
understand this  crap?


Miles

At 09:27 AM 8/2/2005, David Robley wrote:


(umeed wrote:

 most of the time wen dealing with
 mysql,
 i get error

 bt i want to exactly know wt the error is
 due to.

 how can i print specific error tht wil make it easy to know

u cn us mysql_error() n prnt ur qry as well

And perhaps if you write properly your questions may be better understood


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] pdo does not thrown errors on simple usage faults

2005-08-02 Thread Meno Abels
Hi there,
 
I have just begun an implementation of the PDO and have noticed an
unusual behaviour.
The following code is supplied as an example to illustrate this. The
main issue here is
that no error is thrown. There is no notice of failure at all for the
second fetch/execute which returns just an empty array.

thanks in advance

meno
?php
$dbh = new PDO('mysql:dbname=myDatabase;host=localhost',
'myUserName', 'myPassWord');
$dbh-setAttribute(PDO_ATTR_ERRMODE,PDO_ERRMODE_WARNING);
$sql = 'SELECT id  FROM my_table WHERE id  :id limit 0,10';
$sql2 = 'SELECT id, title FROM my_other_table WHERE id  :id limit 0,10';
$stmt1 = $dbh-prepare($sql);
$stmt2 = $dbh-prepare($sql2);
$stmt1-execute(array(':id'=4));
while($row = $stmt1-fetch()){
print_r($row);
$stmt2-execute(array(':id'=2));
$row = $stmt2-fetchAll();
print_r($row);
print_r($dbh-errorInfo());
}
?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Kathy A Wright/CORP/Keane is out of the office.

2005-08-02 Thread Kathy_A_Wright
I will be out of the office starting  08/01/2005 and will not return until
08/08/2005.

If you need immediate assistance please contact the Corp IT Systems
Administration Team.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Collation?

2005-08-02 Thread sub
There's a new thing in my SQL db, but I don't know what it is. Using
phpMyAdmin to view the structure of my table.

A column called: Collation
It has a value of latin1_swedish_ci for most of the fields. All but date
fields. Anyone know what this is?

Andrew Darrow
Kronos1 Productions
www.pudlz.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php