help with edit page

dreamteam

the story_id gets posted from the previous page, here is the code i have so far:

<?php
require_once 'config.php';
$db =& DB::connect($dsn, $options);
if (DB::isError($db)) {
die($db->getMessage());
}
$sql = 'Select * From stories WHERE story_id=".story_id."';
$result =& $db->query($sql)
or die ("couldn't execute query.");
if (DB::isError($result)) {
die($result->getMessage());
}
while ($row =& $result->fetchRow(DB_FETCHMODE_ASSOC))
{
extract($row);
}
?>
<table width=725 border=0 cellspacing=0 cellpadding=0>
<tr>
<td>
Choose Category</td><td>
</td>
</tr>
<tr>
<td width=111>Headline</td>
<td width=614><input name=headline type=text id=headline value=<? echo $row['headline']; ?>></td>
</tr>
<tr>
<td>Description</td>
<td><input name=story_desc type=text id=story_desc value=<? echo $row['story_desc']; ?>></td>
</tr>
<tr>
<td>Text</td>
<td><input name=story_text type=text id=story_text value=<? echo $row['story_text']; ?>></td>
</tr>
<tr>
<td>Picture</td>
<td><input name=picture type=file id=picture value=<? echo $row['picture']; ?>></td>
</tr>
<tr>
<td>Select Target </td>
<td><select name='target'>
<option>Select One</option>
<option value='blank' name='$target'>Blank
<option value='parent' name='$target'>Parent
<option value='self' name='$target'>Self
<option value='top' name='$target'>Top
</select>
Currently set to: <? echo $target; ?></td>
</tr>
</table>

the text fields dont pick up anything from the database, thanks for helping.

hkarre

<? echo $row['headline']; ?>

If short tag support is not enabled in your php.ini using the <? by itself may not work. Why don't you try using <?php instead.

<?php echo $row['headline']; ?>

do the same for your other fields in your html.

This explains some stuff about the way PHP handles it's opening and closing tags:

http://codewalkers.com/phpdocs/language.basic-syntax.html#language.basic-syntax.phpmode

dreamteam

that doesn't matter with my server, but thanks for trying.

Edward_1980

Hi,

You made a while-circle here. After starting it your code is
{
extract($row);
}
So it looks to me like you end your circle to fast. I'm a newbie too, so I am not sure, but what happens when you put the } tag forwards?

Like this

<?php
while ($row =& $result->fetchRow(DB_FETCHMODE_ASSOC)) 
{ 
extract($row); 
?> 
<table width=725 border=0 cellspacing=0 cellpadding=0> 
<tr> 
<td> 
Choose Category</td><td> 
</td> 
</tr> 
<tr> 
<td width=111>Headline</td> 
<td width=614><input name=headline type=text id=headline value=<? echo $row['headline']; ?>></td> 
</tr> 
<tr> 
<td>Description</td> 
<td><input name=story_desc type=text id=story_desc value=<? echo $row['story_desc']; ?>></td> 
</tr> 
<tr> 
<td>Text</td> 
<td><input name=story_text type=text id=story_text value=<? echo $row['story_text']; ?>></td> 
</tr> 
<tr> 
<td>Picture</td> 
<td><input name=picture type=file id=picture value=<? echo $row['picture']; ?>></td> 
</tr> 
<tr> 
<td>Select Target </td> 
<td><select name='target'> 
<option>Select One</option> 
<option value='_blank' name='$target'>Blank 
<option value='_parent' name='$target'>Parent 
<option value='_self' name='$target'>Self 
<option value='_top' name='$target'>Top 
</select> 
Currently set to: <? echo $target; ?></td> 
</tr> 
</table> 
<?php
}
?>