Feelay
Jun 10 2008, 11:46 AM
Hi again. I am trying to make a new Register script. But now, there is only one thing that is not working.. I can't make the following query work. CODE mysql_query("INSERT INTO members(username, password, email, register_date) VALUES ('$user','$pass','$email', '$reg_date')") or die("Failed to register.<br> Error:".mysql_error()); this is the current date variable, that is causing the error. (if I remove it from the query, it works just fine) CODE $reg_date=date("Y/m/d"); this is the error I am getting: QUOTE Error:Data truncated for column 'register_date' at row 1 in the database I gave it the data type int, because the date is only made out of numbers. Thanks for your help //Feelay
Reply
TavoxPeru
Jun 13 2008, 10:13 AM
Your query don't work because your variable stores a string like "2008/06/13", the "/" character cause this error to happen. To fix it simply change your variable's date format to: CODE <?php
$reg_date=date("Ymd");
?> But this can lead to get problems with the register_date field, i'm not sure about this. A better solution is to change the data type of the register_date field to date and change the sql query to: CODE <?php
mysql_query("INSERT INTO members(username, password, email, register_date) VALUES ('$user','$pass','$email', NOW())") or die("Failed to register.<br> Error:".mysql_error());
?> Best regards,
Reply
Feelay
Jun 13 2008, 11:32 AM
Thanks ^.^ lol  I forgot that "/" was in the variable Anyways.. it is working now =) Thank you //Feelay
Reply
Similar Topics
Keywords : make, query, working,
- How To Make The Theme In Php?
Apply Theme on to the profile. (4)
Sleep Function Not Working
(4) CODE /* sleep example */ #include #include int main(void) { int i; for (i=1; i {
printf("Sleeping for %d seconds\n", i); sleep(i); } return 0; } I have turbo
C++, i found this in its help file shouldn't it work?, when i run it i get: CODE Compiling
NONAME00.CPP: Error NONAME00.CPP 8: Call to undefined function 'sleep' in function main()
I tried library , doesn't work. In which library is sleep() function?....
How To Make A Window Form Smooth Snap To Desktop Edge ?
(3) Hi, All, Now I got another issues that I wanted to implment a window that will snap to desktop
edge. What I'am do now was creating it with timer and some windows api to check positions say if
within a range then move the form window to any edge. But this has an issue with it the window will
flicker. Any ideas with this issue ? Thanks, --- Magiccode9 ....
Login System
I want to make a login system using Mysql. I am amateur in these thing (6) I want to make a login system using Mysql. I am amateur in these things so please explain in detail
like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of
table I should make and and the website or PHP for it . If you think i hav chosen wrong site please
give any better database hosting site. Please help me Best Regards Pritesh Gupta....
How To Make Sure Your Server Can Generate Images
How to use createthumb() (0) How to make sure your server can generate images This small article will explain how you create a
thumbnail from an image in PHP. Furthermore you learn how to batch process a whole folder of images
and create their thumbnails. To create images with PHP you need to have the gd image library
installed and activated in your PHP. To make sure if gd is installed on your machine, simply check
your php info. Create a file that contains: and save it as "test.php" on your server. When you
open it in a browser you see a colourful table showing all the schematics of your PHP inst....
How To Make Credits
(10) please if any person can help me with the free credits, my english is regular....
Normal Maps In Blender
Technique to make low resolutuion models have high resolution detail (6) Disclaimer: This is not a beginner "introduction to blender" level tutorial. It addresses the
area of Normal Mapping, which is an advanced displacement texturing technique. If you know what
Normal Maps are, and are wanting to know how to make them in Blender, then this tutorial is for you.
UV unwrapping, basic Blender navigation, Sculpt mode etc are more basic skills which are assumed
knowlege for this level. Normal maps are cool. They are blueish textures which work like (but are
more accurate than) bumpmaps... apply them to a model and they add bumpy textures & d....
How To Make Both Windows Look Like Active At Same Time
(9) Hi, I'am creating some UI that will have some floating windows like the code below. But by
default, when one window was active, the other will lost focus and became gray in color. How can I
made both look like active. Much like some graphics apps such as photoshop tool window. Thanks,
CODE /** * * **/ using System; using System.Windows.Forms; using System.Drawing; public
class Program { public static void Main(string args) { form1 AppMain = new form1();
Application.Run(AppMain); } } public class form1 : System.Windows.F....
Make Firefox Look Like Google Chrome
(2) I had posted a topic on trap awhile back for the chrome lovers on how to make firefox look like
chrome but with the added security and privacy and what not. So I thought I would share to everyone
on astahost on how that is done and that way for those who enjoy chrome and firefox will have the
best of both worlds with the following extensions Stealther Download Statusbar
Locationbar² 1.0.3 Speed Dial Prism Resizeable Textarea Peer's ChromiGlass
New Tab Button on Tab Right Personal Menu Show Go Dom Inspector Chromifox....
What Are The Ways To Make Your Poems Spread To The Audience?
(3) Hi and my regards to everyone, poem is a way to express yourself and the surroundings that influence
you in many ways. There have been poets that have touched either of us and on which I believe that
we get inspired to write poetry. One of my favorites is Sir William Wordsworth of whose Daffodils
was a great work. I have too some of written poems which I believe will be a pleasure to hear. What
are the different ways that one can use to spread their works to the audience?....
How To Make Simple Animations In The Gimp
in the form of an Animated GIF. (2) This is a very simple technique which even young school children can manage... use the method in
class if you like (but show them for real rather than making them read something; they will pick it
up a lot faster). I am using Gimp 2.4 for this tutorial. When saving layered images in GIF format,
the Gimp knows how to prepare them in a special way which will work automatically on websites. I
recommend you are moderately familiar with the Gimp and at have at least a basic understanding of
layers to follow this tutorial. Part 1: Get Ready 1. Start a new image in Gim....
Center Update
Make the center of the page change only (5) This is going to be a little hard to explain so just let me know whats confusing you. Ok I'm
making an online game and i will have a banner on top and have all the page links on the left and
have other options on the right and when ever you click one of these links i want it to open in the
center of the page and want the rest of the page to look the same. In other words i want the page
layout the same and what ever page you go to open in the center which will also be in a box/table.
How could i do this. I know it's possible because I've seen it on many other ....
Make Money Online With Cashcrate - A Scam?
(8) Nope, it's not a scam. I was surprised too, as most of these sites turn out to be scams.
CashCrate , however, actually pays, and at an extremely fast rate as well. Basically, at the site,
you complete listed offers and then the site will credit you with dollars. If you're wondering
about the speed of the crediting, the site does it as soon as the company listing the offer tells
them you've completed an offer. You'll also get an email letting you know you've
finished and that they've confirmed the offer. You can cash out once you've reached $....
Anyone Willing To Make A Text-based Game With Me?
for all interested view the idea first (5) Here we are. A few days ago while playing slavehack (my fav text-based game, which is currently
laggy and ddosed), i got an idea for a game based on similar principles. In this game, you are an
instrument player eg. a Bass player, a guitar player, a drummer, a singer etc. you can earn and
improve your skills by practicing. You have to choose your playing style(metal, rock, death metal,
trash metal, jazz etc. you can buy guitars, amps, pedals, processors etc. when you get good enough
you can form a band with other players. you can than make your gigs, where you earn cash,....
How To Make A Private Message System.
(13) Hey! Today, I am going to teach you how to make a Private Message (PM) script in PHP. Before we
start, I want to tell you what you should know, and what files we will create. Then we will continue
with the codes, and descriptions. I would like if you learned something from this tutorial. If you
find any errors (Even if I spell something wrong), I would like you to post it in this thread.
What you should know: You should know HTML. Just a bit (forms, and maybe a little design if you
would like that). You should know much about PHP and Mysql. You should know how to c....
How To Make A PM (Personal Message) System?
(Should I Store The Data In A Database?) (5) Hey! I just wanted to know, if I want to make a PM system, should I store the PMs in a database or
how should I do it? And if I should store them in a database, how do I do that. Because I have
acctually no idea, if I should create 50 tables to store 50 messages /tongue.gif"
style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" /> (And a little OT question
). How can i change the timestamp into real date?....
Make A Wish And It'll Come True...if....
Common email chain letters (7) Do you ever come across email chain letters that say something like: QUOTE Now make a wish and
scroll down ((scrolls down about 15 seconds)) STOP!!! Send this to ## people and your wish will come
true in ## minutes/hours/days. Or things like this: QUOTE 13 ways to tell if someone loves you
... (a list) ... Send this to 20 of your friends and you will get a date within the next day!
Well I am on the hunt for an EXTREMELY important chain letter that is of the 2nd variety. It was
quite lengthy, and consisted of maybe 50-120 lines on tips to get a boy/girlfrien....
How To Make Realistic Fire!
real fire in photoshop (19) Hello and welcome to my tutorial, I’m going to teach you how to make realistic fire!!!! this is how
I figured it out, I was makeing smoke in photoshop one day, but i wanted color to be added to it,
so I added some color balance to it and ""click"" it hit me.... it looked alot like fire. --I would
rate this tutorial easy and on a scale from 1 to 10 of difficulty, I would say a 3 --this is how
I did it. 1. first I started with a blank page.. duh it doesn't mater what the size is but I
used 400 X 400 pixels 2. Ok, we got our blank document now were going to sel....
Real Driving
Does driving for real make you better at racing games? (25) Does driving for real make you better at racing games? And if so does it help to drive faster in
real life? What do you think? I think it helps, especially with simulation racers! It helps you
understand certain concepts better! Like two wheel drive vs four wheel drive. And camber on the
road, things like that! Im not saying drivers are better than non drivers but i think it gives them
an edge!....
Lock Workstation Shortcut
How to make a shortcut to lock your windows computer (9) 1) Right click on desktop and select add new shortcut 2) In the 'Type Location of the item:'
box type or copy %windir%\System32\rundll32.exe user32.dll,LockWorkStation then click 'next'
3) In the 'Type a name for this shortcut:' box type or copy "Lock Workstation" and click
'Finish' 4) Now if you would like go to properties and Change Icon browse to:
%SystemRoot%\explorer.exe and I use the red circle with the white x ....
How Can I Make Xp User Autologin ?
I know how to make the Administrator user automatically log in in Wind (6) I would like my system to automatically log the user Administrator at power-up or at system reboot.
And I don't want to remove the Administrator user password. I knew how to do this with Windows
2000 : in the command prompt, type "control userpasswords" and you see the user admin pannel coming
up, you uncheck "user must provide a password", the system asks you the default user passwords and
then you don't need to give the password again at each boot. How do you perform this under
Windows XP ? I would not like to directly edit the registry settings, I would like t....
VB6-MS Access Question
help please (9) hi guys, I am developing an application in Visual Basic 6.0 and using MS Access as my backend. What
i want is that my database should not open when someone doublec clicks on the .mdb file. But my
application should be able to access it. What can be a possible solution to this problem? Please
help. Thanx in advance.....
Photoshop Tutorial: How To Make A Userbar For Signatures
(35) How to make a userbar by pyost Lately the userbars have become very popular with people. They
are mostly putting them in their forum signatures, which is very practical. They are small, but can
be used for linking. A lot of userbars can be found at www.userbars.com and www.userbars.org ,
but sometimes people can't find exactly what they want. This is why I have decided to make a
tutorial on how to make you own userbar. The pictures in this tutorial are made in Photoshop 6.0,
so don't be surprised if you're Photoshop is different. I will be making a....
Can Someone Make Me A Cs Clan Sig Please?
(6) Hello, Im looking for a counter-strike source theme going on. And if it could say Team|ExT Em
<760 on it that would be great. I hope someone could be kind too make me one. Thank you....
How To Make A Good Sig Image!
(6) Hello all. I am going to tell you how to make a good sig in Photoshop. Okay lets get started:
Well first you need to start up photoshop /tongue.gif' border='0' style='vertical-align:middle'
alt='tongue.gif' /> . Then go to FILE->NEW And enter: 360 by 140 or what ever size you wish to
use. Click D to set ever thing to defualt. Then click on FILTER-> RENDER-> CLOUDS Take out your
fav brush, i suggest a grunge brush. Start by laying a layer in black. Create a new layer and lay
down some white brushes. Repeat till your happy. Merge all Layers. Click CTRL L an....
How To Make Your Windows Look Like A Mac
Windows Xp only (24) Ok Fans of macs I have done my reserch and checked it twice and I now present my tutorial on how to
make your windows XP desktop look like a Mac operating system. For those who think its really hard
your wrong and without any more jiber jaber lets get started. Step 1: The Downloads Ok for this
to work your going to need some items to make it work. The first one is the skin to make your
windows look like a mac. Its called Panther you can download it here . Second your gonna need a doc
for your programs. The best free one out there is Yz's dock and you can download....
Java Applets
how to make an applet in Java (5) The purpose of this tutorial is to explain how to create a Java applet. A Java applet is simply a
Java program that runs on a webpage. This tutorial assumes that you have a basic understanding of
Java. If you don't, I would suggest reading a tutorial on Java first. In this tutorial I
will be using Java 1.5 (or 5.0). If you don't have it you can download it from Sun . The
classes and methods used in this tutorial may work for other versions of Java, but I don't know
for sure. During this tutorial I would suggest opening up Java's online documen....
Online Multiplayer Game
What language to learn in order make it? (16) If you look at e.g. THIS LINK What language would you use to make something like that?
/wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' /> ....
How Do I Make A RPG Battle System?
final fantasy style (14) I use flash mx, but I was wondering how to/what language I would need to make a final fantasy-like
turn based battle system for a rpg I'm making. "So, any help you could give us would be...
Helpful?" MP&THG....
How To Make A Text Based Online Game Script ?
(24) Does anyone know if there is a easy was to make a text base online game, Like a free templet, or if
anyone know how to make one and can help me.....
Looking for make, query, working,
|
*SIMILAR VIDEOS*
Searching Video's for make, query, working,
|
advertisement
|
|
