[PHP-DB] Re: MySQL- Stored Procedures Views

Hello, Stored Procedures are faster than standart sql query beacuse they have already compiled sql script. -- Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Lasitha Alawatta [EMAIL PROTECTED], haber

Re: [PHP-DB] mysql question.

Hello, I try your SQL statements. There is no problem on your SQL syntax and you can use alias in the order by clause.:) $SQL = SELECT EMail,count(EMail) AS repeated FROM mena_guests WHERE Voted = 'yes' GROUP BY EMail ORDER BY repeated LIMIT $startingID,$items_numbers_list; --

[PHP-DB] Re: help with mysql connect error

Hello, Firstly download the PHP 5.X source tar.gz package and then install the PHP 5.X --with-mysql=DIR parameter (DIR is the mysql 5 installation directory). If you try to use this method, your problem will be fixed. I think you installed the mysql 5 and PHP 4 together with

[PHP-DB] Re: IF ( $_POST['submit'] == Update Subscriptions OR$_POST['submit'] == Update Entire Account ) {

Hello, Can you send your HTML form structure? How many HTML form do you use? It's important to solve your problems :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Ron Piggott [EMAIL

[PHP-DB] Re: Connecting to MS Access Database using PHP via ODBC.

changed oracle installation directory's user privileges in Windows 2003, I was running php and oracle together. :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net ABCOM Support [EMAIL PROTECTED], haber

[PHP-DB] Re: Search

descending order. This is simple, easy and very useful searching method:) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net MIGUEL ANTONIO GUIRAO AGUILERA [EMAIL PROTECTED] wrote in message news:[EMAIL

[PHP-DB] Re: odbc problem

operating systems becuase in Windows 2003 , when I run PHP with IIS I faced many problems. :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net bedul [EMAIL PROTECTED] wrote in message news:[EMAIL

[PHP-DB] Re: PHP_AUTH_USER .htaccess

Hello, You can use HTTP_AUTH without .htaccess file. It is very easy. You can use like following example on your web site.:) ?php if ( ( !isset( $_SERVER['PHP_AUTH_USER'] )) || (!isset($_SERVER['PHP_AUTH_PW'])) || ( $_SERVER['PHP_AUTH_USER'] != 'username' ) || ( $_SERVER['PHP_AUTH_PW'] !=

Re: [PHP-DB] recursion in php and mysql

Hello, You can use class like the following code .:) ?php require (mysql.class); $conn = new MySQLConnection ($user, $password, $host,$database); ... ... $query1 = new MySQLCommand ($sql1, $conn); $query1-Execute(); $query2 = new

[PHP-DB] Re: Creating a Table to line query results in php?

Hello, You can use HTML center tag. if you change your echo line in the code below, may be your problem will be fixed :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Scott [EMAIL

[PHP-DB] Re: mssql Database name grater than 30 characters

Hello, All of objects that you created in SQL Server is in the master database. In this database, there is a table called sysobjects that put all of information about tables and so on. You can see table name length in this table :) -- Haydar TUNA Republic Of Turkey - Ministry

[PHP-DB] Re: auto upload

everytime:) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net bedul [EMAIL PROTECTED], haber iletisinde sunlari yazdi:[EMAIL PROTECTED] this might a strange code i request, plz forgive my rudeness

Re: [PHP-DB] error creating tables

problem. if the accout isn't root, you should check your user privileges. -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Frank Flynn [EMAIL PROTECTED], haber iletisinde sunlari yazdi:[EMAIL

[PHP-DB] Re: echo delay...

Hello, if you use the AJAX, your problem will be solved. :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Matthew Ferry [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi

[PHP-DB] Re: Problem with ocilogon

Hello, if you add your ENV variables for the oracle user (for example ORACLE_HOME, ORACLE_SID) in the Apache startup script, your problem will be solved.:) . You can create your your own Apache startup script /etc/rc.d/init.d folder after this step. You should create a link file. You can

[PHP-DB] Re: How to call image from mySql to php file

after close the connection. You should close the connection all of process.:)) if you call the picture in HTML with img tag. in your code if you change the echo line like this echo img src =\$logos \, you will see the picture:) -- Haydar TUNA Republic Of Turkey - Ministry of National

Re: [PHP-DB] Strange action with =

Hello This (=) is used in the variable references. in $ref=$array[2] line $ref variable and $array[2] variable point at the same address. if you assign any value to this any variables, both of them will change their values because echo($ref) line display b on the screen. -- Haydar TUNA

[PHP-DB] Re: SQL query error

Hello, Do you check the how many rows return. You can display rows count with following PHP code. If rows count is zero, you can see the blank page. :) $num_rows = mysql_num_rows($result); echo ($num_rows); -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education

[PHP-DB] Re: MSSQL Server

Hello, If you can change the SQL Server Authentication to the Mixed Mode (Windows and Remote User), your problem will be fixed. If you use the Unix like Operating System, you can install FreeTDS package to connect MSSQL Server.:) -- Haydar TUNA Republic Of Turkey - Ministry