getting variable from a form

[jaf]

i'm having a problem with my script ... anybody pls help. i'm new in php

i want to use following url

http://www.sanha.org.za/view1.php?id=1

the id=number part to search in database for its values and display online. i have the following script for view1.php

<?php

include(connect.php)

$id = $_GET['id'];
$search1 = "SELECT * FROM certified WHERE $id = 'certified.id'";
$result = mysql_query($search1);

while ($row = mysql_fetch_array($result))
{
echo $row["CompanyName"];
echo "<br>";
}
?>

the script returns empty. what wrong am i doing ????

[Nert]

http://www.sanha.org.za/view1.php?id=1

the id=number part to search in database for its values and display online. i have the following script for view1.php

<?php

include(connect.php)

$id = $_GET['id'];
$search1 = "SELECT * FROM certified WHERE $id = 'certified.id'";
$result = mysql_query($search1);

while ($row = mysql_fetch_array($result))
{
echo $row["CompanyName"];
echo "<br>";
}
?>

the script returns empty. what wrong am i doing ????

hi,

ahmmn i found something wrong in your code i guess! maybe the column $id in your query statement is wrong because you have already declaired a variable $id before your query having the value from $_GET.

i'll make a small changes on your code and try it, maybe this will help you.

<?

include("connect.php");

$id = $_GET['id'];
$search1 = "SELECT * FROM certified WHERE id = '$id'";
$result = mysql_query($search1);

while ($row = mysql_fetch_array($result)) {
echo $row["CompanyName"];
echo "<br>";
}

?>


--nert

[jaf]

[quote=Nert]hi,

ahmmn i found something wrong in your code i guess! maybe the column $id in your query statement is wrong because you have already declaired a variable $id before your query having the value from $_GET.

i'll make a small changes on your code and try it, maybe this will help you.

thanx man, saved my day.... :)

[Nert]

[quote=jaf]

hi,

ahmmn i found something wrong in your code i guess! maybe the column $id in your query statement is wrong because you have already declaired a variable $id before your query having the value from $_GET.

i'll make a small changes on your code and try it, maybe this will help you.

thanx man, saved my day.... :)

hi,

always welcome...(^_^)


--nert