akum & hai

camne caranya nak hilang kan ruang kosong setiap kali input dimasukkan....

$mail = $_POST["email"];
$nama = $_POST["name"];

mysql_query ("INSERT INTO visitors (vis_name, vis_mail) VALUES ('$nama', '$mail')");

print "Welcome, $nama";

kalo saya buat cam kat atas nih. dia akan ada ruang kosong setiap kali input dimasukkan(data yg masuk 3 tapi row dlm db akan ada 6). tolong....

TQ...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

erk... kalau kosong pon, tadak masalah pa....

__________________
<form name="jump">
<select name="menu" onChange="location=document.jump.menu.options[document.jump.menu.selectedIndex].value;" style="border:1px #393F31 solid;color:#393F31;font:10px Verdana;font-weight:bold;" >
<option value="0" style="background: #9CC8FE" selected>*SELECT-LINKS</option>
<option value="http://www.gengturbo.org/" style="background: #FF0000">GENGTURBO</option>
<option value="http://www.phixelgrafix.com/" target="new" style="background: #C6D607">PHIXELGRAFIX</option>
<option value="http://dailydigital.phixelgrafix.com/" style="background: #FCBC45">OLD-BLOG</option>
<option value="http://www.mesrahosting.net/" style="background: #FF99CC">WEBHOSTING</option>
</select>
</form>

takde masalah tu memang la takde... tapi table tu jadi besar.... padahal kosong je semua.... tak ke membazir ruang tu....

takde cara ke?

TQ...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

if you dun mind, pls display the whole page code.
the few lines do not seems to be the source of problem.

__________________
LiewCF | Malaysia Bloggers Forum

lor.... tak membazir la.... kalau ada data baru kira space.,,.. yang kosong tu, cuma display ja... ....

__________________
<form name="jump">
<select name="menu" onChange="location=document.jump.menu.options[document.jump.menu.selectedIndex].value;" style="border:1px #393F31 solid;color:#393F31;font:10px Verdana;font-weight:bold;" >
<option value="0" style="background: #9CC8FE" selected>*SELECT-LINKS</option>
<option value="http://www.gengturbo.org/" style="background: #FF0000">GENGTURBO</option>
<option value="http://www.phixelgrafix.com/" target="new" style="background: #C6D607">PHIXELGRAFIX</option>
<option value="http://dailydigital.phixelgrafix.com/" style="background: #FCBC45">OLD-BLOG</option>
<option value="http://www.mesrahosting.net/" style="background: #FF99CC">WEBHOSTING</option>
</select>
</form>

ye ke? tapi tak best la... bila bukak mysqlcc... panjang jer table dia.... padahal takde pape pun.... so setiap kali ader org masuk input aku kena check balik dan buang sume ruang kosong yg tak pakai tu....

for lcf:

saya byk buat sub coding.... dan dicantumkan jadi satu pada main. tapi saya rasa bahagian lain tak ada masalah. basicly the coding just ask people to input their name and email and store it in database name employee.


<?php

//connect to server
$con = mysql_connect($server, $user, $pass)or die("Sambungan ke server gagal! ".mysql_error());

$db="employee";
mysql_select_db($db, $con);

$mail = $_POST["email"];
$nama = $_POST["name"];

mysql_query ("INSERT INTO visitors (vis_name, vis_mail) VALUES ('$nama', '$mail')");

print "Welcome, $nama";

?>

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

jap... aku tak dapat tangkap la....

dalam satu table, ada berapa row?
dalam satu row, berapa je yang ko pakai?

__________________
<form name="jump">
<select name="menu" onChange="location=document.jump.menu.options[document.jump.menu.selectedIndex].value;" style="border:1px #393F31 solid;color:#393F31;font:10px Verdana;font-weight:bold;" >
<option value="0" style="background: #9CC8FE" selected>*SELECT-LINKS</option>
<option value="http://www.gengturbo.org/" style="background: #FF0000">GENGTURBO</option>
<option value="http://www.phixelgrafix.com/" target="new" style="background: #C6D607">PHIXELGRAFIX</option>
<option value="http://dailydigital.phixelgrafix.com/" style="background: #FCBC45">OLD-BLOG</option>
<option value="http://www.mesrahosting.net/" style="background: #FF99CC">WEBHOSTING</option>
</select>
</form>

ok ok... aku ade satu database nama employee... dlm tu ada table visitor & personal. yg aku nak masukkan nih dlm table visitor. table visitor tu ada 2 medan je ( nama & email). setiap kali visitor(org luar yg bukan pekerja) nak lawat laman tu dia kena masukkan nama dan email baru bleh masuk. so email dan nama tu nanti akan dimasukka dlm table visitor tu la... faham? aku taktau nak xpalin camne lagi nih...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

owh.... skang ni.... masalahnya, kalau user cuma inputkan nama, jadi email tu kosong la?


contoh :

camtu ka?

__________________
<form name="jump">
<select name="menu" onChange="location=document.jump.menu.options[document.jump.menu.selectedIndex].value;" style="border:1px #393F31 solid;color:#393F31;font:10px Verdana;font-weight:bold;" >
<option value="0" style="background: #9CC8FE" selected>*SELECT-LINKS</option>
<option value="http://www.gengturbo.org/" style="background: #FF0000">GENGTURBO</option>
<option value="http://www.phixelgrafix.com/" target="new" style="background: #C6D607">PHIXELGRAFIX</option>
<option value="http://dailydigital.phixelgrafix.com/" style="background: #FCBC45">OLD-BLOG</option>
<option value="http://www.mesrahosting.net/" style="background: #FF99CC">WEBHOSTING</option>
</select>
</form>

<?
$nama = HTTP_POST_VARS['nama'];
$email = HTTP_POST_VARS['email'];

if($nama == "" || $email == "")
{
print "sila isi semua kotak!";
}
?>

yup lebih kurang la tu... kalo kotak tu kosong, dia akan pegi balik ke form login. nama akan dimasukkan dlm medan nama, dan email akan dimasukkan dlm medan email.... dua2 mesti ada nilai (NOTNULL). baru bleh masuk. camne ade cara ke??

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

aku rasa ko kena buat code yang check db, kalau ada kosong, delete je row tu...

__________________
<form name="jump">
<select name="menu" onChange="location=document.jump.menu.options[document.jump.menu.selectedIndex].value;" style="border:1px #393F31 solid;color:#393F31;font:10px Verdana;font-weight:bold;" >
<option value="0" style="background: #9CC8FE" selected>*SELECT-LINKS</option>
<option value="http://www.gengturbo.org/" style="background: #FF0000">GENGTURBO</option>
<option value="http://www.phixelgrafix.com/" target="new" style="background: #C6D607">PHIXELGRAFIX</option>
<option value="http://dailydigital.phixelgrafix.com/" style="background: #FCBC45">OLD-BLOG</option>
<option value="http://www.mesrahosting.net/" style="background: #FF99CC">WEBHOSTING</option>
</select>
</form>

ye ke... ade tak kod yg mana kalo kita masukkan data dia akan susun row, row yg empty tu yg dia akan masukkan. cam loop ke?? kalo kita masukkan data dia akan periksa setiap row dan pegi ke row terakhir pastu dia masukkan kat situ...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

aler pakai punksian SELECT yg guner LIKE tuh ehehheek... takkan tau tau kot? hihihi

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds