[RESOLVED] Bring data to my form from database

phprooky

Hi everyone,
I have a form where I would like to bring the values of one row in my database. Can anyone please help me?
This is my select:

<?PHP
require("my_database.php");
$id_fromclick=$_GET['id'];
$sql="Select * from $tbl_name where id=$id_fromclick";
$result=mysql_query($sql);

This is the form where I want to display the data and then update the values after changing what I need to change.

<form id="form1" name="form1" method="post" action="">
<table width="90%" height="193" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="19%">&nbsp;</td>
<td width="2%">&nbsp;</td>
<td width="79%">&nbsp;</td>
</tr>
<tr>
<td>Event Post Title</td>
<td><div align="center">:</div></td>
<td><input name="tittle" type="text" id="tittle" size="37" /></td>
</tr>
<tr>
<td>Your Name</td>
<td><div align="center">:</div></td>
<td><input name="author" type="text" id="author" size="37" /></td>
</tr>
<tr>
<td valign="top">Your Post</td>
<td valign="top"><div align="center">:</div></td>
<td><textarea name="post" id="post" cols="45" rows="12"></textarea></td>
</tr>
<tr>
<td>Date</td>
<td><div align="center">:</div></td>
<td><input name="date" type="text" id="date" size="37" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="submit" id="submit" value="Update Sport" /></td>
</tr>
</table></td>
</tr>
</table>
</form>

vividona

change the database rows inside the values in form

<form id="form1" name="form1" method="post" action="">
<table width="90%" height="193" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="19%">&nbsp;</td>
<td width="2%">&nbsp;</td>
<td width="79%">&nbsp;</td>
</tr>
<tr>
<td>Event Post Title</td>
<td><div align="center">:</div></td>
<td><input name="tittle" type="text" id="tittle" size="37" value="<?PHP echo $result['title']; ?>" /></td>
</tr>
<tr>
<td>Your Name</td>
<td><div align="center">:</div></td>
<td><input name="author" type="text" id="author" size="37" value="<?PHP echo $result['author']; ?>"/></td>
</tr>
<tr>
<td valign="top">Your Post</td>
<td valign="top"><div align="center">:</div></td>
<td><textarea name="post" id="post" cols="45" rows="12"><?PHP echo $result['post']; ?></textarea></td>
</tr>
<tr>
<td>Date</td>
<td><div align="center">:</div></td>
<td><input name="date" type="text" id="date" size="37" value="<?PHP echo $result['date']; ?>" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="submit" id="submit" value="Update Sport" /></td>
</tr>
</table></td>
</tr>
</table>
</form>

phprooky

Hi vividona and thanks for replying,
After bringing the data from the database, can I change and update the information?
Do I have to add an update statement in the same page?

phprooky

I already made the changes, but is not working. Is not displaying anything.

vividona

phprooky;10970346 wrote:
I already made the changes, but is not working. Is not displaying anything.

$sql="Select * from $tbl_name where id=$id_fromclick";

bcs you restricted your query with id=$id_fromclick
is the value of $id_fromclick already exists???

index?id=2

phprooky

That's because I bringing that id from another page where I click on a url.

vividona

add mysql_error to know if your query is valid or no

change your query to be

$result=mysql_query($sql); or die(mysql_error());

phprooky

I put this next to the Text field <?Php echo $rows['tittle']; ?> and is bringing the information, but not when I put it the way I want inside the Text field.

phprooky

I founf the solution now. I added a While statement before the form and after the form and now is working.

phprooky

Hi again vividona,
In the same form I also have a textarea, but when I run the php page the information on the text are doesn't show up. Do you know why is this happening? Can you help me please?