problem with a function
Posted by: tania (---.upnet.gr)
Date: February 25, 2006 11:19PM

i have this table in a database :
CREATE TABLE FILM(
F_ID INT(5) NOT NULL ,
F_TITLE VARCHAR(40) DEFAULT 'unknown' NOT NULL,
DIRECTOR_FNAME VARCHAR(20) DEFAULT 'unknown' NOT NULL,
DIRECTOR_LNAME VARCHAR(20) DEFAULT 'unknown' NOT NULL,
TYPE VARCHAR(30) DEFAULT 'unknown' NOT NULL,
DURATION TIME ,
YEAR_RELEASE YEAR NOT NULL,
DESCRIPTION TEXT,
DVD_COPIES SMALLINT(2),
VHS_COPIES SMALLINT(2),
RENT_TIME SMALLINT(2),
PRICE VARCHAR(4) NOT NULL CHECK(PRICE>0),
F_EMPLOYEE_CARD_ID CHAR(9),
DVD BOOLEAN,
VHS BOOLEAN,
PRIMARY KEY(F_TITLE),
UNIQUE(F_ID));

and i have done this form for registrating new films
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlnsyawning smiley="urn:schemas-microsoft-comyawning smileyfficeyawning smileyffice" xmlns="[www.w3.org];

<center>

<head>
<title>&#917;&#915;&#915;&#929;&#913;&#934;&#919; &#925;&#917;&#913;&#931; &#932;&#913;&#921;&#925;&#921;&#913;&#931;</title>
</head>

<body bgcolor="#6699FF">
<td align=center>
<h3> <td align=center> &#917;&#915;&#915;&#929;&#913;&#934;&#919; &#925;&#917;&#913;&#931; &#932;&#913;&#921;&#925;&#921;&#913;&#931; <tr></h3>

<form name=reg_film action="reg_film.php" method="POST">
<table border=0>
<tr>
<td align = left>
&#922;&#937;&#916;&#921;&#922;&#927;&#931;:
</td>
<td align=left>
<input type=text size=5 name=F_ID MAXLENGTH=5 AUTOCOMPLETE=ON>
</td>
</tr>
<tr>
<td align = left>
&#932;&#921;&#932;&#923;&#927;&#931;:
</td>
<td align=left>
<input type=text size=40 name=F_TITLE MAXLENGTH=40 AUTOCOMPLETE=ON>
<td align=left>
</tr>
<tr>
<td align = left>
&#927;&#925;&#927;&#924;&#913; <BR>&#931;&#922;&#919;&#925;&#927;&#920;&#917;&#932;&#919;:
</td>
<td align=left>
<input type=text size=20 name=DIRECTOR_FNAME MAXLENGTH=20 AUTOCOMPLETE=ON>
</td>
</tr>

<tr>
<td align = left>
&#917;&#928;&#937;&#925;&#933;&#924;&#927; <BR>&#931;&#922;&#919;&#925;&#927;&#920;&#917;&#932;&#919;:
</td>
<td align=left>
<input type=text size=20 name=DIRECTOR_LNAME MAXLENGTH=20 AUTOCOMPLETE=ON>
</td>
</tr>

<tr>
<td align = left>
&#922;&#913;&#932;&#919;&#915;&#927;&#929;&#921;&#913;:
</td>
<td align=left>
<input type=text size=30 name=TYPE MAXLENGTH=30 AUTOCOMPLETE=ON>
</td>
</tr>

<tr>
<td align = left>
&#916;&#921;&#913;&#929;&#922;&#917;&#921;&#913;:
</td>
<td align=left>

<select name=DURATION_HOUR size="1" >
<option selected value="hour">hour</option>
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">059</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
</select>
: <select name=DURATION_MIN size="1">
<option selected value="minutes">minutes</option>
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
</select>
: <select name=DURATION_SEC size="1">
<option selected value="seconds">seconds</option>
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
</select>
</td>

</tr>

<tr>
<td align = left>
&#917;&#932;&#927;&#931; <BR>&#928;&#913;&#929;&#913;&#915;&#937;&#915;&#919;&#931;:
</td>
<td align=left>

