[SOLVED] Urgently need help!! PHP Link

[magnetica]

Good Good..

 

Only having a laugh

 

Not a relevant place to put this.. but is there anywhere that tells when your title e.g. Noobie, NonSpammer, Forum Helper goes up when you have enough posts

[Yesideez]

Not that I've found but then I've not looked.

 

ow-design: What are the field names for the job title and description?

[ow-design]

job title is name

description is description

 

thanks!

[Yesideez]

Try this but don't forget to edit the SELECT call for your table data!

<?php


include("db.php");

// Get a connection to the database
  $jobid=$_GET['id'];
  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);


<table width="600" border="0">;
<?php
  if (is_numeric($jobid)) {
    $sql="SELECT * FROM jobs WHERE `jobid`='$jobid'";
    $fetch=mysql_fetch_assoc(mysql_query($sql));
    echo '<tr><td><strong>Job title:</strong></td><td>'.$fetch['name'].'</td></tr>';
    echo '<tr><td><strong>Details:</strong></td><td>'.$fetch['description'].'</td></tr>';
  } else {
    echo '<tr><td>I am unable to locate that job - sorry!</td></tr>
  }
?>
  </table>
  </html>

[ow-design]

okay new error on jobdetails.php

 

Parse error: syntax error, unexpected '<' in /home/deswo/public_html/clients/martin_pooley/jobdetails.php on line 11

 

line 11 is:

 

<table width="600px">

[/code

[Yesideez]

Oops!

<?php


include("db.php");

// Get a connection to the database
  $jobid=$_GET['id'];
  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
?>

<table width="600" border="0">
<?php
  if (is_numeric($jobid)) {
    $sql="SELECT * FROM jobs WHERE `jobid`='$jobid'";
    $fetch=mysql_fetch_assoc(mysql_query($sql));
    echo '<tr><td><strong>Job title:</strong></td><td>'.$fetch['name'].'</td></tr>';
    echo '<tr><td><strong>Details:</strong></td><td>'.$fetch['description'].'</td></tr>';
  } else {
    echo '<tr><td>I am unable to locate that job - sorry!</td></tr>
  }
?>
  </table>
  </html>

[Archadian]

In the code i gave you all you have to do is make a table to show the details on jobdetails.php and in the mysql_query() you have to put the name of the columns and the name of the table where the info on the jobs are. When i said my code wouldn't work i meant you have to put in the correct table names

[ow-design]

next prob? cant figure it out??

 

Parse error: syntax error, unexpected $end in /home/deswo/public_html/clients/martin_pooley/jobdetails.php on line 23

 

line 27 reads:

 

  </html>

[Yesideez]

I forgot to terminate an echo...

    echo '<tr><td>I am unable to locate that job - sorry!</td></tr>';

 

This happens when tired lol

[ow-design]

thanks!!, is working now, but when i click link from jobs.php the jobdetails.php just says unable to find job.

 

Sorry to keep you awake.

 

Ollie

 

[Yesideez]

Edit this line in the first script from this:

	<a href="jobdetails.php?<?php echo $fetch["id"]?>">More About Vacancy</a></font></td>

to this:

	<a href="jobdetails.php?id=<?php echo $fetch["id"]?>">More About Vacancy</a></font></td>

My mistake again!

[ow-design]

ok, looking better but am geting following message:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/deswo/public_html/clients/martin_pooley/jobdetails.php on line 15
[b]Job title:  
Details: [/b] 

 

line 15 reads:

    $fetch=mysql_fetch_assoc(mysql_query($sql));

[Archadian]

shouldn't it be this:

 

$fetch=mysql_fetch_assoc($sql);

[Yesideez]

You'll often find that the error often lies in a previous line or two before the line you get told it's in.

 

As I said earlier, the error is actually in the line that assigns the variable $sql the SELECT call - change it to suit your database.

[Yesideez]

shouldn't it be this:

 

$fetch=mysql_fetch_assoc($sql);

Sort of but we need to go one line before that because the SELECT call itself is wrong. ow-design hasn't changed it to suit his database and has used the default one I posted as an example.

[magnetica]

ow-design try this:

 

mysql_query($sql);

$fetch=mysql_fetch_assoc($sql);

 

Tell if it works or not

[magnetica]

Well lets take a look at the SELECT statement then

 

Post it on here

[ow-design]

Fantastic!!! got it to work.!!!

 

Thankyou so much to everyone who has helped me!!!

 

ESPECIALLY

Yesideez !!

 

Really appreciate it!!! Really Happy now:)

[Yesideez]

I'm glad to hear it!

 

You're just in time as I've got 8 minutes left as well

[ow-design]

Thanks for being so kind !

 

good night!