Coding Help For A Novice

[Anon]

I have this link:
<a href=\\"view_singleunit.php?org=$unit\\">$unit</a>

However my sql statement is not picking it up. All I get is a blank.

$chk_id = \"SELECT org from lsv WHERE org = \\"$org\\"\";

$chk_id_res = @($chk_id,$connection) or die(\"Couldn\'t execute query.\");

$chk_id_num = mysql_num_rows($chk_id_res);

if ($chk_id_num == \"0\") {

header(\"location: $indexurl/index.htm\");
exit;

} else {

$sql = \"
SELECT *
from lsv
where org = \\"$org\\"
\";

$result = @($sql,$connection) or die(\"Couldn\'t execute query.\");

while ($row = mysql_fetch_array($result)) {

extract ($row);

Any help would be appreciated.
Thanks
:o) Ivan

[flipis]

Try to use only \" instead of \\"

And, as for the query, this is my way:

$query = mysql_query($sql,$Conn);
$rows = mysql_num_rows($query);

for($i=0;$i<$rows;$i++){
$result = mysql_result($query,$i,"field");
}

Hope it helps

fLIPIS

[bastien]

try

$chk_id = "SELECT org from lsv WHERE org = '$org'";
added the single quotes on assumption that $org is text

What's with all the slashes? You only need those when echoing back to the browser
to escape the HTML attributes...get rid of them

Also don't need the '@' symbol before the mysql_query

hth
bastien