sql query

[Angelojoseph17]

I'm trying to create a pdf from a form where the user selects a machine_id and that pulls out a pdf based on the variable being passed. I'm pretty sure it is the query where i am doing something wrong. Can someone help. Much appreciated.

<?php
require('mysql_table.php');
$q=$_GET["q"];

class PDF extends PDF_MySQL_Table
{
function Header()
{
//Title
$this->SetFont('Arial','',18);
$this->Cell(0,6,'Machine Details',0,1,'C');
$this->Ln(10);
//Ensure table header is output
parent::Header();
}
}




//Connect to database
mysql_connect('localhost','bla','bla');
mysql_select_db('bla');

$pdf=new PDF();
$pdf->AddPage();
//First table: put all columns automatically
$this->Cell(0,6,'Repair History',0,1,'C');
$pdf->Table('SELECT * FROM repairs WHERE machine_number = $q');
$pdf->Output();

?>

 

[Pikachu2000]

You forgot to mention what the actual problem is.

[Angelojoseph17]

it will pull out the results from the database and insert it into the pdf.

 

lol sorry bit of dumb moment there.

[ManiacDan]

You've still forgotten to describe the problem.

 

Describe the problem.  Don't say "it doesn't work."  What doesn't work?  Does it email your grandmother?  Does it launch nuclear weapons?  Does it format your hard drive?

 

-Dan

 

PS - You cannot interpolate variables inside single quotes.  Had you debugged this and echoed the query, you would have seen '$q' instead of the contents of $_GET['q'].

[Angelojoseph17]

$pdf->Table('select * from repairs where machine_number = '.$q.'');

 

 

Thanks guys I got it to work in the end.

[ManiacDan]

You've still given us zero information, but at least it appears to be working now.