search db by ID

ruler · #1 (**permalink**) 03-21-08, 10:10

i have searched before asking here for help and there is so much to look through but its like looking for a needle in a haystack

i have a simple db setup and using php i can connect, get data from it perfectly but

i dont know the best way to get the data from the db.

i am using $HTTP_GET_VARS['id'] to get the ID from the address bar and then trying to use the number so that it will list the whole row of the ID in the db. i think its just the main loop i am not sure about and what mysql commands to use. is there a fast and easy way to do this (if anyone understands what i mean).

the code i have to connect to my db is what i have below (and works) and i have also built the db into my forum so i can do more with it.

Code:

$query = "SELECT Id, Name, Address FROM phpbb_private_data";
$result = mysql_query($query)
or die("Query Failed: " . mysql_error());

if anyone has any tips or useful links i'd be much appreciated
thanks

r937 · #2 (**permalink**) 03-21-08, 10:34

a fast and easy way would be to add a WHERE clause to that query:

... WHERE Id = value

and of course value would be the sql-injection-safe value from your url

ruler · #3 (**permalink**) 03-21-08, 10:37

do you know of any demo's that might be useful for this as i am a total novice. i have no idea where to look but i am keen to learn. thanks for your reply

r937 · #4 (**permalink**) 03-21-08, 10:39

sqlzoo.net

ruler · #5 (**permalink**) 03-21-08, 10:40

thank you i will have a look

ruler · #6 (**permalink**) 03-21-08, 11:14

that site doesnt help at all sorry. on the SELECT
WHERE tab i click submit query leaving what was default settings on there and their site gives errors. murphys law

r937 · #7 (**permalink**) 03-21-08, 11:17

what's your favourite search engine? google? yahoo? msn?

do a search for sql tutorial

there are thousands and thousands of them

smartsoft · #8 (**permalink**) 03-22-08, 04:48

beta still you consult someone who is very good in MysQL

ruler · #9 (**permalink**) 03-22-08, 04:52

thats why i was asking on this forum, i was told that this forum was supposed to be pretty good for getting help

r937 · #10 (**permalink**) 03-22-08, 07:54

Quote:

Originally Posted by ruler

...this forum was supposed to be pretty good for getting help

it is!!!

you asked how to get the row for a specific ID, and i said you need a WHERE clause

you then asked for a demo and i gave you a link to a site where you can actually try out your SQL

what additional help would you like to have?

ruler · #11 (**permalink**) 03-22-08, 07:56

i got the help i asked for and problem solved

thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech