[Resolved] conditional WHERE clause

[jasonmills58]

Ok, so i need to pull one row out of my database, where the clientname matches that in the query string, and then make those values available to the html form's text boxes, for editing.

I know this is simple, but I can't find a reference anywhere...

[Gary_Taylor]

Hi

connect to your database then issue a query like

$query_rsProject = sprintf("SELECT * FROM client_table WHERE clientName = 'foo');
$rsProject = mysql_query($query_rsClient, $Db) or die(mysql_error());
$row_rsClient = mysql_fetch_assoc($rsClient);

then in your form to display the data from the query you could use

<form method="post" name="form1" action="process_it.php">
<table>
<tr>
<td>Client:>
<td><?php echo $row_rsClient['clientName']; ?></td>
</tr>
</form>

Not much of a form there but you get the idea?

Hope this helps.

[jasonmills58]

here's what i have now, and i'm getting data. however, the data is sometimes the value and sometimes the key for some other column.

whats gone funny?

$clientname = $HTTP_GET_VARS['clientname'];
$data = mysql_query( "SELECT * FROM clients WHERE clientname='$clientname'" );
$a_row = mysql_fetch_array( $data );

<tr>
<td><form name="form1" method="post" action="viewClients.php">
<table width="100%" border="0" cellpadding="3" cellspacing="0" class="listContent">
<tr>
<td width="50%" class="formContent">Username</td>
<td class="formContent">Password</td>
</tr>
<tr>
<td width="50%" class="formContent">
<input name="username" value="<?php print $a_row['username'] ?>" type="text" class="req" size="45"></td>
<td class="formContent"><input name="password" value="<?php print $a_row['password'] ?>" type="password" class="req" size="45"></td>

thanks!

[Gary_Taylor]

I haven't tried the way you are doing it, but here's how I'd do it...

$db=mysql_connect($hostname, $username, $password);
mysql_select_db($database, $db);
$querySQL= sprintf("SELECT * FROM clients WHERE clientname = '%s', $clientname);
$data=mysql_query($querySQL,$db);
$dataRow = mysql_fetch_assoc($data);

in your form:

<form method="post" name="form1" action="process_it.php">
<table>
<tr>
<td>Client:>
<td><?php echo $dataRow['clientname']; ?></td>
</tr>
</form>

ok?

[jasonmills58]

Oops! It worked after all, I was misreading the data. Here's what i did, if you're interested:

<?php 
$user = "cpoint";
$pass = "damon";
$database = "counterpoint";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
	$dberror = "Couldn't connect to MySQL server.";
	return false;
}
if ( ! mysql_select_db( $database, $link ) ) {
	$dberror = mysql_error();
	return false;
}
$clientname = $HTTP_GET_VARS['clientname'];
$data = mysql_query( "SELECT * FROM clients WHERE clientname='$clientname'" );
$a_row = mysql_fetch_array( $data );
?>
            <tr>
              <td><form name="form1" method="post" action="viewClients.php">
                <table width="100%" border="0" cellpadding="3" cellspacing="0" class="listContent">
                  <tr>
                    <td width="50%" class="formContent">Username</td>
                    <td class="formContent">Password</td>
                  </tr>
                  <tr>
                    <td width="50%" class="formContent">
                      						<input name="username" value="<?php print $a_row['username'] ?>" type="text" class="req" size="45"></td>
                    <td class="formContent"><input name="password" value="<?php print $a_row['password'] ?>" type="password" class="req" size="45"></td>
                  </tr>
                  <tr>
                    <td class="formContent">Client Name </td>
                    <td class="formContent">Email </td>
                  </tr>
                  <tr>
                    <td class="formContent"><input name="clientname" value="<?php print $a_row['clientname'] ?>" type="text" class="req" size="45"></td>
                    <td class="formContent"><input name="email" value="<?php print $a_row['email'] ?>" type="text" class="req" size="45"></td>
                  </tr>
                  <tr>
                    <td class="formContent">Phone</td>
                    <td class="formContent">Fax</td>
                  </tr>
                  <tr>
                    <td class="formContent">
                      						<input name="phone" value="<?php print $a_row['phone'] ?>" type="text" class="req" size="45"></td>
                    <td class="formContent"><input name="fax" value="<?php print $a_row['fax'] ?>" type="text" class="req" size="45"></td>

Thanks!