MySQL Searching

[EdoDodo]

Hi.

 

If you have a MySQL table and you only know two of the values for one row (say "Username" and "Password") how can you make a PHP script to tell you the third value on that row (like ID).

 

Thanks in advance,

Edo

[EdoDodo]

Oh yes, I am using MySQL 4.1

[per1os]

Use www.php.net/mysql_fetch_assoc IE:

 

<?php
// db connection above

$sql = "SELECT * FROM table_name LIMIT 1";
$row = mysql_fetch_array(mysql_query($sql));

foreach ($row as $colname => $val) {
      $columns .= $colname . "<br />"; 
}
?>

 

That would work.

 

There is also a nice function http://us2.php.net/manual/en/function.mysql-list-fields.php    that should list the fields.