[SOLVED] Really Need Help

[adam291086]

My fault i was tired and messed up the code. Try now

 

<?php
error_reporting(E_ALL);	
//Start session
session_start();
//Check whether the session variable
//SESS_MEMBER_ID is present or not
if(!isset($_SESSION['SESS_MEMBER_ID']) || (trim($_SESSION['SESS_MEMBER_ID'])=='')) {
header("location: library/access_denied.php");
exit();
}

include('../includes/config.php');
include('../includes/opendb.php');
$match_id = $_GET['id']
$query="SELECT * FROM matches WHERE match_id = '$match_id'";
$result=mysql_query($query)
$numrows=mysql_num_rows($result);
while($row=mysql_fetch_array($result))
{

$id = $row['id'];
$match_date = $row['match_date'];
}
echo $id;
echo $match_date;
?>

[giraffemedia]

Still the same i'm afraid.

[adam291086]

i just edited the code so try again

[giraffemedia]

i just edited the code so try again

 

Where is the code adam?

[adam291086]

<?php
error_reporting(E_ALL);	
//Start session
session_start();
//Check whether the session variable
//SESS_MEMBER_ID is present or not
if(!isset($_SESSION['SESS_MEMBER_ID']) || (trim($_SESSION['SESS_MEMBER_ID'])=='')) {
header("location: library/access_denied.php");
exit();
}

include('../includes/config.php');
include('../includes/opendb.php');
$match_id = $_GET['id']
$query="SELECT * FROM matches WHERE match_id = '$match_id'";
$result=mysql_query($query)
$numrows=mysql_num_rows($result);
while($row=mysql_fetch_array($result))
{

$id = $row['id'];
$match_date = $row['match_date'];
}
echo $id;
echo $match_date;
?>

 

i edited the post above

[giraffemedia]

Still the same. I've got no idea why the stripped down page won't work.

 

Is the ID being passed over correctly from the previous page?

 

[adam291086]

neither to i

 

<?php
error_reporting(E_ALL);	

include('../includes/config.php');
include('../includes/opendb.php');
$match_id = $_GET['id'];
$query="SELECT * FROM matches WHERE match_id = '$match_id'";
$result=mysql_query($query) or die('Error: ' . mysql_error());
while($row=mysql_fetch_array($result))
{

$id = $row['id'];
$match_date = $row['match_date'];
}
echo "id from the database".$id;
echo "match date from the database".$match_date;
echo "id from the URL".$match_id;
?>

 

what is the result form this

[giraffemedia]

id from the databasematch date from the database2008-05-17id from the URL3

[giraffemedia]

id from the databasematch date from the database2008-05-17id from the URL3

 

My id column is called match_id. If I change

$id = $row['id'];

to

$id = $row['match_id'];

I get 'id from the database3match date from the database2008-05-17id from the URL3'

 

Looks like the id column has been missing the match_ bit

[adam291086]

edit now follow these steps

 

 

Now add in the rest of the feild from the database to the while loop folling this example

 

$this is your variable name = $row['add the feild names here'];

 

 

Then at the bottom echo the variable out with a <br>

echo $match_date;
echo "<br />";

 

 

 

 

 

[giraffemedia]

That's all working fine Adam.

[adam291086]

mixture of me being tired and not really concentrating. Sorry. Hope you can get it all working now. Also don't for get "topic solved"

[giraffemedia]

I'd like to say thanks very much for your help - you've been extremely helpful. I really appreciate it.

 

Just so I know, what did you change to make the difference. Was it the id name?

[adam291086]

There were a few errors in your syntax.

 

You should read up on while loops that was the main problem

[giraffemedia]

Will do. I've really got the php bug after years of html and it's opened up a whole new world.

 

Thanks again for the help.

 

James

[adam291086]

Yeah once i started doing php the thing i was able to accomplish was amazing. I have been doing php for a couple of month and have bearly touched the subject. I am learning something new everytime i log into the board