mysql query result in php variable

by

Of course there is. Check out mysql_query, and mysql_fetch_row if you use MySQL.

Example from PHP manual:

<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);

echo $row[0]; // 42
echo $row[1]; // the email value
?>

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  4. regarding installation of php in windows
  5. Auto Increment ID’s of 4 digit
  6. php nested while loop. Inner loop works only once [closed]
  7. Problame with files on SQL
  8. PDOException “could not find driver”
  9. Row count with PDO
  10. Best way to INSERT many values in mysqli?
  11. How to view query error in PDO PHP
  12. php/mysql with multiple queries
  13. How to populate second dropdown based on selection of first dropdown using jQuery/AJAX and PHP/MySQL?
  14. Resetting array pointer in PDO results
  15. Notice: Array to string conversion in
  16. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  17. Using Mysqli bind_param with date and time columns?
  18. How to efficiently find the closest locations nearby a given location
  19. How do I insert multiple checkbox values into a table?
  20. Is mysql_insert_id safe to use?
  21. PDO::PARAM for type decimal?
  22. How to set up entity (doctrine) for database view in Symfony 2
  23. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  24. How to execute raw queries with Laravel 5.1?
  25. Can’t find FULLTEXT index matching the column list (indexes is set)
  26. belongsToMany relationship in Laravel across multiple databases
  27. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  28. How do I save PHP session data to a database instead of in the file system?
  29. MySQL, how to insert null dates
  30. Escaping SQL queries in Codeigniter

Leave a Comment