select from table

hmgroen

😕

I've buid my tables with mysql, fild them up and can call information from it with the ROW commander.
There is also no problem for printing it on the screen.

What I want to do is after printing the table to select a line in this table for taken the information to inject it into a formulair for make some changes in this information.

Like it is a WHILE buckle I want to put at the end of every line a select button for select this line and take the information to my formulair page.
After including my button mysql gives me an error that he can't read this line.
Why?

print("<TABLE border=\"1\">");
print("<TR><TD colspan=\"10\"><B>Resultat de la recherche : </B></TD>");
print("<TR><TD>Titre</TD><TD>album</TD><TD>Auteur</TD>
<TD>Genre</TD><TD>Description</TD>
<TD>Ecouter ou Clic-droit</TD>
<TD>Selection</TD></TD>");

while ($row = mysql_fetch_array($Resultat,MYSQL_ASSOC))
{
print("<TR><TD>{$row["titre"]}</TD><TD>{$row["titrealbum"]}</TD><TD>{$row["nom"]}</TD><TD>{$row["genre"]}</TD><TD>{$row["nomdescription"]}</TD>
<TD><a href='{$row["chemin"]}'><p align='center'><img border='0' src='NoteMusique.gif' width='13' height='16'></p></a></TD>
<TD><p align='center'><img border='0' src="gauche.jpg" width='57' height='33'>
</p></TD>\n");
}

print("</TABLE>");

trexx

sure... try to escape the double quotes.

src="gauche.jpg"

should look like

src=\"gauche.jpg\"

hmgroen

Thanks it works

hmgroen

Sorry but I'm just beginning with php.

So after including my button, how can I do for he select me all the information in this line for sending it to the page I want.

Do I have to do another requette?

trexx

if i understand you right, you wanna have a list- and a detail-view, right?

if so, you have to loop through all entries like you already did. i guess every item in your DB has a unique ID. with that you can output a link for every item. something like:
<a href="detail-view.php?id={$row['id']}">{$row['title']}</a>

with that you'll get
<a href="detail-view.php?id=1">google</a>
<a href="detail-view.php?id=2">hotbot</a>
etc...

now you need to create a detail-view.php script that gets the Id out of the request with $_GET['id'] and then selects that entry by its ID out of your database.

hmgroen

if I'm right I put
<a href="detail-view.php?id={$row['id']}">{$row['title']}</a>

in my select comment.

In the beginning of this page I put:
require ("detail-view.php");

But I don't understand how to use

<a href="detail-view.php?id=1">google</a>
<a href="detail-view.php?id=2">hotbot</a>

with $_GET['id'] in the detail-view.php page.

trexx

nonono! =) detail-view.php is a page (script) on its own!

it has nothing to do with the code you have here... it's just for displaying a single entry.

the
<a href="detail-view.php?id=1">google</a>
<a href="detail-view.php?id=2">hotbot</a>
stuff was just an example how the HTML source code will look after you've executed your script.

on detail-view.php you do something like:

$rs = mysql_query( 'SELECT * FROM mytable WHERE id='.$_GET['id'] );
$row = mysql_fetch_assoc($rs);
echo $row['title'];

hmgroen

OK going on with my head in wood...!

So in

$_GET['id']

are stocked

id=1">google</a>
id=2">hotbot</a>
....

and in my script of the beginning

<TD><p align='center'><img border='0' src="gauche.jpg" width='57' height='33'>
</p></TD>\n");

is my reference select of every line

I'm right?

trexx

try this (it's a bit more readable also):

while ($row = mysql_fetch_array($Resultat,MYSQL_ASSOC)) 
{ 
	?>
	<TR>
		<TD><?=$row["titre"]?></TD>
		<TD><?=$row["titrealbum"]?></TD>
	     <TD><?=$row["nom"]?></TD>
	     <TD><?=$row["genre"]?></TD>
	     <TD><?=$row["nomdescription"]?></TD>
	     <TD align="center"><a href="<?=$row["chemin"]?>"><img border="0" src="NoteMusique.gif" width="13" height="16"></a></TD>
	     <TD align="center"><a href="detail-view.php?id=<?=$row["id"]?>"><img border="0" src="gauche.jpg" width="57" height="33"></a></TD>
	</TR>
	<?
}