How to get the integer from sql database?

Question

I have a database with 2 columns, one of type int and other of type varchar.

When i try to get tha name with id=1 for example, the query works fine:

$name = mysql_query("SELECT Name FROM stations_id WHERE id=1");
$a = mysql_fetch_array($name);
echo $a['Name'];

I try to do the opposite but i cant get the integer value. For example:

$id = mysql_query("SELECT id FROM stations_id WHERE Name='Mike'");
$a = mysql_fetch_array($id);
echo $a['id'];

I want to get the type as an integer so i can use it in a function. Can somebody help me plz?

Can you explain what goes wrong, because at first sight the query looks ok — fvu
– fvu, Commented Mar 17, 2013 at 14:42
PHP doesn't really care if it's in a string, if you use it as an integer (+ or / operators and such) it will work. Why do you care about it? (also why wont just cast it with (int)?) — complex857
– complex857, Commented Mar 17, 2013 at 14:42
The problem is when i do echo $a['id']; as in last command i dont get any output :S I dont know why. — MikeMakos
– MikeMakos, Commented Mar 17, 2013 at 14:44
If you don't get any output from echo $a['id'], then no record exists with a Name of 'Mike'. On a development server, you should also increase your error_reporting and turn on display_errors. That would have warned you about an "Undefined index 'id' ...". — Oswald
– Oswald, Commented Mar 17, 2013 at 14:48

Amir · Accepted Answer · 2013-03-17 14:57:17Z

1

Perhaps you do not have 'Mike' as name in your table

try:

$id = mysql_query("SELECT id FROM stations_id WHERE Name like '%Mike%'");

answered Mar 17, 2013 at 14:57

Amir

4,1314 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oswald · Accepted Answer · 2013-03-17 15:02:36Z

1

If you absolutely need an integer, you have to cast $a['id'] to integer yourself. This is, however, rarely necessary. If you use $a['id'] in an integer context (e.g. in arithmetic operation) it will be cast to integer automatically.

edited Mar 17, 2013 at 15:02

answered Mar 17, 2013 at 14:44

Oswald

31.8k3 gold badges45 silver badges72 bronze badges

1 Comment

Oswald Over a year ago

The problem is not one of type. It's that no record exists with a Name of 'Mike'. See the comment I added to your question.

Collectives™ on Stack Overflow

How to get the integer from sql database?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related