Grae Wolfe - PHP wrote:
Thank you Brad - That is what I was looking for, but now that I see how it
behaves, I am thinking that it isn't going to work the way I wanted. I need
to then be able to pass the "ID" back to MySQL so that it will retrieve just
the one record for editing.
I guess I need to go back to making the DB create an auto-incrementing ID
number. Hmmm...
Thanks!!
Well, the unique ID would probably be the *best* way to go, but you
could also get the record with the below solution, of course this
requires every combination of first and last name is unique...
if you do:
$id = "Smith,Adam"
Then:
list($fname, $lname) = explode(",",$id);
select * from table where first_name = '$fname' and last_name='$lname'
would do the trick...
Of course this has many "what-ifs" asociated with it...all of which
would be taken care of with an auto-incrementing/primary key ID field
for wach record ;-)
-Brad
"Brad Bonkoski" <bbonkoski@xxxxxxxxxxxxxx> wrote in message
news:447DF244.1070705@xxxxxxxxxxxxxxxxx
Grae Wolfe - PHP wrote:
Good Day!
I am trying to use my limited knowledge to create a VERY simple process
to display some of the information in my table, allow a particular record
to be selected, then opened on a page with text boxes to edit the
information, after which the UPDATE command will be used to update the
database.
That being said, I have a way that I think this will work, but I don't
have a unique record number in my table for each of the entries. I have
tried getting PHPMyAdmin to set this up, but I cannot seem to make it
work. SO - I need to try to create that ID on the fly. I figured I could
just combine the first and last names to make this ID, but I am not sure
what the syntax should be. Here is the code I have dealing with defining
the variables...
Any help or thoughts would be splendid!
while ($row = mysql_fetch_array($result)) {
$id = $row['last_name'],$row['first_name'];
$fname = $row['first_name'];
$lname = $row['last_name'];
$option_block .= "<option value=\"$id\">$lname, $fname</option>";
Use the dot (.) for appending variables...
so it would be:
$id = $row['last_name'].$row['first_name'];
...or course if you want that would look like this: 'SmithAdam'
if you want 'Smith,Adam' as your id then:
$id = $row['last_name'].",".$row['first_name'];
-Brad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
