dynamic url help

tbobker

I need to add another variable into the url, i dont completly understand this i just use it, but i need the url to have the title of the page and a username associated with it. Bit confusing.

here is the code:

<?php 

function nav() 
{	

	include("dbconnect.inc");	
	$sql = "SELECT * from pages where title = '$_GET[id] AND username = '$_GET[username]'";	
	$result = mysql_query($sql, $conn);	

	echo "<table id='tnav' width='100%' cellspacing='0' cellpadding='0' style='padding-top: 0px;'>";

	while ($row = mysql_fetch_assoc($result))	
	{    	
		printf("<tr><td id='nav'><a title='$row[title]' href=\"%s?id=%s\">%s</a></td></tr>\n","pages.php", $row["title"],$row[title]);	
	}

	echo "</table>";
}
?>

tried to exchange the other $row[title] for $row[username] but no luck, basically i want a web page to bring up deifferent results based on the username?

If it makes sense?

here is the page im trying to display it all, bare in mind that the table in the database has 4 columns, id (pk, auto increment), username, title, content.

<?php
	include("dbconnect.inc");
	include ("nav.php");

$sql = "SELECT * from pages where username = '$_GET[username]'";
$result = mysql_query($sql, $conn);
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
	<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body>
<center>
	<table class="surround" cellspacing="0" cellpadding="0">
	<tr>
		<td class="head" colspan="2">
		</td>
	</tr>
	<tr><th class="nav_h">&nbsp;&nbsp;Navigation</th><th class="nav_h"><?php echo $row[title]; ?></th></tr>
		<tr><td height="3px"></td></tr>
		<tr>
			<td width="15%" valign="top">
				<?php echo nav(); ?>
			</td>
			<td class="content" align="left" valign="top">
				<?php echo $row[content]; ?>
			</td>
		</tr>
	</table>
</center>
</body>
<center>
</html>

bradgrafelman

Uh... few things.

Array indeces in your case should be strings. $row[name] does not have a string as an index, but a constant. PHP will detect this (assuming there actually isn't a constant named 'last') and throw an E_WARNING and then assume it is a string. So, use quotes: $row['name'].
Arrays, more specifically items in arrays referenced by indeces, should not simply appear inside a double-quoted string. If they do, they should be wrapped in braces ( {} ). Instead, I usually escape out of the string and concatenate the array in the middle, like so:
```
echo 'Your name is: ' . $row['name'] . '! Hello there.';
```
In your SQL query, you're missing an ending quote on the title parameter (after the $_GET[id] bit).

I'm not sure I'm following what your printf() is supposed to look like. Why even use printf?

while ($row = mysql_fetch_assoc($result))
     echo '<tr><td id='nav'><a title="' . $row['title'] . '" href="pages.php?id=' . $row['title'] . '">' . $row['title'] . "</a></td></tr>\n";

You're trying to echo nav() when the function doesn't return anything - it already echo's out the data.
Your SQL queries seem very messy. You're getting data from the same table two different times, and both times you're doing a "SELECT *". Is there a reason you're selecting all columns both times??

tbobker

Hey thanks for the help on the link, makes much more sense.

Im almost there and getting the right links based on the username, but the content isnt showing up, only showing the first record for each username and not bringing up the content as i click through the links?

this is my code so far:

Nvigation

<?php 

function nav() 
{	

	include("dbconnect.inc");	
	$sql = "SELECT * from pages where username = '$_GET[username]'";	
	$result = mysql_query($sql, $conn);	

	echo "<table id='tnav' width='100%' cellspacing='0' cellpadding='0' style='padding-top: 0px;'>";

	while ($row = mysql_fetch_assoc($result))	
	{    	
		echo '<tr><td id="nav"><a title="' . $row['title'] . '" href="pages.php?id=' . $row['title']. '&username=' . $row['username'] . '">' . $row['title'] . "</a></td></tr>\n";
	}

	echo "</table>";
}
?>

the template page:

<?php
	include("dbconnect.inc");
	include ("nav.php");

$sql = "SELECT * from pages where title='$_GET[id]' AND username = '$_GET[username]'";
$result = mysql_query($sql, $conn);
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
	<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body>
<center>
	<table class="surround" cellspacing="0" cellpadding="0">
	<tr>
		<td class="head" colspan="2">
		</td>
	</tr>
	<tr><th class="nav_h">&nbsp;&nbsp;Navigation</th><th class="nav_h"><?php echo $row['title']; ?></th></tr>
		<tr><td height="3px"></td></tr>
		<tr>
			<td width="15%" valign="top">
				<?php echo nav(); ?>
			</td>
			<td class="content" align="left" valign="top">
				<?php echo $row['content']; ?>
			</td>
		</tr>
	</table>
</center>
</body>
<center>
</html>

please help, so near!

tbobker

ive done it! thanks all for your help, im a very happy man!!!

if you want to see the code let me know!

bradgrafelman

Glad to hear you fixed it. Don't forget to mark the thread resolved. You might just post the final code as well, that way any future poster that comes across this thread will know how you worked it out.

tbobker

Its not resoved because like an idiot i wrote over the file and now am starting again, will post script when resolved!