dynamic buttons

buzzby

is there a way to make text that is pulled out of a database an actual link? for instance. i have a html template with 3 rows. row1 has the main menu buttons, row 2 has sub menu buttons and row 3 has the main text. for each button in row 1 there are 4 sub menu buttons which are shown in row 2. how do i get the submenu buttonsin row 2 to be links? all links are textual links. no pics

leatherback

eg.

echo "<a href=\"$row['LinkTarget']\">$row['LinkText']</a>";

buzzby

a little confused. i understand this code:

echo "<a href=\"$row['LinkTarget']\">$row['LinkText']</a>";

but what i want is this.

the link button are as follows. A1, A2, A3, A4, A5, A6, A7 etc. these will be pulled from the database depending on what button is pressed. (there is also B1, B2, B3 etc.) now these buttons are also links to information that will appear in the row below. so A1 is a link for A1 information and so on up until A7.

i hope i am explaining this correctly. i have got the table for the buttons as follows:

CREATE TABLE link2text (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
linkbutton VARCHAR(3) NOT NULL,
linktarget VARCHAR(50) NOT NULL,
linktitle VARCHAR(30) NOT NULL,
linktext TEXT NOT NULL,
PRIMARY KEY (id)
)

linkbutton is the A1, A2....., A7. all these need to be in on row. not just A1 but all up to A7. these buttons will point to the target in linktarget to get the relative text in linktext.

i hope i have said this properly.

buzzby

i basically want 1 row to contain all 7 buttons that are pulled from the database. and those 7 buttons link to textual information

leatherback

Hi,

Is this more along the lines what your are looking for?

$query = "select * from link2text where linkbutton like 'A%' order by linkbutton asc";

$result = mysql_query)$query) or die('Error in query:'.$query.mysql_error()');

while($row=mysql_fetch_array($result))
  {
  echo "<a href=ThisPage.php?id=\"$row['id']\">$row['LinkText']</a>";
  if($row['id'] == $_GET['id'])
     {
      $content = $row['linktarget'];
     }
  }
echo $content;

buzzby

i am really getting myself into a state here. the mock database that i wrote before worked fine. here is the code:

<?php 
$db=mysql_connect('localhost','root') or die('DB ERROR: Could not connect<br />'); 
mysql_select_db("danny",$db) or die('DB ERROR: Could not select DB'); 
$imageid = isset( $_GET['id'] ) ? $_GET['id'] : ''; 
//echo('Image ID "'.$imageid.'"<br />'); 
//$imageid; //contains the unique_id of the required image 
$res=mysql_query("SELECT * FROM imageslinks WHERE imageid='$imageid'",$db) or die('DB ERROR: '.$sql.'<br />'.mysql_error().'<br />'); 

echo "<table border=1 cellpadding=1 cellspacing=0 bordercolor=#DBDBDB>";
echo "<tr><td><b>image</b></td><td><b>Name</b></td><td><b>Address</b></td></tr>";

echo "<tr><td>";
if($row=mysql_fetch_array($res, MYSQL_ASSOC)) { 
  echo "<tr><td>";
  echo'<img src="http://localhost/images/'.$row["imageLink"].'">'; 
  echo "<td>";
echo $row["name"]; 
  echo "<td>";
echo $row["address"]; 
} else { 
  echo('There are no rows to fetch'); 
} 
echo "</td></tr></table>";
?>

this is fine for 1 row of information. but what if i have 3, 5 or 10 rows of information? how do i adapt this to th new situation?

buzzby

with that code just posted, the php and the html were build up at the same time. for this project i am undertaking the html template has already been build. i now have to slot the php in. the rows of information is confusing me because i have so far only seen how 1 row can be build. is this where the 'asc' comes in to it? i am really not sure at all

buzzby

i have apache, mysql, php installed on my machine. i would like to have phpmyadmin installed aswell so the transition of text files to the server phpmyadmin can be alot smoother. where is the best place to get it?