Displaying fields in PHP, problem.

mysql_query

Hello. I have a script that displays the id of a row and when a user clicks it, it takes him/her to a new page with the rest of the info from that row. What I want to do is, instead of the field 'id', display the field 'title'. Here's my script:

<?php
$db = mysql_connect("localhost","t","");
mysql_select_db("dbthawowi_2",$db);;
$callsign = $HTTP_POST_VARS['id']; 
$sql="SELECT id FROM evaluation WHERE average>1.5";
$result=mysql_query ($sql, $db);
$secondsql="SELECT id, joke FROM userjokes WHERE id='$sql' AND validation='yes'";
$secondresult=mysql_query ($sql, $db);
while ($row = mysql_fetch_object ($secondresult)) 
{
 print "<td><a href=\"dump2.php?id=$row->id\" target=\"new\">" . $row->id . "</a>"; 
}
?>

Now, I make sure I pull the 'title' out of the database:

$secondsql="SELECT id, title, joke FROM userjokes WHERE id='$sql' AND validation='yes'";

And modify this to diplay the title:

while ($row = mysql_fetch_object ($secondresult)) 
{
 print "<td><a href=\"dump2.php?id=$row->id\" target=\"new\">" . $row->title . "</a>"; 
}

The problem is, when i use the first script that displays the id, it works. When I try to display the title, it gives me a blank page. Why?

Thanks.

bernouli

$secondsql="SELECT id, title, joke FROM userjokes WHERE id='$sql' AND validation='yes'";

is that correct? WHERE id ='$sql' ???

mysql_query

Yes, that is correct.

The reason I have two queries is that I need info out of 2 tables. In the table "evaluation", there is a rating for each row. So the query basically says

SELECT id FROM evaluation WHERE average (rating)>1.5

Then I work ONLY with the rows where the rating is more than 1.5

That part works fine, I teseted it when it displays the id. I can't get it to display the title.

Anyone else?

Thanks.

DwarV

but the line:
$secondsql="SELECT id, joke FROM userjokes WHERE id='$sql' AND validation='yes'";

doesn't make sense to me...

the contents of
$sql are not the results of the query, but $sql equals this line:

SELECT id FROM evaluation WHERE average>1.5

and not the results of this query
if you would replace $sql by $result
maybe it works?
because $result contains the results of mysql_query($sql,$db)

what i also don't understand is what this line does...

$secondresult=mysql_query ($sql, $db);
isn't that exact the same line as
$result=mysql_query ($sql, $db); ?

bretticus

I'm woth DwarV, why are you writing your second query as:

$secondsql="SELECT id, joke FROM userjokes WHERE id='$sql' AND validation='yes'";

Based on the code you have submitted that should set your second database query to:

SELECT id, joke FROM userjokes WHERE id='SELECT id FROM evaluation WHERE average>1.5 ' AND validation='yes'

????????????????????

mysql_query

Hello. Ok, this is very weird. This script (posted just below) works perfectly. Here it is:

<?php
$db = mysql_connect("localhost","","");
mysql_select_db("dbthawowi_2",$db);;
$callsign = $HTTP_POST_VARS['id']; 
$sql="SELECT id FROM evaluation WHERE average<1.5";
$result=mysql_query ($sql, $db);
$secondsql="SELECT id, joke FROM userjokes WHERE id='$sql' AND validation='yes'";
$secondresult=mysql_query ($sql, $db);
while ($row = mysql_fetch_object ($secondresult)) 
{
 print "<td><a href=\"dump2.php?id=$row->id\" target=\"new\">" . $row->id . "</a>"; 
}
?>

The diffrence between this script and the one I posted before is this one reads rows with a rating of LESS than 1.5, while the above one reads ratings with more than 1.5.

But this is not my problem, I could just copy this scriopt and change "<" to ">" But, I need, instead of this printing the id, i want it to print the 'title'. This script still gives me a blank page:

<?php
$db = mysql_connect("localhost","","");
mysql_select_db("dbthawowi_2",$db);;
$callsign = $HTTP_POST_VARS['id']; 
$sql="SELECT id FROM evaluation WHERE average>1.5";
$result=mysql_query ($sql, $db);
$secondsql="SELECT id, joke, title FROM userjokes WHERE id='$sql' AND validation='yes'";
$secondresult=mysql_query ($sql, $db);
while ($row = mysql_fetch_object ($secondresult)) 
{
 print "<td><a href=\"dump2.php?id=$row->id\" target=\"new\">" . $row->title . "</a>"; 
}
?>

This script worked until I changed the 'print' function to say ". $row->title." from ". $row->id."

Can someone tell me why?

Thanks.

mysql_query

I just figured out why it works only with 'id'

I repeat the same query twice, and both 'evaluation' and 'userjokes' hold a field id, but only 'userjokes', the query I am not proccessing, has the title field.

I'll fix this.

Thanks.

P.S. This really made me look like a fool.

bretticus

P.S. This really made me look like a fool.

Ah, don't worry about. Everybody gets stumped by the "last place you would suspect" every now and then. BTW, I didn't even catch the the query was using the same SQL string both times. I was just wondering how that could not throw a MySQL error at you ;-)