[SOLVED] Displaying mysql records individually

[Thauwa]

I know how to display records from mysql as a whole (say items in a shop). So there is no logging in or out.. only links. So how can I view each item with its details individually? tks in advance

[JoeBuntu]

Depends what you mean. I think that you are asking how to write a SQL statement that will narrow your result down to one specific record:

 

$sqlStatement = "SELECT * FROM SomeTable WHERE someField = 'somevalue'";

 

[Thauwa]

oh...that means I have to make all pages manually....unlike the thing I've seen on smf...

?action=erere

 

anyway....what you meant was right

[dropfaith]

just have it dynamicly echo out links

 

say

 

page.php?item=$itemName

 

 

then on page.php

MEH SOMETHING LIKE THIS

 

	$itemName = mysql_escape_string(trim(htmlentities($_GET['itemName'])));
				$query = "SELECT * FROM ITEMS WHERE itemName = '$itemName'";	
				$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

[Thauwa]

so... I do something like

 

$data = mysql_query("SELECT * FROM items") or die(mysql_error()); 
while($info = mysql_fetch_array( $data )) //array
{ 

$item= $info['item']

echo 'Item: <a href=http://www.ilovedoingstuff.com/items.php?item=$item>' .$info['item'] . ' </a>'; 
}

[dropfaith]

yeah if im not mistaken that will loop your database creating links

 

then the links just use the $get method in your search query

 

like i posted above

 

 

[Thauwa]

but is my code correct ?  ???

I am still a simple programmer! 

[keeps21]

but is my code correct ?  ???

I am still a simple programmer! 

 

$data = mysql_query("SELECT item FROM items") or die(mysql_error());
while($info = mysql_fetch_array( $data )) //array
{
   echo "Item: <a href=\"http://www.ilovedoingstuff.com/items.php?item={$info['item']}\">{$info["item"]}</a>";
}

 

I believe that should do it.

[Thauwa]

wow...and I think it did!