Need Help Passing Variables

[jjfletch]

Thanks everyone. Turns out it was a simple (albeit boneheaded) problem with case sensitivity.

[Norman_Graham]

Hi Fletch

Forgive me if I'm barking up the wrong tree ... but I ain't never seen curly brackets in MySQL statements, and certainly never in echo statements. Looks like a simple syntax error to me. The fact that you didn't get a error message is strange though, although I suppose this could depend on your error-reporting settings.

HTH

Norm

[Phfeenikz]

I've never been able get the superglobal arrays to work in MySQL statements. Change your MySQL stuff to look like this:

$query = "SELECT * FROM pediatrics WHERE doc_id={$_GET['did']}"; 

should be

$did = $_GET['did'];
$query = "SELECT * FROM pediatrics WHERE doc_id='$did'";

The curly braces in the echo statements however should work fine, I use 'em myself.

[jjfletch]

Don't think that's the problem... I'm experiencing the same problem even when I write the code like this:

<?php

if (is_numeric ($_GET['did'])) {

   $did = ($_GET['did']);
   require_once ('../files/mysql_connect.php');
   $query = "SELECT * FROM table WHERE doc_id=('$did')";
   $result = mysql_query ($query); 
   $row = mysql_fetch_array ($result, MYSQL_ASSOC);

$fn = $row['firstname'];
$ln = $row['lastname'];
$t = $row['title'];
$a1 = $row['address1'];
$c1 = $row['city1'];
$s1 = $row['state1'];
$z1 = $row['zip1'];
$p1 = $row['p1'];
$a2 = $row['address2'];
$c2 = $row['city2'];
$s2 = $row['state2'];
$z2 = $row['zip2'];
$p2 = $row['p2'];
$a3 = $row['address3'];
$c3 = $row['city3'];
$s3 = $row['state3'];
$z3 = $row['zip3'];
$p3 = $row['p3'];

   echo "<P><B>$fn $ln, $t</B><BR />
         $a1<br />
         $c1, $s1 $z1<br />
         $p1
         <P> 
         $a2<br />                 

         $c2, $s2 $z2<br />                                   

         $p2
         <P>
         $a3<br />                 

         $c3, $s3 $z3<br />                                   

         $p3              

         <hr> 
         "; 
   mysql_close();
}
?> 

[jjfletch]

Anyone have any other ideas or suggestions? Help is really appreciated.

[Phfeenikz]

Since you haven't indicated that you are receiving any error messages, I would have to think that the query is suspect. In that situation I would usually do a check to see if the array is getting populated with any values, like so:

$row = mysql_fetch_array ($result, MYSQL_ASSOC);
print_r($row);

Also, you might try something like this with your echo statement, it's worth a try anyway:

echo "<P><B>".$fn." ". $ln.",". $t."</B><BR /> ";