getting data from a table

zzz

I have page#1 where I create a drop-down menu with entries "OneName" from a db table. When I make a selection I click NEXT page and post that "OneName" on page#2 as:

<?php echo $OneName; ?>

Now what I really need on page#2 is to get the rest of the fields' data of the same table from a table row corresponding to OneName... Here's how i do it but it doesn't work:

<?
$db = mysql_connect("mydb", "user", "pass");
mysql_select_db("db_name",$db);
$query = mysql_query("select * from MY_TBL where OneName = '$OneName'");

echo $query; //testing to see what's returned
?>

barand

$query is a result set; you need to ge the record (row) that the result contains (if any).

$db = mysql_connect("mydb", "user", "pass"); 
mysql_select_db("db_name",$db); 
$query = mysql_query("select * from MY_TBL where OneName = '$OneName'"); 

if ($row = mysq_fetch_row($query)) {
    print_r ($row);
}

hth

zzz

What's a print_r?

I keep getting Supplied argument is not a valid MySQL result resource and points to this line:

if ($row = mysql_fetch_row($query)) {

barand

See [man]print_r[/man].

Looks like you have an error in the query.

try

$sql = "select * from MY_TBL where OneName = '$OneName'";

echo "$sql<br>";  // and see if it looks ok

$query = mysql_query ($sql) or die(mysql_error());

hth

zzz

Got it! made this part work. Fighting other bugs...