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
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
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
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(
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
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
ow_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
View
Product
";
}
}
?>
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229955502.3530.3.ca...@lo
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
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
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
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";
}
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
"&
I've corrected those errors thanks but how do I insert this code as the else
statement?
View Product
--
- Gary Maddock-Greene
""Anthony Gentile""
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...
--
- 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
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
"
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($
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
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
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 =
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
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
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
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
. $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
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:
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
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
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-
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 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
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
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
33 matches
Mail list logo