| Re: fetch items from a row [message #181291 is a reply to message #181287] |
Fri, 03 May 2013 21:00   |
Richard Yates
Messages: 86
Registered: September 2013
Karma:
|
Member |
|
|
On Fri, 3 May 2013 15:55:58 -0400, richard <noreply(at)example(dot)com>
wrote:
>
> How would I change the '42' value to a string value based upon the value
> retrieved from using $_GET('number')?
>
>
> <?php
> $result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
> if (!$result) {
> echo 'Could not run query: ' . mysql_error();
> exit;
> }
> $row = mysql_fetch_row($result);
>
> echo $row[0]; // 42
> echo $row[1]; // the email value
> ?>
Your question is a little confusing. It sounds like you are GETting an
integer and want to use it in the mysql query there the id is stored
as a string in the database.
$number = $_GET['number'];
$result = mysql_query("select id, email from people where id='$number'
";
But I also wonder why your id numbers in the database are stored as
strings and not as integer primary keys (which they seem to be).
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]