Declan
Rookie

phpmyadmin this is not a number problem?


I encountered a problem while I was learning how to create a table with phpMyAdmin. I am constantly facing this error and after searching the internet for a solution I got nothing useful. So guys if you have any experience dealing with this problem help me also then? Waiting a quick reply?
6 months ago
Respond to this discussion
Jeetendra Singh | Apr 10 2012

hello rookie i hope that this respond would be helpful 4 you....!

Jeetendra Singh | Jan 27 2012

In php we use the mysql database and mysql follow the SQL standards and if you are making any table inside a database then every column having a datatype like int for the integers and float for the floting numbers and varchars for the charater type

and BY default the datatype of every column is varchar even you are not changing the datatype from the the second column or field named "Type"

The Third feild named "Length/Values1" Accept the length of varchar like 250 for 250 characters or 20 for the 20 characters

NOTE: Some datatypes like int , smallint ,float , double automatic takes the length but varchar doesn't takes automatic length

You need to provide the VARCHAR length (the number of characters). The length is always numeric.

if you use the non-numeric or alphanumeric then you will also get an mysql Error

so please make sure the lenth of the varchar should only be numeric

So you have to specify the length like 100, or 50 characters or any length according to your need

after that press the button save you will not get any error after creating the table mysql

execute the sql query internally after executing the query phpMyadmin show the table structure and your table is ready and you can edit or modify that table

And you will not get this error :==> PHP MY ADMIN this is not a number problem???

© 2012, Instamedia. Some rights reserved. Powered by Instapress and Instacheckin.