MySQL fetching data....

[Anon]

I have a form that enters data into a MySQL database, I can retreive ALL the data by doing the following...

while ($the_array = mysql_fetch_array($execute))
{
print "$the_array[msg_id]";
print "etc......";
}

...that works fine getting all the $msg_id values, but how can I get a specific one.

For example I post a message, this appears on the forum page (OK!), but when I want to reply to it, I want to display JUST that ONE specific message, not all the others that have been entered previously. Hope you follow me.

-Can any1 help?
Andy

[[deleted]]

Well...somewhere above:

while ($the_array = mysql_fetch_array($execute))
{
print "$the_array[msg_id]";
print "etc......";
}

you should have something that looks like :

$query = "SELECT * FROM sometable";

or something similar..change that to:

$query = "SELECT * FROM sometable WHERE msg_id=$x";

where $x is the id you are looking for...

Hope that helps...

Matt Wade
http://codewalkers.com