I have been trying to find the answer on the postnuke forums and I have even
tried Sitepoint but I am unable to find an answer. So now I am asking here
in hopes that someone may have an idea
I am trying to put a query in a PHP block. However, when I do.. the block
dissapears.
I will try to explain better..
If I use a query like
$result = mysql_query("Enter Array Query Here");
while ( $row = mysql_fetch_array($result) )
{
ENTER CODE HERE
}
The block does not show up (I KNOW the query and code is good because it
works on a seperate page)
However, queries like the following do work
$query = mysql_query("ENTER QUERY HERE");
$result = mysql_result($query, 0, 0);
Basically.. as soon you use a query with the line of "while ( $row =
mysql_fetch_array($result) )" the block does not show up anymore. As I
said before, I know the query is good and it works, cause I have tested it
on seperate pages and have even used the most basic of queries.
When I say dissapear.. I do mean exactly that. If you use the 2nd query
that I posted.. you can see the block on the front page. As soon as I
change it to the other kind of query the block dissapears and is no longer
visable.
Anyone have any ideas? Or maybe have another way that I can accomplish the
query that I am trying to get without using hte "while.." line? Basically
I am trying to get FirstName, LastName and SUM(Posts) out of a table and
sort them by SUM(Posts), keeping the top 3
Thanks 2 2449
Have added any sql error checking??
Use the mysql_error( ) function to retrieve any errors between the query,
the fetch_array and the display of the rows.
The syntax you show in your examples is commonly used, and I for one can not
duplicate your problem using your example.
-Charles
"Cliff Roman" <cl***@nospam.theromans.us> wrote in message
news:BctZa.113637$o%2.49314@sccrnsc02... I have been trying to find the answer on the postnuke forums and I have
even tried Sitepoint but I am unable to find an answer. So now I am asking
here in hopes that someone may have an idea
I am trying to put a query in a PHP block. However, when I do.. the block dissapears.
I will try to explain better..
If I use a query like
$result = mysql_query("Enter Array Query Here"); while ( $row = mysql_fetch_array($result) ) { ENTER CODE HERE }
The block does not show up (I KNOW the query and code is good because it works on a seperate page)
However, queries like the following do work $query = mysql_query("ENTER QUERY HERE"); $result = mysql_result($query, 0, 0);
Basically.. as soon you use a query with the line of "while ( $row = mysql_fetch_array($result) )" the block does not show up anymore. As I said before, I know the query is good and it works, cause I have tested it on seperate pages and have even used the most basic of queries.
When I say dissapear.. I do mean exactly that. If you use the 2nd query that I posted.. you can see the block on the front page. As soon as I change it to the other kind of query the block dissapears and is no longer visable.
Anyone have any ideas? Or maybe have another way that I can accomplish
the query that I am trying to get without using hte "while.." line?
Basically I am trying to get FirstName, LastName and SUM(Posts) out of a table and sort them by SUM(Posts), keeping the top 3
Thanks
In Postnuke?
I have tried it on all 3 of my Postnuke sites and as soon as I do any query
like that the block dissapears.
I am stumped.. Guess I will just work around it and store temp results in
the database and call them out
"Charles E. Pelkey" <cp*****@charter.net> wrote in message
news:vj************@corp.supernews.com... Have added any sql error checking?? Use the mysql_error( ) function to retrieve any errors between the query, the fetch_array and the display of the rows. The syntax you show in your examples is commonly used, and I for one can
not duplicate your problem using your example.
-Charles
"Cliff Roman" <cl***@nospam.theromans.us> wrote in message news:BctZa.113637$o%2.49314@sccrnsc02... I have been trying to find the answer on the postnuke forums and I have even tried Sitepoint but I am unable to find an answer. So now I am asking here in hopes that someone may have an idea
I am trying to put a query in a PHP block. However, when I do.. the
block dissapears.
I will try to explain better..
If I use a query like
$result = mysql_query("Enter Array Query Here"); while ( $row = mysql_fetch_array($result) ) { ENTER CODE HERE }
The block does not show up (I KNOW the query and code is good because it works on a seperate page)
However, queries like the following do work $query = mysql_query("ENTER QUERY HERE"); $result = mysql_result($query, 0, 0);
Basically.. as soon you use a query with the line of "while ( $row = mysql_fetch_array($result) )" the block does not show up anymore. As I said before, I know the query is good and it works, cause I have tested
it on seperate pages and have even used the most basic of queries.
When I say dissapear.. I do mean exactly that. If you use the 2nd query that I posted.. you can see the block on the front page. As soon as I change it to the other kind of query the block dissapears and is no
longer visable.
Anyone have any ideas? Or maybe have another way that I can accomplish the query that I am trying to get without using hte "while.." line? Basically I am trying to get FirstName, LastName and SUM(Posts) out of a table and sort them by SUM(Posts), keeping the top 3
Thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dan Finn |
last post by:
OpenBSD 3.2
Apache 1.3.26
PHP 4.3.4
PHP-Nuke 6.9
getting these in the apache error log:
Sun Nov 16 20:20:16 2003] PHP Notice: Undefined variable:
HTTP_USER_AGENT in...
|
by: Ranga |
last post by:
Is it possible to simply grab a module from an existing page?
To clarify, I've got a htm frames site that I want to use in conjunction
with PHP-Nuke. The site is already up and running, and...
|
by: Doug |
last post by:
I was contemplating using php-nuke for a project. On the positive side,
it would make it easier to add new modules, and has many new modules
already installed. I'm not sure if the security part...
|
by: Walter Milner |
last post by:
I found php_mysql.dll in the ext folder, moved it up to c:\php, and
now its fine ( and thereby got PHPNuke going, which is what I was
trying to do). Is this the way its supposed to be set up?
|
by: Yair Sageev |
last post by:
Greetings.
I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I
backed up the drive using windows backup prior to the hard drive failure.
Now I have installed Apache2Triad...
|
by: Amit |
last post by:
I am new in the world of dot net nuke and so i need help from you all
to resolve this issue.As i have custom designed one project in dot net
nuke and published the site but i am facing very unique...
|
by: cssExp |
last post by:
hello,
Rather than going on a wild explanation on what's the the problem, it'll be much quicker and easier if i let you look at it yourself, so I'll post my page source (actual contents taken out,...
|
by: Marco tecnico |
last post by:
Hi NG,
i have a problem. I have finished building up a PHP Nuke 7.9 portal and would
like to insert in a page my Flash movie.
I did it in the past on another site in Php Nuke but i can't remeber...
|
by: happyperson |
last post by:
Hi All,
I want to have a news and product review website. I want an RSS feed, online forum, article submission section, and possibly down the road the ability to upload/download music to this...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |