Search:

Hi...anybody can help me?I feel lost about it...

Hi...guys!I have a multiple row table,the structure as declared below.



<table id ="claim_dtl">
<form name="claim_dtl">
<tr>
<td><input name="trainingCost" rel="calculate_input" type="text"...

Hi,guys! I have a PHP script to send mail and prompt out alert if successfully sent.However,the alert is not displayed and all the form value become blank.How can I display alert without having a...

Problem resolved.It is about field length of password.I set it only for varchar(15),not really enough for hashed value

Not really. I have tried that before.

Hi,guys! I have some user records in database which need to encrpyt their password by using md5().So, i write a piece of code to set passwords to encrypted value.



<?php ...

Thank for replying, is it neccessary for drop down menu to have selected="selected" ?

How about if INSERT statement mix with $_POST and $variable?
I having error on my INSERT statement.



...

Hey,guys! I have a form to upload image into database,which had a BLOB type column called banner to store the image.How can I specific it in INSERT statement?Thanks...



<form name="addMovie"...

Hey,guys! I have a drop down menu and checkbox,how could I passed the selected value to database by POST in INSERT statement?Thanks...



<select name="category" title="category">
<option...

Hey,guys!May I know how to have function of automatic logout if users have inactive more than 15 minutes ?Thanks....

if refer member_id like below,my insert statement can't work



$foreign1 = "SELECT member_id FROM member WHERE
email = \"" . $_SESSION['gmemberid'] . "\" ";

$sql =...

Hey..guys! I have INSERTstatement here which have two foreign keys that need to refer to other tables.How can I achieve it?



$sql = sprintf("INSERT INTO `reserve` (`reserve_datetime`,...

I am trying to use parse() to parse $input_date which is string to format of date,$date, according to $input_format that I defined

Hey..guys!I need to transfer a string to date format.The script having error said that call to a member function parse() on a non-object.Thanks for your help...



$reserve_date =...

Hey,guys!I have some images stored in blob data type,how can display it as actual image?Thanks..

Problem resolved.thanks

Well,what wrong again?The second line having T_CONSTANT_ENSCAPED_STRING expecting ' ' or ';'



echo $rows['banner'] .'<strong>Title:' . $rows['name'] .'<br>'
'Classification:' ....

Hey,guys!What went wrong with the script?I having syntax error of unexpected "." in first line of second echo.Thanks...



<?php
$tbl_name = "movie";

$result =...

Is it look like that?


`reserve_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`reserve_time` timestamp NOT NULL default '0000-00-00 00:00:00',


How can I...

Hey guys! How can I store the following format of date and time in database?
Date=Mon 01th Oct
Time=5 :00pm

Well,I changed my query again,



if (isset($_GET['confirm'])){
$selected_date = mysql_real_escape_string($_GET['selected_date']);
$reserve_time =...

I have changed my query



<?php
//$tbl_name = "reserve";
if (isset($_GET['confirm'])){
$sql = 'INSERT INTO `reserve` SET';
$sql .= ' `reserve_date` =...

I reliazed mt_rand() return an integer,so change ref_code to int,however data yet to be stored.What weent wrong actually???Hope someone can help me....



<?
//$tbl_name = "reserve";
if...

$tbl_name = "reserve"; just stated that table name is 'reserve'
Here is the sql code for reserve table:



CREATE TABLE `reserve` (
`reserve_id` int(4) NOT NULL auto_increment,
...

Hey,guys!

I have a form which have some hidden fields because those fields' value need to be displayed in next page by using $_GET.However,I also need to store them into database while form...