Re: [PHP] Happy 1234567890 day!

2009-02-13 Thread Gary Maddock-Greene
Note quite there yet here but yes Happy 1234567890 day to you too -- - Gary Maddock-Greene "Luke Slater" wrote in message news:200902131812.43295.l...@blog-thing.com... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
so the correct way to do this is remove the $row_rsSearch = mysql_fetch_assoc($rsSearch); from my recordset query code. Thank you SanTa -- - Gary Maddock-Greene ""Sándor Tamás (HostWare Kft . )"" wrote in message news:dbb55d182b624f26be7f5125e592d...@stgepe... Yes, the

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
very helpful thank you :) -- - Gary Maddock-Greene ""Sándor Tamás (HostWare Kft . )"" wrote in message news:dbb55d182b624f26be7f5125e592d...@stgepe... Yes, the error is here. You get the record count with a mysql_fetch_assoc(), which reads the first record, and then st

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
roducts WHERE product_name LIKE %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text")); $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows(

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
Very helpful thanks Wolf. fyi the web site you see was done by my son. This is a live project that I was just asking for help on ... a pointer perhaps. Too much to ask I guess -- - Gary Maddock-Greene "Wolf" wrote in message news:20081222141852.ovv8i.364383.r...@cdptpa

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
I know you are so right Richard .. beleive me ... I wish I was year down the line so I knew how to get the html out of the php -- - Gary Maddock-Greene ""Richard Heyes"" wrote in message news:af8726440812220617l6c965cd0x6ae55f57fa96b...@mail.gmail.com... Also (and I kn

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
ow_rsSearch['product_name']." ". $row_rsSearch['product_subtitle'] ." View Product "; } } ?> -- - Gary Maddock-Greene "Ashley Sheridan" wrote in message news:1229955502.3530.3.ca...@lo

[PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
further information."; while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){ echo " - Gary Maddock-Greene -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
so back to the drawing board for me :) -- - Gary Maddock-Greene ""Gary Maddock-Greene"" wrote in message news:b4.82.23981.dee8e...@pb1.pair.com... thanks for the advice re html and php mashup!! I will research to find the way to do it outside the php. - Gary Maddock-Greene &q

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
so back to the drawing board for me :) -- - Gary Maddock-Greene ""Gary Maddock-Greene"" wrote in message news:b4.82.23981.dee8e...@pb1.pair.com... thanks for the advice re html and php mashup!! I will research to find the way to do it outside the php. - Gary Maddock-Gr

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
thanks for the advice re html and php mashup!! I will research to find the way to do it outside the php. - Gary Maddock-Greene ""Anthony Gentile"" wrote in message news:2ce4207d0812211021g215d5346wb0afcedf039ef...@mail.gmail.com... Sorry no products were found"; }

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
That's got it thanks Anthony. I love when you learn something. It was the back slash \ preceeding the "'s in my html that I wasn't aware of. Now I know they are needed if using "" in your code. Thank you so much for your help. -- - Gary Maddock-Greene "&

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
I've corrected those errors thanks but how do I insert this code as the else statement? View Product -- - Gary Maddock-Greene ""Anthony Gentile""

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
ode into the above after the echo "Please click on a product for further information.". I can't get the syntax right ... I appreciate everyones help -- - Gary Maddock-Greene "Ashley Sheridan" wrote in message news:1229878234.4229.12.ca...@localhost.localdomain...

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
-- - Gary Maddock-Greene "Ashley Sheridan" wrote in message news:1229875150.4229.9.ca...@localhost.localdomain... On Sun, 2008-12-21 at 15:40 +0000, Gary Maddock-Greene wrote: Thanks Ashley ... I have been trying that but I think my syntax id shot!! Please click on a product f

Re: [PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
Thanks Ashley ... I have been trying that but I think my syntax id shot!! Please click on a product for further information." ?> ?> View Product -- - Gary Maddock-Greene "

[PHP] eof bof in php

2008-12-21 Thread Gary Maddock-Greene
FROM products WHERE product_name LIKE %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text")); $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows($

Re: [PHP] Image Resizing

2008-12-21 Thread Gary Maddock-Greene
nice post Tedd and useful web site :) -Gary "tedd" wrote in message news:p06240802c573f5a71...@[192.168.1.101]... At 12:38 PM -0800 12/20/08, Stephen Alistoun wrote: Hi all, What is the best way in PHP to Resize an Image to a specific width. For Example I have images in the following sizes

[PHP] Re: Repeat Region Error

