Code Script .co.uk

Home | Scripts | Tutorials | Disclaimer | Sitemap | Contact

   Sql Query Results
 

Reference / Php / Sql Query Results

Examples of ways to get query results from a sql query.

Multiple Rows

$sql_select = mysql_query("select * from table where id = '1');
while($row = mysql_fetch_array($sql_select)){
$val1 = $row["column1"];
}

Single Row

$sql_select = mysql_query("select * from table where id = '1');
$row = mysql_fetch_array($sql_select);
$val1 = $row["column1"];





Please note that a disclaimer applies to any code on this page.
 
   Actions
  Go Back
  Bookmark
  Print Page


   Menu
 
- Links
- Reference
     - Javascript
     - Mysql
     - Php
          - Calculate Date Yesterday
          - Database Backup
          - Ftp Upload
          - Gzip File
          - List Files In Directory
          - Previous Sql Insert Id
          - Send Email
          - Server Visitor Properties
          - Set Global Get And Post Variables
          - Sql Query Results
     - Standards
     - Windows Os
- Script Editors
- Tutorials
- Vbscript