FUDforum: comp.lang.php » take two - fetch items from a row.

Home » Imported messages » comp.lang.php » take two - fetch items from a row.

Show: Today's Messages :: Polls :: Message Navigator

Re: take two - fetch items from a row. [message #181297 is a reply to message #181295]

Fri, 03 May 2013 23:32

Richard Yates
Messages: 86
Registered: September 2013

Karma:

Member

On Fri, 3 May 2013 19:02:58 -0400, richard <noreply(at)example(dot)com>
wrote:

> This code may reside on a page in a line.
> < a href="http:www.code.com/gettable.php?number=1">
>
>
> Where I show id=$number, is that the way I want to show it or is there a
> beter way?
> I want to retrieve the row corresponding to the id number given in the
> link.
>
> <?php
>
>
> $number=$_GET["number"];
> if (empty($number)) {$number=1;}
> $number=(int)$number;
>
> // connections code left out intentionally //
>
>
> $result = mysql_query("SELECT id,email FROM people WHERE id = $number");
> 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 code does work. There are details about it that could be improved
and others made suggestions about in response to your first post. I
notice that in this post your id field in the database is assumed to
be a number where the last time it seemed to be a string. Do yuou know
which it is?

Have you learned about validating and sanitizing user input yet?

Report message to a moderator

[Message index]

		take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:02
		Re: take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:13
		Re: take two - fetch items from a row. By: Denis McMahon on Sat, 04 May 2013 00:59
		Re: take two - fetch items from a row. By: Richard Yates on Fri, 03 May 2013 23:32
		Re: take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:54
		Re: take two - fetch items from a row. By: Richard Yates on Sat, 04 May 2013 02:20
		Re: take two - fetch items from a row. By: Beauregard T. Shagnas on Sat, 04 May 2013 03:37
		Re: take two - fetch items from a row. By: SwissCheese on Sat, 04 May 2013 11:00

Previous Topic:	SoapServer constructor parameters: what is actor uri?
Next Topic:	replacing spaces with newline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 21:25:56 GMT 2024

Total time taken to generate the page: 0.03653 seconds