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

Subscribe to our news:
Partners
Testimonials
Patrick Biegel: "Thanks a lot for your fast reply and the great solution! It works now and that's really important! The PHP Generator for MySQL is a great software".
Charles Phillips: "I very much like the program and all of its functionality! Would be happy to give you an endorsement or recommend it to others - saves me a ton of time".

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