php newbie,error in passing strings?help

Anon

<a href="javascript:void(0);" onClick="MM_openBrWindow('details.php?JobID=<? $JobID; ?>','details','scrollbars=yes,resizable=yes,width=400,height=400')">More Details</a></td></tr>

and then onto details.php

$result = mysql_query("SELECT * FROM JobsList, JobType, JobEmail WHERE JobEmail.EmailID = JobsList.JobEmail AND JobType.TypeID = JobsList.JobType AND JobID=" $JobID ") ;
if (!$result) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit();}

TIA
domo

techmeister

Whoa there!!

Try and explain your problem step by step:
I want to do x
I'm using y to do it
I tried method z
It works/don't work/nearly works

Russ

Anon

Sorry Russ, not too good at getting help when i need it most, thanks for you reply.

The function of my PHP is to pull out a bunch of jobs from a database.Basically I have a database composed of 3 tables, 1. for the individual job specs, 2. one for the mails that correlate to the person dealing with that job and 3. the type, i.e. permanent and temporary.

I have one page, jobs.php where i want to display all the jobs and a 2nd page, details.php where i hope to include the full specs of a job once someone has clicked on it on the jobs.php page.

This bit of a code lies at the bottom of each job detail snippet on jobs.php. I hope to pass the right job thru the id to the next page, details.php

<
<HEAD>
<TITLE> Forties People Jobs Database </TITLE>
<script language="JavaScript">

</script>
<style type="text/css">

</style>
</HEAD>
<BODY>
<?
$dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database.');
mysql_select_db ("db_name");

$result = mysql_query("SELECT * FROM JobsList, JobType, JobEmail WHERE JobEmail.JobEmailID = JobsList.JobEmailID AND JobType.JobTypeID = JobsList.JobTypeID ORDER BY JobsList.JobDate DESC;");if (!$result) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit();}

while ( $row = mysql_fetch_array($result) ) {

$JobID = $row["JobID"];
$JobTitle = $row["JobTitle"];
$JobLocation = $row["JobLocation"];
$JobSalary = $row["JobSalary"];
$JobDescription = $row["JobDescription"];
$JobITSkills = $row["JobITSkills"];
$JobEmailRealName = $row["JobEmailRealName"];
$TypeName = $row["TypeName"];
$JobDate = $row["JobDate"];

<tr><td align="left" valign="top" colspan="2"><b>Position</b>:

<? echo $JobTitle; ?></td></tr>

<tr><td colspan="3"><b>Location</b>:

<? echo $JobLocation; ?></td></tr>

<tr><td colspan="3"><b>Details</b>:

<? $SmallDescription = substr($JobDescription, 0, 200) . '...';

echo $SmallDescription; ?>

<a href="javascript:void(0);" onClick="MM_openBrWindow('details.php?JobID=<? $JobID; ?>','details','scrollbars=yes,resizable=yes,width=400,height=400')">More Details</a></td></tr>

<?
} ?>

</BODY>

Here is details.php

<?
$dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database.');
mysql_select_db ("db_name");

<HEAD>
<TITLE> <?$JobTitle?> </TITLE>
<style type="text/css">

</style>
</HEAD>
<body bgcolor="#0f3b7c">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="contact">
<tr>
<td height="28" valign="top" colspan="2">
<p><a href="javascript:;" onClick="window.close()">Close Window</a></p>
<p> </p>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td height="28">
<p>Title:
<? echo $JobTitle; ?>
</p>
<p>Type:
<? echo $TypeName; ?>
</p>
<p>Location:
<? echo $JobLocation; ?>
</p>
<p>Posted:
<? echo $JobDate; ?>
</p>
<p>Ref No:
<? echo $JobID; ?>
</p>
<p>Details:
<? echo $JobDescription; ?>
</p>
<p>IT Skills:
<? echo $ITSkills; ?>
</p>
</td>
<td height="28" valign="top">
<p><a href ="mailto: <? $JobEmailRealName ?> ">Apply</a></p>
<p><a href="#" onClick="window.print();return false">Print this page</a></p>
</td>
</tr>
</table>
</body>

Thanks in advance

DOMO

blackmamba

And the problem is what exactly?

Anon

Hi Donna

i get a parse error, line 6, which is the line with the SQL statement in it on the details.php page

thanks
dom

blackmamba

Yeah you need to change this...

$result = mysql_query("SELECT * FROM JobsList, JobType, JobEmail WHERE JobEmail.EmailID = JobsList.JobEmail AND JobType.TypeID = JobsList.JobType AND JobID=" $JobID ");

...to this...

$result = mysql_query("SELECT * FROM JobsList, JobType, JobEmail WHERE JobEmail.EmailID = JobsList.JobEmail AND JobType.TypeID = JobsList.JobType AND JobID=' $JobID ' ");