Newbie try to show only one line on MYSQL/PHP

[boldorus]

I'm a newbie,

I have made a database with data about members ( id,name,email, ... ) with MYSQL. I have made a table in html with some data about ALL the members. Now i'm trying to make another page with the data but FOR ONLY A SINGLE MEMBER.

In other words, I want to show only a particular line in my database. I have copied some codes of my singlemember.php page in progress. Maybe i can adapt from there or i must start from scratch, you tell me.

Last question, how should I write my hyperlinks so it can activate my singlemember.php page but with the data of my line 1
( id=1 ) ? Something like .../singlemember.php?id=1

<?php
//1
include "template.inc";

//2
$db = mysql_connect('HOST','USER','PASSWORD');
mysql_select_db('DATABASE',$db);
$sql = 'SELECT id,name,rank,email FROM tablename_tbl';
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

//3
$tpl = new template("gabarits");
$tpl->set_file("gliste","singlemember.html");

//4
$tpl->set_block('gliste','liste_clients','liste_bloc');

//5
while($data = mysql_fetch_array($req)) {

//6
$tpl->set_var("id", $data['id']);
$tpl->set_var("perso", $data['name']);
$tpl->set_var("rang", $data['rank']);
$tpl->set_var("email", $data['email']);

//7
$tpl->parse('liste_bloc','liste_clients',true);
}

//8
mysql_close();

//9
$tpl->pparse("affichage","gliste");
?>

Thanks for your help

[lanjoky]

Dont know if this is what you are looking for but:

If you can pass the id of the user through the url then just change

$sql = 'SELECT id,name,rank,email FROM tablename_tbl';
to
$sql = 'SELECT id,name,rank,email FROM tablename_tbl WHERE id = @';
@ being the variable name of the id you passed through the URL or querysting

[boldorus]

How should i write the link to see if my page work?

I have uploaded your suggestion. But to make it work i must write the instruction in the link.

I tried the following link
.../singlemember.php?id=1

But i receive the error message :
SQL Error !
SELECT id,perso,rang,email FROM flq_tblWHERE id = @
You have an error in your SQL syntax near '= @' at line 1

[kevinsequeira]

two things ..

1. as lanjoky suggested change ure sql

$id = $_GET['id'];
$sql = 'SELECT id,name,rank,email FROM tablename_tbl where id='.$id;

2. on the page from where u link to this page have the url link like this

echo '<a href=/singlemember.php?id=XXXX>click</a>';

where XXX is the id of the member
example
echo '<a href=/singlemember.php?id=1>click</a>';

reg
kevin

[boldorus]

These are my current lines:

$id = $_GET['id'];
$sql = 'SELECT id,perso,rang,email FROM flq_tblwhere id ='.$id ;
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

And the error message i get when trying to reach it with
.../singlemember.php?id=1

SQL Error !
SELECT id,perso,rang,email FROM flq_tblwhere id = 1
You have an error in your SQL syntax near '= 1' at line 1

[kevinsequeira]

light up ure cigar ..

change
$sql = 'SELECT id,perso,rang,email FROM flq_tblwhere id ='.$id ;

to

$sql = 'SELECT id,perso,rang,email FROM flq_tbl where id ='.$id ;

est-ce-que ça marche maintenant ?

reg
kevin

[lanjoky]

Originally posted by boldorus
These are my current lines:


$id = $_GET['id'];
$sql = 'SELECT id,perso,rang,email FROM flq_tblwhere id ='.$id ;
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

And the error message i get when trying to rech it with
.../singlemember.php?id=1

SQL Error !
SELECT id,perso,rang,email FROM flq_tblwhere id = 1
You have an error in your SQL syntax near '= 1' at line 1

$sql = "SELECT id, perso, rang, email FROM flq_tbl where id = $id" ; try that line replacing the one u have

HEHE OR what he said 🙂

[boldorus]

It work fine !!!

Thanks for your precious help.
After reading big chunks of documentations about PHP and/or MYSQL. I was tired of waiting a reply from PHPfrance's forum, wich never came. Good thing you were there.

Merci Beaucoup

André Aubertin
Montréal, Canada

[kevinsequeira]

pas de problème....

reg
kevin