Full record details not showing why

timsharpe

I have the code below that works fine and directs me to viewprofile.php.

<?php
$db = mysql_connect("localhost", "user","pass");
mysql_select_db("employment",$db);
$result = mysql_query("SELECT * FROM jobs ORDER BY category",$db);
if ($result) {
    while ($r = mysql_fetch_array($result)) {

    $job_title=$r["job_title"];
    $employer = $r["employer"];
        echo "<LI><A 

HREF=\"http://localhost/employment/viewprofile.php?job_title=$job_title\">$job_title,$e

mployer</A>";
        }
       }
?>

That works fine, now I have the viewprofile.php looking like:


<?php
$db = mysql_connect("localhost", "user","pass");
mysql_select_db("employment",$db);

if(isset($viewid))
$query= ("SELECT * FROM jobs WHERE category=$id");
$numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
    $job_title = mysql_result ($result, $i, "job_title");




$name = "$job_title";
echo $name
?>

And it is not showing the record details, what am I doing wrong?

Tim

Mordecai

Your problem, I believe, lies on this line:
$query= ("SELECT * FROM jobs WHERE category=$id");

You did not query on this line, you only set $query. Run mysql_query($query):
$result = mysql_query($query);

timsharpe

Ok I added that,

<?php
$db = mysql_connect("localhost", "user","pass");
mysql_select_db("employment",$db);

if(isset($viewid))
$query= ("SELECT * FROM jobs WHERE category=$id");
$result = mysql_query($query);
$numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
    $job_title = mysql_result ($result, $i, "job_title");




$name = "$job_title";
echo $name
?>

But I am getting the following error why?

Parse error: parse error, unexpected $end in e:\inetpub\wwwroot\employment\viewprofile.php on line 18

cgraz

you get that error because you have various parse errors throughout your code.

put single quotes around $id in your $query variable
close your for loop with a closing bracket
drop the parenthesis aroung $name = "$job title"; (although this may not cause a parse error, the quotes are not necessary)
put a semi-colon at the end of echo $name

Cgraz