use their own id

[ecabrera]

is it possible to use the while out side the php for ex.

 

<?php

 

require "scripts/connect.php";

 

$query = mysql_query("SELECT * FROM news WHERE section='gtkphp'");

while($rows = mysql_fetch_assoc($query)){

 

$id = $rows['id'];

$title = $rows['title'];

$body = $rows['body'];

}

mysql_close();

?>

 

make eache like have its own id number

 

<a href="view.php?='<?php echo $id;?>"></a>

<a href="view.php?='<?php echo $id;?>"></a>

<a href="view.php?='<?php echo $id;?>"></a>

[trq]

You need to have this:

 

<a href="view.php?='<?php echo $id;?>"></a>
<a href="view.php?='<?php echo $id;?>"></a>
<a href="view.php?='<?php echo $id;?>"></a>

 

within your loop.

[ecabrera]

say i have a table wounld'nt this mulitple

[trq]

What?

[ecabrera]

say i want them to be should inside a table how would i do that so the table dose not multiple

 

<table>

<tr>

<td>

<a href="view.php?='<?php echo $id;?>"></a>

<a href="view.php?='<?php echo $id;?>"></a>

<a href="view.php?='<?php echo $id;?>"></a>

</td>

</tr>

</table>

[trq]

<table>
<?php while($rows = mysql_fetch_assoc($query)) {?>
<tr>
<td>
<a href="view.php?='<?php echo $id;?>"></a>
<a href="view.php?='<?php echo $title;?>"></a>
<a href="view.php?='<?php echo $body;?>"></a>
</td>
</tr>
<?php } ?>
</table>

[ecabrera]

nope

 

<?php

require "scripts/connect.php";

$query = mysql_query("SELECT * FROM news WHERE section='gtkphp'");


$id = $rows['id'];
$title = $rows['title'];
$body = $rows['body'];

?>

<table>
<?php while($rows = mysql_fetch_assoc($query)) {?>
<tr>
<td>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
</td>
</tr>
<?php } ?>
</table>

[trq]

Explain "nope"

 

I'm not a mind reader.

[ecabrera]

sorry , the id is the same as the other and the title to

[trq]

Your echoing the same links twice.

 

<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>

 

How do you want the table to display?

[ecabrera]

i want the table to be one table and inside the table mutiple links that take you to a diffrent page for example

 

 

<a href="view.php?=1">name1</a>

<a href="view.php?=2">name2</a>

<a href="view.php?=3">name3</a>

[trq]

<table>
<?php while($rows = mysql_fetch_assoc($query)) {?>
<tr>
<td>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
</td>
</tr>
<?php } ?>
</table>

[ecabrera]

does not work

 

i have this

 

<?php

require "scripts/connect.php";


$query = mysql_query("SELECT * FROM news WHERE section='gtkphp'");
while($rows = mysql_fetch_assoc($query)) {

$id = $rows['id'];
$title = $rows['title'];
$body = $rows['body'];

}
?>

<table>
<?php while($rows = mysql_fetch_assoc($query)) {?>
<tr>
<td>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
</td>
</tr>
<?php } ?>
</table>

[trq]

Look at your logic.

 

<?php

require "scripts/connect.php";


$query = mysql_query("SELECT * FROM news WHERE section='gtkphp'");
<table>
<?php while($rows = mysql_fetch_assoc($query)) {
$id = $rows['id'];
$title = $rows['title'];
$body = $rows['body'];
?>
<tr>
<td>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
</td>
</tr>
<?php } ?>
</table>

[ecabrera]

this doesn't work at all

[trq]

A few simple errors. I was missing a closing php tag.

 

Are you even trying to do this yourself?

 

<?php
require "scripts/connect.php";
$query = mysql_query("SELECT * FROM news WHERE section='gtkphp'");
?>
<table>
<?php while($rows = mysql_fetch_assoc($query)) {
$id = $rows['id'];
$title = $rows['title'];
$body = $rows['body'];
?>
<tr>
<td>
<a href="view.php?=<?php echo $id;?>"><?php echo $title;?></a>
</td>
</tr>
<?php } ?>
</table>

[ecabrera]

thorpe trust me i am trying

[PaulRyan]

This may seem off topic, but why don't people look at the code given and try it for themselves?

It really irates me when people expect the code you post to work exactly as they want it, and then when it doesn't they don't even try to fix it.

 

Simply looking at the code highlighting would should you that the ending PHP tag was missing, or am I just nit picking here?

 

Regards, PaulRyan.

[ecabrera]

PaulRyan im sorry you fill that way but i did try maybe my eyes didnt pick it up i was thinking on what other solution their was im human no a robot and thorpe thanks

[PaulRyan]

It wasn't a personal attack on you Ecabrera, it just happened to be this thread that cross the line for me.