Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Steve Morton: "First let me thank you for making this application Free. Best deal I have ever see for what it does".
Charles Phillips: "Just want to take a second to really thank you for all the great support you give – I think that’s by far the best feature you offer".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

ExecScalarSQL

Executes a query returning a single value.

 

Signature:

function ExecScalarSQL($sql)

 

Example:

$userId = $this->GetCurrentUserId();

$sql = "SELECT status FROM phpgen_users WHERE user_id = $userId";

$userStatus = $this->GetConnection()->ExecScalarSQL($sql);

 



Prev Return to chapter overview Next