2008-12-21 Thread Gary Maddock-Greene
Sorry guys .. resolved it doh! I was freeing the recordset in -Gary ""Gary Maddock-Greene"" wrote in message news:5a.42.33998.4b83e...@pb1.pair.com... Hi All, I am getting the following error - Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource

[PHP] Repeat Region Error

2008-12-21 Thread Gary Maddock-Greene
Hi All, I am getting the following error - Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource in I think it has something to do with my Dreamweaver created code for a repeat region. The head code is: function GetSQLValueString($theValue, $theType, $theDefinedValue =

[PHP] Re: de-bug no input file specified

2008-12-20 Thread Gary Maddock-Greene
rote in message news:494c524d.40...@gmail.com... Gary Maddock-Greene wrote: Hi, is it possible to de-bug a 'no input file specified' error. I get the error when trying to run my search script but do not know whats causing it. Is it a common error? PHP5 with MySQL adn IIS7 Thanks

Re: [PHP] de-bug no input file specified

2008-12-19 Thread Gary Maddock-Greene
the common reason nginx has a "no input file specified" - people ask about it all the time. On Fri, Dec 19, 2008 at 3:15 PM, Gary Maddock-Greene wrote: the code was generated by Dreamweaver CS3 .. its php! How do I check the SCRIPT_FILENAME please? "mike" wrote in mess

Re: [PHP] de-bug no input file specified

2008-12-19 Thread Gary Maddock-Greene
Thanks Philip i am running a search from a form (page 1) querying the db and returning the result on page 2 (well thats the theory) ! "Philip Graham" wrote in message news:200812191822.58155.phi...@lightbox.org... > Hi Philip, > > Here is my code ... > > if (!function_exists("GetSQLValu

Re: [PHP] de-bug no input file specified

2008-12-19 Thread Gary Maddock-Greene
due to the SCRIPT_FILENAME being incorrect. not the code in the script. On Fri, Dec 19, 2008 at 2:54 PM, Gary Maddock-Greene wrote: Hi Philip, Here is my code ... $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_rea

Re: [PHP] de-bug no input file specified

2008-12-19 Thread Gary Maddock-Greene
. $colname_rsSearch . "%", "text")); $rsSearch = mysql_query($query_rsSearch, $MyDatabase) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows($rsSearch); ?> - Gary "Philip Graham" wrote in message news:2

[PHP] de-bug no input file specified

2008-12-19 Thread Gary Maddock-Greene
Hi, is it possible to de-bug a 'no input file specified' error. I get the error when trying to run my search script but do not know whats causing it. Is it a common error? PHP5 with MySQL adn IIS7 Thanks - Gary -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:

Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
Stuart you have been very helpful thank you. I have learnt a number of valuable lessons this afternoon. - Gary ""Gary Maddock-Greene"" wrote in message news:a4.34.09584.e39ab...@pb1.pair.com... Yes .. thanks Stuart. If I comment out that line I now get a different p

Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
Yes .. thanks Stuart. If I comment out that line I now get a different problem!! Unable to connect to database. One step closer!!! "Stuart" wrote in message news:a5f019de0812190556g611cd672k25a30b77d02ad...@mail.gmail.com... 2008/12/19 Gary Maddock-Greene : $sql_query = m

Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
ery) != 0) "Stuart" wrote in message news:a5f019de0812190516r3cdcdacana356320f39a8d...@mail.gmail.com... 2008/12/19 Gary Maddock-Greene : Thanks Stuart, Logs are no enabled and I generate this line: #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-

Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
com... 2008/12/19 Gary Maddock-Greene : Thanks Stuart, Logs are no enabled and I generate this line: #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken Sorry this is only my 2nd day with php/MySQL an

Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
: Re: [PHP] Re: HTTP Error 500 - IsapiModule 2008/12/19 David Robley : Gary Maddock-Greene wrote: Hi, Don't know if this is the right group but I am having real problems trying to connect to my MySQL db with php. I am trying to create a search form. I can connect and display in my browser a si

[PHP] Re: HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
Thanks David, but my log doesn't tell me anything (I don't think) !! I am assuming we are referring to the inetpub logs? -Gary "David Robley" wrote in message news:71.4b.09584.6698b...@pb1.pair.com... Gary Maddock-Greene wrote: Hi, Don't know if this is the ri

[PHP] HTTP Error 500 - IsapiModule

2008-12-19 Thread Gary Maddock-Greene
Hi, Don't know if this is the right group but I am having real problems trying to connect to my MySQL db with php. I am trying to create a search form. I can connect and display in my browser a simple call to a db record but when I try to execute my search script I get a 500 Internal Server err