How to get a string from an sql query in php

Question

How to get a string returned from an sql query. MY code i have is:

    $to = mysqli_query($con,"SELECT email FROM register WHERE ID = '$i'");

This returns an object which im assuming needs to be converted (something I'm also not sure how to do (PHP noob!)). I need to know how to get a sting from the database in the first place. Also I only need one field of the row.

Come on. You can look that up in a million tutorials on the net. — juergen d, Jan 16 '14 at 18:05
When you show such a small amount of effort, not many people are going to help you... — takendarkk, Jan 16 '14 at 18:06
@juergend: It's posts like these that make me wish we still had the option to close posts because a minimal understanding of the problem and a reasonable amount of effort was not displayed. — Anil, Jan 16 '14 at 18:08
@Chris Being that he's a noob, there's no reason for him not to start using PDO. — crush, Jan 16 '14 at 18:08
@crush, I agree that learning PDO now is a good idea. But that question is not a duplicate of this one. — ChrisGPT was on strike, Jan 16 '14 at 18:09
@Chris The question was how to get a string from mysql in PHP, not How to get a string from mysql using the mysqli extension. ;) — crush, Jan 16 '14 at 18:10
@crush, Except, if you look at his code, he is already using the `mysqli_*` extension which is commendable considering how many people still post up code showing they are using the deprecated `mysql_*` functions. — Anil, Jan 16 '14 at 18:12

score 1 · Answer 1 · answered Jan 16 '14 at 18:28

1

look at this link, it contains all the information that you need, but you need to apply it yourself, we can help once you try. Everyone starts at some point. Best of luck! http://www.tutorialspoint.com/sql/sql-string-functions.htm

answered Jan 16 '14 at 18:28

user1063280

40
8

How to get a string from an sql query in php

1 Answers1