Help!

[aaadee]

Hi, i am now login in the page but only want the details that match the login credentials!

ie

Login in as

Adam Bell

and then in the task table page, only want to see the details for Adam Bell and no one else.

["User"]; ["Task_ID"]; ["Task_Name"]; ["Hours_Worked"]; ["Date_Work"]; ["Hours_Complete"]; ["Date_Complete"]; ["Comment"];

The Login value is

["User"];

So how do i get to login as Adam Bell and see ONLY Adam Bells work!

cheers

adam

[ugh82]

You must parse into your login page the id of the user from the authenticate section
and then you just make a query with the same id on your task table

=)

[aaadee]

THIS IS THE CODE FOR THE LOGIN!

<?
$sql = "SELECT * FROM jtrs_user ORDER BY user";
$connection = mysql_connect("localhost:3306", "", "") or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die ("Couldn't select database.");
$sql_result = mysql_query($sql) or die("Couldn't execute query.");

+++++++++++++++==================++++++++++++

And this the code for the task table!

<?php
switch( $do )
{

case "authenticate":

$connection = mysql_connect("localhost:3306","","") or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS") or die ("Unable to select database.");
$result = mysql_query($sql) or die ("Couldn't get results.");
$sql = "SELECT * FROM JTRS ORDER BY Task_ID";
$sql_result = mysql_query($sql,$connection) or die ("Couldn't execute query.");
$num = mysql_numrows($result);

then it just says how to display the problem! any more help would be much appreciated.

Thanks Adam

ugh82 wrote:

You must parse into your login page the id of the user from the authenticate section
and then you just make a query with the same id on your task table

=)

[icaro]

Adam Bell wrote:

THIS IS THE CODE FOR THE LOGIN!

<?
$sql = "SELECT * FROM jtrs_user ORDER BY user";
$connection = mysql_connect("localhost:3306", "", "") or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die ("Couldn't select database.");
$sql_result = mysql_query($sql) or die("Couldn't execute query.");

+++++++++++++++==================++++++++++++

And this the code for the task table!

<?php
switch( $do )
{

case "authenticate":

$connection = mysql_connect("localhost:3306","","") or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS") or die ("Unable to select database.");
$result = mysql_query($sql) or die ("Couldn't get results.");
$sql = "SELECT * FROM JTRS ORDER BY Task_ID";
$sql_result = mysql_query($sql,$connection) or die ("Couldn't execute query.");
$num = mysql_numrows($result);

then it just says how to display the problem! any more help would be much appreciated.

---

you are asking how to get data for only one user, right? you will need to save the name/code/something_unique of this user and use a query like this:
$sql = "SELECT * FROM jtrs WHERE user='$some_var'";

i really dont know if this is the question, but, for me, it means that you dont know basic sql sintaxe.. in this case, try a sql basic book (there are thounsands out there)

[and sorry for my poor english]

[flipis]

Well, i think that the problem here is the primary key of the table. If you defined one when you created it, there must be a column in the table that is unique in each row.

Then, you can use a sentence like

SELECT * FROM jtrs WHERE user='$some_var'

If you didn't define a primary key when creating the table, you can add an autonumeric field. It's a poor solution, but usable.

fLIPIS