can someone help me with this forum?

xjasonx

I'm having trouble with the part where it shows the topics. It shows part of the table, but it doesn't show who the author is and the post the author made. I checked this code in dreamweaver and it says there are no errors'.

Heres the url to the code:
http://24.31.36.232/php_testing/code.txt

Heres the page to an example topic:

http://24.31.36.232/php_testing/showtopic.php?topic_id=18

xjasonx

bump

Anyone know what's wrong with this? I'm pretty much stuck. If you need more information just ask.

stolzyboy

try throwing a simple

echo "in while";

after where you set the variables to ensure you are even
getting in the while loop,

for some reason, it looks like you aren't getting any results,
since it isn't even showing the html, that is why i don't think
your while is working

stolzyboy

or take the @ off of the mysql_fetch_array to stop suppressing
errors so you can troubleshoot

xjasonx

I tryed this.

while ($posts_info = mysql_fetch_array($get_posts_res)) {
echo
$post_id = $posts_info[post_id];
$post_text = nl2br(stripslashes($posts_info[post_text]));
$post_create_time = $posts_info[fmt_post_create_time];
$post_owner = stripslashes($posts_info[post_owner]);

and this.

while ($posts_info = mysql_fetch_array($get_posts_res)) {
$post_id = $posts_info[post_id];
$post_text = nl2br(stripslashes($posts_info[post_text]));
$post_create_time = $posts_info[fmt_post_create_time];
$post_owner = stripslashes($posts_info[post_owner]);
echo

Still the same.

stolzyboy

do this

while ($posts_info = mysql_fetch_array($get_posts_res)) {
$post_id = $posts_info[post_id];
$post_text = nl2br(stripslashes($posts_info[post_text]));
$post_create_time = $posts_info[fmt_post_create_time];
$post_owner = stripslashes($posts_info[post_owner]);
echo "i am in the while loop";

xjasonx

Still the same.

Is it possible that it's an error with one of the other scripts?

Heres a url that goes directly to showtopic.php

http://24.31.36.232/php_testing/showtopic.php

That page has a one error, but I don't know how important it is. Undefined index error.

stolzyboy

that isn't your problem, if you aren't seeing the echo'd

in the while loop, then that is your problem, your query isn't working correctly, the results aren't coming back right, try echoing out your query before you run mysql_query, like after this

$get_posts = "select post_id, post_text, date_format(post_create_time,
'%b %e %Y at %r') as fmt_post_create_time, post_owner from
forum_posts where topic_id = $_GET[topic_id]
order by post_create_time asc";

put this

echo $get_posts;

and see if the information is coming out right, i.e make sure there is something on both sides of any = sign

xjasonx

echo $get_posts displays:

select post_id, post_text, date_format(post_create_time, '%b %e %Y at %r') as fmt_post_create_time, post_owner from forum_posts where topic_id = 18 order by post_create_time asc

Is that right or should it be showing mysql results?

stolzyboy

yeah that looks ok, still unsure why you aren't getting into the while loop though

xjasonx

I'll try to figure something out, but if you couldn't figure it out, I doubt I can.

Thanks for the help.

stolzyboy

if you want, tomorrow, you can private message me and give me your ftp info and i will have it a go that way, may be easier for me to test things quickly if i have direct access, and don't worry i'm not malicous, i have done it for others here

xjasonx

I've never gave someone access to my webserver before, so I don't know exactly how it works'. It's something I need to learn though. I do have an ftp set up though. What information do you need to connect to my webserver?

stolzyboy

i'll just need the ftp username and password, i already know the ip addy since you sent me to a page on this thread, but don't put it out here for everyone to see, private message me and i will check it out tomorrow, unless you let me know before then that you got it figured out, but i'm hitting the hay for the night, talk at ya tomorrow

xjasonx

Thanks for all the help. Problem is solved.