Re: [PHP-DB] PHP Exercises

Yves, Thank you for the link.I will go through it. cheers From: Yves Sucaet <[EMAIL PROTECTED]> To: php-db@lists.php.net Sent: Friday, October 31, 2008 3:52:06 PM Subject: Re: [PHP-DB] PHP Exercises Hi Twaha, Have a look at a short-course curriculum that we d

Re: [PHP-DB] PHP Exercises

Isaak, Thank you for your advice.Got one book. Thank you again From: Isaak Malik <[EMAIL PROTECTED]> To: php-db@lists.php.net Sent: Friday, October 31, 2008 3:13:14 PM Subject: Re: [PHP-DB] PHP Exercises In my opinion the best way to learn it is by getting a b

Re: [PHP-DB] PDO bindValue ORDER BY

Technically, bound parameter is expecting a value, such as WHERE ID=:id However, ORDER BY is followed by a field name, such as ORRDER BY ID So I don't think it should work. If it does work, then it is a sign that the database driver is not really preparing the statement (as it should for pe

[PHP-DB] Re: MySQL Conditional Trigger

On Fri, Oct 31, 2008 at 11:09 AM, Dee Ayy <[EMAIL PROTECTED]> wrote: > ... > IF OLD.ShipDate != NEW.ShipDate AND NEW.ShipDate IS NOT NULL THEN > ... The following seems to work. Is it correct and not too verbose? IF (OLD.StatusShipDate IS NULL AND NEW.StatusShipDate IS NOT NULL) OR (OLD.StatusShi

[PHP-DB] PDO bindValue ORDER BY

Are pdo bound parameters within an ORDER BY clause broken in php 5.2.5? I find that in php 5.2.6 this works as expected: prepare($sql); $stmt->bindValue(':sort', $sort, PDO::PARAM_STR); $stmt->execute(); print_r($stmt->fetchAll(PDO::FETCH_ASSOC)); ?> but under php5.2.5 the ORDER BY clause silent

[PHP-DB] MySQL Conditional Trigger

I don't think my trigger likes a comparison with a variable which is NULL. The docs seem to have a few interesting variations on playing with NULL and I was hoping someone would just throw me a fish so I don't have to try every permutation (possibly using CASE, IFNULL, etc.). If my ShipDate (whic

Re: [PHP-DB] PHP Exercises

Hi Twaha, Have a look at a short-course curriculum that we developed over summer: http://lab.bcb.iastate.edu/training/webdev/nmsu/ hth, Yves - Original Message - From: "Twaha Uddessy" <[EMAIL PROTECTED]> To: Sent: Friday, October 31, 2008 2:19 AM Subject: [PHP-DB] PHP Exercises

Re: [PHP-DB] PHP Exercises

In my opinion the best way to learn it is by getting a book from your local library as reading from the screen can get very exhausting after a while. The manual is only good to increase your knowledge when you already know the basics. -- Isaak Malik Web Developer

Re: [PHP-DB] PHP Exercises

Sanjay, Thanks for your help!.I will go through it. Twaha From: Sanjay Mantoor <[EMAIL PROTECTED]> To: Twaha Uddessy <[EMAIL PROTECTED]> Cc: php-db@lists.php.net Sent: Friday, October 31, 2008 11:36:20 AM Subject: Re: [PHP-DB] PHP Exercises Twaha, I found PHP

Re: [PHP-DB] PHP Exercises

Twaha, I found PHP manual is best. Refer http://www.php.net/manual/en/ On Fri, Oct 31, 2008 at 1:49 PM, Twaha Uddessy <[EMAIL PROTECTED]> wrote: > Hello all, > Iam new here,trying hard to study PHP.Can anyone help me with a link where > I can get PHP exercises and possible solution?. > Thank

[PHP-DB] PHP Exercises

Hello all, Iam new here,trying hard to study PHP.Can anyone help me with a link where I can get PHP exercises and possible solution?. Thank you in advance

Re: [PHP-DB] pagination php mysql

I am implementing pagination on my php script, pagination is already working, the result is displayed as checkboxes for users to check their choices. my prob is if i have more than 1 page, users should be able to choose from all 4 pages, one solution is creating a temporal table, which c

Re: [PHP-DB] MySQL Query Timeout program in PHP

Man- when the query is fired through the web interface- it rans on mysql server max_execution_time - wont' help evn I stop apache itself... Yes it will. Apache will be instructed to stop execution of any script by the mod_php module (assuming you are using mod_php). But mysql process