<select name=YEAR_RELEASE size="1" >
<option selected value="year">year</option>
<option value="1950">1950</option>
<option value="1951">1951</option>
<option value="1952">1952</option>
<option value="1953">1953</option>
<option value="1954">1954</option>
<option value="1955">1955</option>
<option value="1956">1956</option>
<option value="1957">1957</option>
<option value="1958">1958</option>
<option value="1959">1959</option>
<option value="1960">1960</option>
<option value="1961">1961</option>
<option value="1962">1962</option>
<option value="1963">1963</option>
<option value="1964">1964</option>
<option value="1965">1965</option>
<option value="1966">1966</option>
<option value="1967">1967</option>
<option value="1968">1968</option>
<option value="1969">1969</option>
<option value="1970">1970</option>
<option value="1971">1971</option>
<option value="1972">1972</option>
<option value="1973">1973</option>
<option value="1974">1974</option>
<option value="1975">1975</option>
<option value="1976">1976</option>
<option value="1977">1977</option>
<option value="1978">1978</option>
<option value="1979">1979</option>
<option value="1980">1980</option>
<option value="1981">1981</option>
<option value="1982">1982</option>
<option value="1983">1983</option>
<option value="1984">1984</option>
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
</select>
</td>
</tr>

<tr>
<td align = left>
&#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; <BR> DVD:
</td>
<td align=left>

<select name=DVD_COPIES size="1" >
<option selected value="dvd copies">dvd copies</option>
<option value=""></option>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
<INPUT type="CHECKBOX" name="DVD" value="DVD"> DVD**<BR>
</td>


</tr>

<tr>
<td align = left>
&#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; <BR> VHS:
</td>
<td align=left>

<select name=VHS_COPIES size="1" >
<option selected value="vhs copies">vhs copies</option>
<option value=""></option>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
<INPUT type="CHECKBOX" name="VHS" value="VHS"> VHS**<BR>
</td>


</tr>

<tr>
<td align = left>
&#935;&#929;&#927;&#925;&#927;&#931; <BR> &#917;&#925;&#927;&#921;&#922;&#921;&#913;&#931;&#919;&#931;:
</td>
<td align=left>

<select name=RENT_TIME size="1" >
<option selected value="rent_time">rent_time</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</td>

</tr>

<tr>
<td align = left>
&#922;&#927;&#931;&#932;&#927;&#931; <BR>&#917;&#925;&#927;&#921;&#922;&#921;&#913;&#931;&#919;&#931;:
</td>
<td align=left>

<select name=PRICE size="1" >
<option selected value="rent_time">rent_time</option>
<option value="0.1">0.1</option>
<option value="0.2">0.2</option>
<option value="0.3">0.3</option>
<option value="0.4">0.4</option>
<option value="0.5">0.5</option>
<option value="0.6">0.6</option>
<option value="0.7">0.7</option>
<option value="0.8">0.8</option>
<option value="0.9">0.9</option>
<option value="1.0">1.0</option>
<option value="1.1">1.1</option>
<option value="1.2">1.2</option>
<option value="1.3">1.3</option>
<option value="1.4">1.4</option>
<option value="1.5">1.5</option>
<option value="1.6">1.6</option>
<option value="1.7">1.7</option>
<option value="1.8">1.8</option>
<option value="1.9">1.9</option>
<option value="2.0">2.0</option>
</select>

&#931;&#917; &#917;&#933;&#929;&#937;

</td>

</tr>

<tr>
<td align = left>
&#913;&#929;.&#932;&#913;&#933;&#932;&#927;&#932;&#919;&#932;&#913;&#931; <BR>&#917;&#929;&#915;&#913;&#918;&#927;&#924;&#917;&#925;&#927;&#933;*:
</td>
<td align=left>
<input type=text size=9 name=F_EMPLOYEE_CARD_ID MAXLENGTH=10 AUTOCOMPLETE=ON>
</td>
</tr>

<tr>
<td align = left>
<BR>&#928;&#917;&#929;&#921;&#915;&#929;&#913;&#934;&#919;:

<p>
<textarea rows="5" cols=25 name=DESCRIPTION>
</textarea>
</td>
</p>
</tr>
<tr>
<td align=center colspan=2>
<br>
<input type="submit" name=submit_bt value="&#922;&#913;&#932;&#913;&#935;&#937;&#929;&#919;&#931;&#919;">
<input type="reset" name=reset_bt value="&#922;&#913;&#920;&#913;&#929;&#921;&#931;&#924;&#927;&#931;">
</td>
</tr>
</table>

<small >
<BR>*&#931;&#919;&#924;&#917;&#921;&#937;&#931;&#919;:&#916;&#917;&#925; &#917;&#921;&#925;&#913;&#921; &#913;&#928;&#913;&#929;&#913;&#921;&#932;&#919;&#932;&#919; &#919; &#931;&#933;&#924;&#928;&#923;&#919;&#929;&#937;&#931;&#919; &#932;&#927;&#933;
<BR>**&#931;&#919;&#924;&#917;&#921;&#937;&#931;&#919;:&#917;&#921;&#925;&#913;&#921; &#913;&#928;&#913;&#929;&#913;&#921;&#932;&#919;&#932;&#919; &#919; &#931;&#933;&#924;&#928;&#923;&#919;&#929;&#937;&#931;&#919; &#932;&#927;&#933; &#917;&#925;&#927;&#931; &#913;&#928;&#927; &#932;&#913; &#916;&#933;&#927; &#928;&#917;&#916;&#921;&#913;
</small>
</form>

