pullin data with only the id num

elementaluk

i downloaded a script and i wanna add a page to it.

so here's what the page will do >>

get id number sent >> look in the mysql db for that id >> pull all info on that row >> put that info in a array and display it on the page.

so yea to all you pro's and well just people that know more than me this may be easy to u but i dont know that much bout php so here what i've got so far (all from the php manual thingy) >>

mysql_connect($host, $user, $password);
mysql_select_db("$database");

$result = mysql_query("SELECT Inktitle, Inkdescription, Inkrating, Inkvotes, Inklocation, Inkurl, Inkdate, FROM searchidx WHERE id=$id");
while ($row = mysql_fetch_array ($result)){
echo "Inkdescription:" .row["Inkdescription"]."<br>\n";
echo "Inkdescription:" .$[0]."<br>\n";
}
mysql_free_result($result);

<<
so uhh WTF does mysql_free_result do?
is this right?
does it put all content in $row array?
is the WHERE right?
$id is sent from a link e.g. script.php?id=2

can someone make this a little english for me please

Thanks in advance
Vince

P.S. yea i know...I DONT KNOW SH*T 😛

Anon

When you do a SQL query, the results are stored in memory, sometimes, with large results, this can use up a lot of memory on the server.

mysql_free_result() clears the memory that is used up when you do a query.

mysql_fetch_array() reads the result set into an array, in this case your array name is $row.

The WHERE clause specifies that you only want rows that have a field called id with a value that matches the value of $id that you passed in your URL.

elementaluk

Thanks...just got a few more questions 😛

umm...so the code works and i can just pull the results using e.g. $row["Inktitle"]
in the rest of the php page and use mysql_free_result() at the end...or do i use it where it is?

Thanks
Vince

Anon

Remember, you are looping through the array with WHILE. If you use mysql_free_result() before you run the WHILE loop, it will not work.