64Digits

PHP help

Posted by KaBob799 on June 1, 2006, 7:59 p.m.

I need to do a query that searches a certain field for a value, and the value it is searching for would be in the url (the index.php?value=blah type thing)

and when it finds one it displays a single value from that row (not the same value it was searching for)

but no matter what I try cant get it to display it.

So if anyone here knows how I would appreciate being shown.

oh and I made a new screensaver called spotlight, you can download it from my site

http://www.tz-c.com/Downloads

Comments

KaBob799 17 years, 11 months ago

i need the whole code, not just the getting variable part.

and im using PHP version 4.3.11

flashback 17 years, 11 months ago

Yeesh, lazy. Easiest thing to do in the world (aside from eating pie).

[<]?php
$searchvar=$_GET['value'];
$query = mysql_query("SELECT * FROM table WHERE column=$searchvar ORDER BY id DESC LIMIT 1");
while($row = mysql_fetch_array($query))
{
print $row['columnyouwantthedataof'];
}
?[>]

takua108 17 years, 11 months ago

Eating pie can be difficult under certain circumstances…