</font>
</center>
</body>

</html>


reg_film.php

<html>
<head>
<title>&#922;&#913;&#932;&#913;&#935;&#937;&#929;&#919;&#931;&#919; &#917;&#929;&#915;&#913;&#918;&#927;&#924;&#917;&#925;&#927;&#933;</title>
</head>
<body bgcolor="#6699ff">
<div align=center>

<?php
$f_id=$_POST['F_ID'];
$f_title=$_POST['F_TITLE'];
$dir_fname=$_POST['DIRECTOR_FNAME'];
$dir_fname=$_POST['DIRECTOR_LNAME'];
$type=$_POST['TYPE'];
$year_rel=$_POST['YEAR_RELEASE'];
$dvd_cop=$_POST['DVD_COPIES'];
$vhs_cop=$_POST['VHS_COPIES'];
$descr=$_POST['DESCRIPTION'];
$rent_time=$_POST['RENT_TIME'];
$price=$_POST['PRICE'];
$f_em_card_id=$_POST['F_EMPLOYEE_CARD_ID'];
$dvd=$_POST['DVD'];
$vhs=$_POST['VHS'];

$dur_hour=$_POST['DURATION_HOUR'];
$dur_min=$_POST['DURATION_MIN'];
$dur_sec=$_POST['DURATION_SEC'];
$dur=$dur_hour.':'.$dur_min.':'.$dur_sec;

$conn=mysql_connect("localhost","root",""winking smiley;
mysql_select_db("video_club",$conn);

if (!empty($f_id) && !empty($f_title) && !empty($dir_fname) && !empty($dir_fname) && !empty($type) && !empty($year_rel) && !empty($descr) && !empty($rent_time) && !empty($price) && !empty($dur) || !empty($dvd_cop) || !empty($dvd_vhs) || !empty($dvd) || !empty($dvd) || !empty($f_em_card_id))
{

// Elegxoume ti vasi na doume an iparxei idi kataxorimenh tainia me afton ton kwdiko.
// An iparxei ton dioxnoume kai tou leme pos einai idi kataxorimenh
// Allios ginete nea eggrafi

$query = "SELECT * FROM film WHERE F_ID = '$f_id'";

$rs = mysql_query($query,$conn);
$rows = mysql_num_rows($rs);

if ($rows > 0)
{

ECHO '&#933;&#928;&#913;&#929;&#935;&#917;&#921; &#919;&#916;&#919; &#917;&#915;&#915;&#917;&#915;&#929;&#913;&#924;&#917;&#925;&#919; &#932;&#913;&#921;&#925;&#921;&#913; &#924;&#917; &#913;&#933;&#932;&#927;&#925; &#932;&#927;&#925; &#922;&#937;&#916;&#921;&#922;&#927;!';
ECHO "<BR>&#916;&#919;&#923;&#937;&#931;&#932;&#917; &#916;&#921;&#913;&#934;&#927;&#929;&#917;&#932;&#921;&#922;&#927; &#922;&#937;&#916;&#921;&#922;&#927;!";
mysql_close($conn);
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
ECHO "<br><a href='start_page.htm'>&#913;&#929;&#935;&#921;&#922;&#919; &#931;&#917;&#923;&#921;&#916;&#913;</a>";
exit;

}


// Elegoume an iparxei idi kataxorimenh tainia me afton ton titlo
// velpe parapano

$query = "SELECT * FROM film WHERE F_TITLE = '$f_title'";
$res = mysql_query($query,$conn);
$num_rows = mysql_num_rows($res);

if ($num_rows > 0)
{

ECHO "&#933;&#928;&#913;&#929;&#935;&#917;&#921; &#919;&#916;&#919; &#917;&#915;&#915;&#917;&#915;&#929;&#913;&#924;&#917;&#925;&#919; &#932;&#913;&#921;&#925;&#921;&#913; &#924;&#917; &#913;&#933;&#932;&#927;&#925; &#932;&#927;&#925; &#932;&#921;&#932;&#923;&#927;!";
ECHO "<BR>&#916;&#919;&#923;&#937;&#931;&#932;&#917; &#916;&#921;&#913;&#934;&#927;&#929;&#917;&#932;&#921;&#922;&#927; &#932;&#921;&#932;&#923;&#927;!";

mysql_close($conn);
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
ECHO "<br><a href='start_page.htm'>&#913;&#929;&#935;&#921;&#922;&#919; &#931;&#917;&#923;&#921;&#916;&#913;</a>";
exit;

}
if ($num_rows < 1 && $rows < 1)
{
if(getParameterValues('DVD') != null && getParameterValues('VHS') != null)
{
if($dvd_cop!= null && $vhs_cop!= null)
{
if($f_em_card_id != null)
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel','$dvd_cop','true','$vhs_cop','true','$rent_time','$price','$f_em_card_id','$descr')";
}
else
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel','$dvd_cop','true','$vhs_cop','true','$rent_time','$price',null,'$descr')";
}
}
else
{
ECHO "&#928;&#913;&#929;&#913;&#922;&#913;&#923;&#937; &#917;&#928;&#921;&#923;&#917;&#926;&#932;&#917; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; DVD &#922;&#913;&#921; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; VHS!";
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
}
}
else if(req.getParameterValues("VHS"winking smiley != null && req.getParameterValues("DVD"winking smiley == null)
{
if($vhs_cop!= null && $dvd_cop== null)
{
if($f_em_card_id != null)
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel',null,'false','$vhs_cop','true','$rent_time','$price','$f_em_card_id','$descr')";
}
else
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel',null,'false','$vhs_cop','true','$rent_time','$price',null,'$descr')";
}
}
else
{
ECHO "&#928;&#913;&#929;&#913;&#922;&#913;&#923;&#937; &#917;&#928;&#921;&#923;&#917;&#926;&#932;&#917; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; DVD &#922;&#913;&#921; &#931;&#932;&#927; VHS KA&#925;&#917;&#932;&#917; DECHECKING!";
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
}
}
else if(req.getParameterValues("VHS"winking smiley == null && req.getParameterValues("DVD"winking smiley != null)
{
if($vhs_cop== null && $dvd_cop!= null)
{
if($f_em_card_id != null)
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel','$dvd_cop','true',null,'false','$rent_time','$price','$f_em_card_id','$descr')";
}
else
{
$query = "INSERT INTO film(F_ID,F_TITLE,DIRECTOR_FNAME,DIRECTOR_LNAME,TYPE,DURATION,YEAR_RELEASE,DVD_COPIES,DVD,VHS_COPIES,VHS,RENT_TIME,PRICE,F_EMPLOYEE_CARD_ID,DESCRIPTION) VALUES ('$f_id','$f_title','$dir_fname', '$dir_fname','$type', '$dur' ,'$year_rel','$dvd_cop','true',null,'false','$rent_time','$price',null,'$descr')";
}
}
else
{
ECHO "&#928;&#913;&#929;&#913;&#922;&#913;&#923;&#937; &#917;&#928;&#921;&#923;&#917;&#926;&#932;&#917; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; VHS &#922;&#913;&#921; &#931;&#932;&#927; DVD KA&#925;&#917;&#932;&#917; DECHECKING!";
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
}
}
else
{
ECHO "&#928;&#913;&#929;&#913;&#922;&#913;&#923;&#937; &#917;&#928;&#921;&#923;&#917;&#926;&#932;&#917; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; VHS &#905; &#913;&#925;&#932;&#921;&#915;&#929;&#913;&#934;&#913; DVD &#905; &#922;&#913;&#921; &#932;&#913; &#916;&#933;&#927; &#922;&#913;&#921; &#922;&#913;&#925;&#932;&#917; &#932;&#913; &#913;&#925;&#932;&#921;&#931;&#932;&#927;&#921;&#935;&#913; CHECKING!";
ECHO "<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>";
}
}
}
else
{
ECHO "&#916;&#917;&#925; &#917;&#935;&#917;&#932;&#917; &#931;&#933;&#924;&#928;&#923;&#919;&#929;&#937;&#931;&#917;&#921; &#927;&#923;&#913; &#932;&#913; &#913;&#928;&#913;&#929;&#913;&#921;&#932;&#919;&#932;&#913; &#928;&#917;&#916;&#921;&#913;!";
}


?>

<br><a href='form_reg_film.htm'>&#917;&#928;&#921;&#931;&#932;&#929;&#927;&#934;&#919;</a>
<br><a href='start_page.htm'>&#913;&#929;&#935;&#921;&#922;&#919; &#931;&#917;&#923;&#921;&#916;&#913;</a>
</div>
</body>
</html>

but no registration .....

Options: ReplyQuote
Re: problem with a function
Posted by: RealNubSlayer (---.hsd1.ma.comcast.net)
Date: February 26, 2006 12:09AM

I'm sorry, i really don't feel like reading this whole script, its really long, but i have some suggestions..
Run the queries, all the insert things are just defined variables, you must run them.. mysql_query($query)

Options: ReplyQuote
Re: problem with a function
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: February 26, 2006 10:24AM

use mysql_query($query, $conn)

Options: ReplyQuote


Sorry, only registered users may post in this forum.