Echo is not working

[mycro]

For some reason, the following code will not retreive the row data

[code]$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
$result1 = mysql_query($query2, $conn);
while($row=mysql_fetch_array($result1)) {

echo $row[topicid];
}[/code]

This same thing works if I simply change $row[topicid] to a different field, such as row[username]. There IS data in all of the topicid rows, btw. If it helps, "topicid" is the primary index in my database, and auto incriments. Thank you!

[bob_the _builder]

Hi,

maybe its topic_id?

Must be working fine if it displays the other variables.

[mycro]

no.. it's "topicid" ... I can't figure this out.

[rallokkcaz]

try this

[code]
$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
$result1 = mysql_query($query2, $conn);
while($row=mysql_fetch_array($result1)) {

echo $row['topicid'];
}[/code]

[mycro]

Hmm still nothing. This makes no sense!!

[rallokkcaz]

whats not working about it???

is there a connect to database script somewhere in the code
you might wanna try to just use something like
$_GET['topicid']

[bob_the _builder]

Yer, if other variables from the query work there is no reason why topicid shouldnt echo, doent matter that its set for auto incriments.

[perezf]

try this

[code]$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
$result1 = mysql_query($query2, $conn);
while($row=mysql_fetch_array($result1)) {
$topic = $row[topicid];
echo $topic;
}[/code]

[pocobueno1388]

[code]$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
$result1 = mysql_query($query2, $conn);
while($row=mysql_fetch_array($result1)) {

echo "$row[topicid]";
}[/code]

[kenrbnsn]

Put some debugging statements in your code to see what is going wrong:
[code]<?php
$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
echo "The query we are using is: $query2<br>";
$result1 = mysql_query($query2, $conn) or die("There was a problem with the query: $query2<br>" . mysql_error());
echo 'Number of rows retrieved: ' . mysql_num_rows($result1) . '<br>';
while($row=mysql_fetch_assoc($result1)) {
      echo '<pre>' . print_r($row,true) . '</pre>';  // this is the crucial debugging line. It will show you exactly what has been retrieved.
//      echo $row['topicid'];  remove this line for now (put it back after you figure out what is wrong)
}?>[/code]

Ken

[panyero2003]

Try this one..

$query2 = "SELECT * FROM topics WHERE timestamp='$timestamp'";
$result1 = mysql_query($query2, $conn);
while($row=mysql_fetch_array($result1)) {

echo "$row[topicid]";
}