MySQL Query Question

[knight]

Alright I made a page and I want it to call stored text in a mysql database and display it to the user here is what I have:

<?php
mysql_connect( 'localhost', 'knight', 'junior63' )
or die ( 'Unable to connect to server.' );
mysql_select_db( 'scriptparadise_net' )
or die ( 'Unable to select database.' );
if($type == "gallery")
{
if($page == "1")
{
}
}
?>

I basically want inside the if($page == "1") to do a mysql_query from a certain table and area however I'm not sure if I use mysql_pconnect or not and when I tried to do it before it just gave me a ID number instead of stored text. Any information is greatly appreciated/

[eojlin]

hi,

well, i'm confused with what you wanted. are you asking for a <i>Query</i> statement for displaying your "stored text"?

anyway, here's a sample code for you:

if(<i>$page</i> == "1") {

<i>$result</i> = mysql_query("SELECT <i>field1</i>, <i>field2</i>, <i>storedtext</i> FROM <i>certainTable</i> WHERE <i>IDNum</i> = <i>$yourIDnum</i>") or die ("Could not BROWSE Table of Database");
list (<i>$field1</i>, <i>$field2</i>, <i>$storedtext</i>) = mysql_fetch_row (<i>$result</i>);

echo <i>$storedtext</i>;

}

---

🙂

[knight]

that was exactly what I needed infact, thanks for the sample code.