Half a script

[mysql_query]

Hello everyone. Imagine this: I have a script which displays a title field out of a table (the other fields are: id, title, info, and comments. Id is auto-increment). I want to be able to click the title, and for the rest of the feilds to come up on a new page. (From what i understand it's something like "index.php?id=1). Can someone reccomend a tutorial or give me a few pointers (snippets of code) on how to do this.

Thanks.

[merkinmuffley]

i'll try to help without too much clutter of details...
Step 1 you already described- query the database for all the titles you want to display, and link each one to the same page, passing the unique id for the story.

On that page, from a high-level standpoint you need to do 2 things: retrieve the database record for whatever id was passed in, and display the data.

You'd be well served by searching this site for tutorials on general mysql+php stuff, or going to www.php.net and reading thru the manual section on mysql functions. Better yet, do both. By that time you should have all you need to pull this off. Good luck.

[mysql_query]

Can someone tell me how to pass the id?

Thanks.

[tha_mink]

sure here ya go...

on the original page....

<?
$query = "SELECT name, id FROM table";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_object($result)) {
       print"<p><a href=\"nextpage.php?id=$row->id\">$row->name</a></p>";
}
?>

Then on the next page just do...

<?
$query = "SELECT * FROM table WHERE id='$id'";
$result = mysql_query($query) or die(mysql_error());
$row= mysql_fetch_object($result);
print"<P>$row->name</p>";
print"<P>$row->info</p>";
print"<p>$row->comments</p>";
?>

That will work assuming you have register_globals on. if not add this line above the query.
$id = $HTTP_POST_VARS['id'];

good luck
tha_mink

[mysql_query]

Hello. The above code comes up with a blank page. Here's the complete code:

<?php
$db = mysql_connect("localhost","thawowi","password");
mysql_select_db("dbthawowi_0",$db);;
$callsign = $HTTP_POST_VARS['callsign']; 
$sql="SELECT callsign, name FROM roster ORDER BY callsign";
$res=mysql_query($sql, $db);
while ($ligne = mysql_fetch_object ($res)) {
  print"<p><a href=\"roster.php?callsign=$row->callsign\">$row->name</a></p>";
}


$query = "SELECT * FROM roster WHERE callsign='$callsign'";
$resultat = mysql_query($query) or die(mysql_error());
$row= mysql_fetch_object($resultat);
print"<P>$row->id</p>";
print"<P>$row->name</p>";
print"<P>$row->hours</p>";
print"<p>$row->last_flt</p>";
?>
</table>
</body>
</html>

'callsign' is like 'id'. It is unique. Can someone tell me why it does not work?

Thanks.

[MrAlaska]

You are populating $ligne, but asking for the data from $row

<?php
while ($ligne = mysql_fetch_object ($res)) {
  print"<p><a href=\"roster.php?callsign=$row->callsign\">$row->name</a></p>";
}
//will get no results from $ligne
?>

<?php
while ($ligne = mysql_fetch_object ($res)) {
  print"<p><a href=\"roster.php?callsign=$ligne->callsign\">$ligne->name</a></p>";
}
// this might work better
?>

Another tip when developing, you should put 'or die(msql_error());' after every mysql command, or go one step farther and echo the sql string. It can ofte help you locate problems.

mysql_query($sql) or die (mysql_error()."<p>".$sql."<p>")

Another tip is to turn error reporting on, which I think would have shown you the problem above:

error_reporting(E_ALL);

on top of every page.

[tha_mink]

Also you need the

$callsign = $_POST['callsign'];

in the second part where you make the query

SELECT * FROM bla bla bla WHERE callsign='$callsign'

They call it logic for a reason

[MrAlaska]

Originally posted by tha_mink
Also you need the

$callsign = $_POST['callsign'];

That is a good point, explicitly declaring variables is good practice even if on a server where globals are turned on. However, in this case, it would actually be:

$callsign = $_GET['callsign'];

[tha_mink]

oh right:p

[mysql_query]

That works perfectly, thanks everyone.