form problem

amar3d

Hi i have a for in which users can view data from tables and update the information. The problem is 1 form needs to show details from 3 different tables, members, post_code, and payment. but when i try to make a query to select from different tables i get trouble with the mysql_num_rows function, below is the code where it shows and updates customer info, but i want it to show the data from the other tables also, i am pretty novice at this so forgive me if this seems like a trivial question, thanks in advance,

-amar

<html><head><title></title></head>
<body>
<?
$cid=$_POST['customer_id'];
$db="test";
//mysql_connect(localhost);
$link = mysql_connect("localhost");
if (! $link)
die("Couldn't connect to MySQL");

mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());

$query1=" SELECT * FROM members WHERE customer_id='$cid' ";
$result1=mysql_query($query1);

$num=mysql_num_rows($result1);

$i=0;
while ($i < $num) {
$email=mysql_result($result1,$i,"email");
$title=mysql_result($result1,$i,"title");
$first_name=mysql_result($result1,$i,"first_name");
$second_name=mysql_result($result1,$i,"second_name");
$membership_valid=mysql_result($result1,$i,"membership_valid");
$password1=mysql_result($result1,$i,"password1");
$notes=mysql_result($result1,$i,"notes");
$post_code=mysql_result($result1,$i,"postcode");
$street=mysql_result($result1,$i,"street");
$town=mysql_result($result1,$i,"town");
$security_code=mysql_result($result1,$i,"security_code");

laserlight

Since we dont get to see what actually is the problem, it is difficult to advise you how to solve it.

I do suggest a simplification to your code:

$query1 = "SELECT * FROM members WHERE customer_id='$cid' ";
$result1 = mysql_query($query1);
$num = mysql_num_rows($result1);

while ($row = mysql_fetch_array($result1)) {
	$email = $row['email'];
	$title = $row['title'];
	//etc
}

This is better than calling mysql_result() so many times.