query question

[burge124]

hi i cant get this query to work any suggestions?

 

$result3 = mysql_query("SELECT * FROM userattampt WHERE chapterid = WHERE UserID = 1017 ORDER BY QuestionID");

[darkfreaks]

for one you did not define your chapter id its empty

[burge124]

sorry its missing a 1

 

 

$result3 = mysql_query("SELECT * FROM userattampt WHERE chapterid = 1 WHERE UserID = 1017 ORDER BY QuestionID");

[darkfreaks]

<?php

$qid=$_GET['QuestionID'];
$result3 = 
mysql_query("SELECT * FROM userattampt WHERE chapterid ='1' AND UserID ='1017' ORDER BY $qid");

?>

[burge124]

no that didnt solve it, do i need a join or a "." in the query?

 

[darkfreaks]

no you dont look at the code again

[burge124]

the query was fine sorry something else not happening oops

[darkfreaks]

add:

<?php
mysql_query
("SELECT * FROM userattampt WHERE chapterid ='1'
AND UserID ='1017' ORDER BY $qid") or die(mysql_error());?>

[burge124]

thanks for your help, from that query posted earlier im asking it to output times, although it keep cuming up with undefined index time & timecount any suggestions? (questiontitle works fine with a similar query)

 

  echo "<td>" . $row['TimeCount'] . "</td>";

  echo "<td>" . $row['QuestionTitle'] . "</td>";

  echo "<td>" . $row['Time'] . "</td>";

 

 

[darkfreaks]

dont know so what does it output ???

[burge124]

it should list from the results of the query in the table userattempt all of the times a user with the id 1017 answering question in chapter 1 but at the moment its causing undefined indexes

[darkfreaks]

try putting

 

ini_set('error_reporting',E_ALL);

 

in your code