Re: [PHP-DB] Table optimization ideas needed

2008-03-27 Thread Shelley
On Thu, Mar 27, 2008 at 1:55 PM, Chris <[EMAIL PROTECTED]> wrote: > Good idea. But I wonder whether calling the trigger each insert will loose > > any performance. > > > > It's going to affect things slightly but whether it'll be noticable only > you can answer by testing. > > Another option I som

Re: [PHP-DB] Resource id #5

2008-03-27 Thread Stut
On 27 Mar 2008, at 17:51, Richard Dunne wrote: Can someone explain how I can translate Resource id #5 which is what I am getting from the code below? $result = mysql_query("Select answer from answers") or die(mysql_error()); $resultArray = explode(',',$result); for ($i=0;$i For the love of

RE: [PHP-DB] Resource id #5

2008-03-27 Thread Miguel Guirao
Been a positive integer, it jeans that the SQL query was succesfully executed, read the function description. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 --> -Original Message- --> From: Richard Dunne [mailto:[EMAIL PROTECTED]

[PHP-DB] Resource id #5

2008-03-27 Thread Richard Dunne
Can someone explain how I can translate Resource id #5 which is what I am getting from the code below? $result = mysql_query("Select answer from answers") or die(mysql_error()); $resultArray = explode(',',$result); for ($i=0;$ihttp://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub

Re: [PHP-DB] Not updating certain fields in same row

2008-03-27 Thread Jason Pruim
Hi Everyone Thanks for all the info and help with this, I have decided to write a separate function for changing the password. That way I can compare the original password with the one inputted in the database, and then change it after both have been the old and new password have been ver

Fwd: Re: [PHP-DB] mysql_num_rows, resource id #

2008-03-27 Thread Richard Dunne
This much is working: The output is 1 1 which is correct. One small step at a time, hopefully forward. Richard. --- Begin Message --- Richard Dunne wrote: In my code below, I am trying to verify that the query is selecting data from both rows of my answers table. I ha

Re: [PHP-DB] mysql_num_rows, resource id #

2008-03-27 Thread Evert Lammerts
Richard Dunne wrote: In my code below, I am trying to verify that the query is selecting data from both rows of my answers table. I have run the query on my MySQL CLI and getting answers from both rows, but running this script I get $rows = 0. I can't figure out why its not returning 2 for the n

[PHP-DB] mysql_num_rows, resource id #

2008-03-27 Thread Richard Dunne
In my code below, I am trying to verify that the query is selecting data from both rows of my answers table. I have run the query on my MySQL CLI and getting answers from both rows, but running this script I get $rows = 0. I can't figure out why its not returning 2 for the number of rows. It