[SOLVED] why is my array empty??

[mike12255]

I got the following code (will put at end) and im trying to grab some info from my database and stick it on the webpage however i get these errors:

 

Notice: Undefined variable: title in /home/content/p/p/f/ppffffpp/html/stayner.ca/TEST/showquestion.php on line 57

 

Notice: Undefined variable: message in /home/content/p/p/f/ppffffpp/html/stayner.ca/TEST/showquestion.php on line 60

 

Im not sure why  ??? anyway my code is below is somone could help - thanks.

 

 <?php
  $getthreads="SELECT * FROM forumtutorial_posts WHERE postid = '$page'";
$findamount = mysql_query($getthreads) or die (mysql_error());

//grab all the content
while($r=mysql_fetch_array($findamount))
{   
//the format is $variable = $r["nameofmysqlcolumn"]; - makes it easier to call later CAUSE IM LAZY!!
$answer=$r["answered"];
$title=$r['title'];
$post=$r['post'];
}
?>

[RussellReal]

uhh, can you show line 57 and line 60?

[mike12255]

57 is the first one, 60 is the last one:

 

 <td><div align="center"><strong><?=$title?></strong></div></td>
    </tr>
    <tr bgcolor="#E6E6E6">
      <td height="138"><div align="center" class="style1"><?=$message?></div></td>

[RussellReal]

try adding:

 

print_r($r);

 

into the while loop, to see if you're grabbing anything.

[mike12255]

oh nothing appeared so i guess im not getting anything...but i know that there is that table in my db

[RussellReal]

where do you set $page?

[mike12255]

right at the top of the page:

 

$page = $_GET['id'];

[RussellReal]

what does your table look like?

 

show a screenie or something if possible..

[mike12255]

http://img21.imageshack.us/img21/4605/problemy.jpg

[RussellReal]

ok..

 

try this:

 

<?php
if (isset($_GET['page'])) {
	$pid = (int) $_GET['page'];
	if ($pid) {
		mysql_connect("host.to.connect.to","user","password");
		mysql_select_db("dbToUse");
		$q = mysql_query("SELECT * FROM `forumtutorial_posts` WHERE `postid` = '$pid' LIMIT 1");
		if ($a = mysql_fetch_assoc($q)) {
			print_r($a);
		} else {
			// post $pid does not exist..
		}
	} else {
		// $pid is not a number or a positive number.
	}
} else {
	// page GET VAR not set
}
?>

 

change the values according to what you're doing

[mike12255]

well now i get output:

 

Array ( [postid] => 59 [answered] => 0 [area] => [author] => test [title] => test => test [showtime] => March 3, 2009, 4:06 pm [realtime] => 1236121616 [lastposter] => test [numreplies] => 0 [parentid] => 0 [lastrepliedto] => 0 [locked] => 0 )

 

[sasa]

are this code

<?php
  $getthreads="SELECT * FROM forumtutorial_posts WHERE postid = '$page'";
$findamount = mysql_query($getthreads) or die (mysql_error());

//grab all the content
while($r=mysql_fetch_array($findamount))
{   
//the format is $variable = $r["nameofmysqlcolumn"]; - makes it easier to call later CAUSE IM LAZY!!
$answer=$r["answered"];
$title=$r['title'];
$post=$r['post'];
}
?>

before this one

<td><div align="center"><strong><?=$title?></strong></div></td>
    </tr>
    <tr bgcolor="#E6E6E6">
      <td height="138"><div align="center" class="style1"><?=$message?></div></td>

[mike12255]

yes

[RussellReal]

just use the code I supplied, and mod it to work for your purpose

[mike12255]

using your code to set vars i could do this right:

 

 if ($a = mysql_fetch_assoc($q)) {
            $title = $a['title'];
$message = $a['post'];

[RussellReal]

yes sir