Query from Mysql

[alternative]

i have try to query data from mysql but found a lot of problem here.

database = khai
table = writers

column = nameID, name, address, phone

this is my codes (below)

<?

function db_connect()
{
$result = @mysql_pconnect("localhost", "khai", "password");
if (!$result)
return false;
if (!@mysql_select_db("khai"))
return false;

return $result;
}

function get_story_record($name1)
{
$conn = db_connect();
$sql = "select * from writers";
$result = mysql_query($sql, $conn);
return(mysql_fetch_array($result));
}

if (isset($writers))
$s = get_story_record($name1);

echo "<tr>";
echo "<td>";
echo $s[name1];
echo "</td>";
echo "<td>";
echo $s[address];
echo "</td>";
echo "<td>";
echo $s[phone];
echo "</td>";

?>

I am trying to retrieve records using spesific row ID, which the page should be like this

khai.php?nameID=1
--------------------------------then display

Name Address phone
blalal blalalal blalalala

---

anyone please help me on this..thanx in advance.

[cgraz]

if the nameID is in the url, then

$nameID = $_GET['nameID'];
$sql = "select * from writers WHERE nameID='$nameID'"; 
$result = mysql_query($sql); 

Cgraz

[alternative]

where should i put

$nameID = $_GET['nameID'];
$sql = "select * from writers WHERE nameID='$nameID'";

$result = mysql_query($sql);

is it have problem with the password? coz i din put any password on the database, and how about the echo place.. is it have any problem with the query?

[sgoku01]

You have to replace it with the one in the function get_story_record()

So like this:

<? 

function db_connect() 
{ 
$result = @mysql_pconnect("localhost", "khai", "password"); 
if (!$result) 
return false; 
if (!@mysql_select_db("khai")) 
return false; 

return $result; 
} 

function get_story_record($name1) 
{ 
$conn = db_connect(); 
$nameID = $_GET['nameID']; 
$sql = "select * from writers WHERE nameID='$nameID'"; 
$result = mysql_query($sql); 
return(mysql_fetch_array($result)); 
} 

if (isset($writers)) 
$s = get_story_record($name1); 

echo "<tr>"; 
echo "<td>"; 
echo $s[name1]; 
echo "</td>"; 
echo "<td>"; 
echo $s[address]; 
echo "</td>"; 
echo "<td>"; 
echo $s[phone]; 
echo "</td>"; 
?> 

[alternative]

If i plan to put in into a table
then wat code should i change
some how like this

---

<table border="1" width="100%">
<tr>
<td width="33%">Name</td>
<td width="33%">Address</td>
<td width="34%">Phone</td>
</tr>
<tr>
<td width="33%"></td>
<td width="33%"></td>
<td width="34%"></td>
</tr>

</table>

[sgoku01]

eeeuhhh, you can leave it the same as it was before (like $s['id'] etc.)...

[alternative]

that's mean the echo b4 that is right?

then if i change to

<tr>
<td width="33%"><? echo $s[name1]; ?></td>
<td width="33%"><? echo $s[address]; ?></td>
<td width="34%"><? echo $s[phone]; ?></td>
</tr>

---

this is correct also?

[alternative]

sgoku01,
i try ur codes.. but it doesnt work?
does anything wrong with the codes there?

it show blank page.

[alternative]

hm...anyone can help me on query database mqsql spefisic parameter?