473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

PHP Block in Post Nuke - Problem

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
Jul 16 '05 #1
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

Jul 16 '05 #2
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


Jul 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
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...
1
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...
0
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...
3
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?
2
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...
0
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...
15
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,...
1
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...
1
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
0
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...
0
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...
1
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.