Hi there,
Maybe it's a cultural misunderstanding. Inverted commas are what some people call "quotes", like those enclosing the word quote. Or do you call them "double quotes"?
Anyway, what I meant to say was:
- I input into a field a text, say: I love "Google"
- It would appear fine on the webpage which draws the info from the database.
- Then on my 'data correction form' which I have done up to amend data, in the textbox which echos this field, anything AFTER the first doublequotes/open-inverted-comma does not appear.
My question is: why?
I can give you the whole code here but it is too long but here goes:
--------------------
<html>
<head>
<link rel="stylesheet" type="text/css" href="../../css/style.css">
<title>Update Record</title>
</head>
<body>
<h3>Update Record</h3>
<?
if (!empty($HTTP_GET_VARS)) while(list($name, $value) = each($HTTP_GET_VARS))
$$name = $value;
if (!empty($HTTP_POST_VARS)) while(list($name, $value) = each($HTTP_POST_VARS))
$$name = $value;
$id=$_POST['id'];
include "../../tornsocks.php";
$link = mysql_connect("localhost",$username,$password);
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());
$query=" SELECT * FROM calendar_en WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
$startdate=mysql_result($result,$i,"startdate");
$enddate=mysql_result($result,$i,"enddate");
$eventname=mysql_result($result,$i,"eventname");
$eventsummary=mysql_result($result,$i,"eventsummary");
$filename1=mysql_result($result,$i,"filename1");
$filename2=mysql_result($result,$i,"filename2");
$filename3=mysql_result($result,$i,"filename3");
$filename4=mysql_result($result,$i,"filename4");
$filename5=mysql_result($result,$i,"filename5");
$filename6=mysql_result($result,$i,"filename6");
$filename7=mysql_result($result,$i,"filename7");
$filename8=mysql_result($result,$i,"filename8");
$filename9=mysql_result($result,$i,"filename9");
$filename10=mysql_result($result,$i,"filename10");
$filelink1=mysql_result($result,$i,"filelink1");
$filelink2=mysql_result($result,$i,"filelink2");
$filelink3=mysql_result($result,$i,"filelink3");
$filelink4=mysql_result($result,$i,"filelink4");
$filelink5=mysql_result($result,$i,"filelink5");
$filelink6=mysql_result($result,$i,"filelink6");
$filelink7=mysql_result($result,$i,"filelink7");
$filelink8=mysql_result($result,$i,"filelink8");
$filelink9=mysql_result($result,$i,"filelink9");
$filelink10=mysql_result($result,$i,"filelink10");
?>
<p>You are about to edit <strong>calendar</strong> id number: <? echo "$id" ?> in <strong>English</strong>.</p>
<p>If you do not wish to make any changes, click on the <strong><< Editorial Interface</strong> button to return.</p>
<form method="POST" action="dbase_interface.php">
<input type="submit" value="<< Editorial Interface">
</form>
<table width="100%" border="0" align="center"cellpadding="5" cellspacing="5">
<form action="change_record.php" method="post">
<input type="hidden" name="ud_id" value="<? echo "$id" ?>">
<tr valign="top">
<td width="150">
<p><strong>Start Date</strong>:</p>
</td>
<td width="530">
<p><input name="ud_startdate" type="text" value="<? echo "$startdate"?>" size="10" maxlength="10"> (YYYY-MM-DD, for example: 2005-12-28)</p>
</td>
</tr>
<tr valign="top">
<td width="150">
<p><strong>End Date</strong>:</p>
</td>
<td width="530">
<p><input name="ud_enddate" type="text" value="<? echo "$enddate"?>" size="10" maxlength="10"> (YYYY-MM-DD, for example: 2005-12-28)</p>
</td>
</tr>
<tr valign="top">
<td width="150">
<p><strong>Event Name</strong>:</p>
</td>
<td width="530">
<p><input name="ud_eventname" type="text" value="<? echo "$eventname"?>" size="80" maxlength="255"></p>
</td>
</tr>
<tr valign="top">
<td width="150">
<p><strong>Event Summary</strong>:</p>
</td>
<td width="530">
<textarea rows=50 cols=80 name="ud_eventsummary"><? echo "$eventsummary"?></textarea>
</td>
</tr>
<tr valign="top">
<td width="150">
<p><strong>File downloads</strong>:</p>
</td>
<td width="530">
<p>
File 01:<br><input name="ud_filename1" type="text" value="<? echo "$filename1"?>" size="80"><br>
URL 01:<br><input name="ud_filelink1" type="text" value="<? echo "$filelink1"?>" size="80">
</p>
<p>
File 02:<br><input name="ud_filename2" type="text" value="<? echo "$filename2"?>" size="80"><br>
URL 02:<br><input name="ud_filelink2" type="text" value="<? echo "$filelink2"?>" size="80">
</p>
<p>
File 03:<br><input name="ud_filename3" type="text" value="<? echo "$filename3"?>" size="80"><br>
URL 03:<br><input name="ud_filelink3" type="text" value="<? echo "$filelink3"?>" size="80">
</p>
<p>
File 04:<br><input name="ud_filename4" type="text" value="<? echo "$filename4"?>" size="80"><br>
URL 04:<br><input name="ud_filelink4" type="text" value="<? echo "$filelink4"?>" size="80">
</p>
<p>
File 05:<br><input name="ud_filename5" type="text" value="<? echo "$filename5"?>" size="80"><br>
URL 05:<br><input name="ud_filelink5" type="text" value="<? echo "$filelink5"?>" size="80">
</p>
<p>
File 06:<br><input name="ud_filename6" type="text" value="<? echo "$filename6"?>" size="80"><br>
URL 06:<br><input name="ud_filelink6" type="text" value="<? echo "$filelink6"?>" size="80">
</p>
<p>
File 07:<br><input name="ud_filename7" type="text" value="<? echo "$filename7"?>" size="80"><br>
URL 07:<br><input name="ud_filelink7" type="text" value="<? echo "$filelink7"?>" size="80">
</p>
<p>
File 08:<br><input name="ud_filename8" type="text" value="<? echo "$filename8"?>" size="80"><br>
URL 08:<br><input name="ud_filelink8" type="text" value="<? echo "$filelink8"?>" size="80">
</p>
<p>
File 09:<br><input name="ud_filename9" type="text" value="<? echo "$filename9"?>" size="80"><br>
URL 09:<br><input name="ud_filelink9" type="text" value="<? echo "$filelink9"?>" size="80">
</p>
<p>
File 10:<br><input name="ud_filename10" type="text" value="<? echo "$filename10"?>" size="80"><br>
URL 10:<br><input name="ud_filelink10" type="text" value="<? echo "$filelink10"?>" size="80">
</p>
</td>
</tr>
</table>
<input type="Submit" value="Update">
</form>
<?
++$i;
}
?>
</body>
</html>