Page 1 of 1
Help
Posted: Wed Dec 15, 2010 10:49 am
by mirana
I'm working on this table I direct the link below.I got the source quote somewhere. I setup the sql with Max Pictures and Max Video from bigint to text collate latin1_general_ci. Even after I change it I cannot modify those Max Pictures or Max Video with any letters or Char.Then I type a letter and save it, it is automatically assigning zero instead of what ever I replaced. I'm not sure what I'm missing. I thought in the beginning the bigint initialization is the one assigning the zero. So why it is assigning even though I change it to text collate latin1_general_ci?
http://picasaweb.google.com/lh/photo/5h ... directlink
THank you for your help
Re: Help
Posted: Thu Dec 16, 2010 11:34 am
by mirana
Does anyone know whats wrong?
I cannot paste the code since it has lots of coding. I'm not sure where it can be wrong

Re: Help
Posted: Thu Dec 16, 2010 11:48 am
by Celauran
It's going to be pretty tough for us to guess without seeing the code. You don't necessarily need to post all the code for the entire page, just what's relevant to this problem.
Re: Help
Posted: Thu Dec 16, 2010 1:27 pm
by mirana
hopefully these r the html, sql and php code.
this is the html code that define video
Code: Select all
<tr>
<td class="{$warning_package_subscription_videos}">
<font class="{$warning_package_subscription_videos}" id="lbl_package_subscription_videos"># Videos</font>
<font class="form_field_warning">*</font> </td>
<td>:</td>
<td>
<input type="text" name="package_subscription_videos" value="{$cpackage_subscription_videos}" class="{$warning_box_package_subscription_videos}" style="width:50px" id="box_package_subscription_videos" onchange="change_color('box_package_subscription_videos', '#FFFFFF', 'black', 'lbl_package_subscription_videos', 'black')" />
<input type="hidden" name="required_package_subscription_videos" value="text" />
</td>
</tr>
*****************************************************************************************************************************************************************************************************************
in sql, it is define as:
`package_subscription_videos` text collate latin1_general_ci NOT NULL,
*****************************************************************************************************************************************************************************************************************
in php
$txt_field .= "package_subscription_videos;";
------------------------------------------------------------------------------------
Code: Select all
while ($row = mysql_fetch_array($result)) { if ($i % 2 == 1) {
$package_subscription_bgcolor = "#e7f4fc";
} else {
$package_subscription_bgcolor = "#FFFFFF";
}
$package_subscription_videos = $row[package_subscription_videos];
$i++; } mysql_close($db_connect);
$smarty->assign("package_subscription_videos", $arr_package_subscription_videos);
Re: Help
Posted: Thu Dec 16, 2010 1:34 pm
by mirana
maybe this is the html file:
Code: Select all
<tr>
<td class="{$warning_package_listing_video}">
<font class="{$warning_package_listing_video}" id="lbl_package_listing_video">Max Video </font>
<font class="form_field_warning">*</font> </td>
<td>:</td>
<td>
<input type="text" name="package_listing_video" value="{$package_listing_video}" class="{$warning_box_package_listing_video}" style="width:50px" id="box_package_listing_video" onchange="change_color('box_package_listing_video', '#FFFFFF', 'black', 'lbl_package_listing_video', 'black')" />
<input type="hidden" name="required_package_listing_video" value="text" />
</td>
</tr>
****************************************************************************************************************************************************************************************************************
sql define:
`package_listing_video` text collate latin1_general_ci NOT NULL,