Search:

Hi,

I want to execute the following code for my firebird database


$query = "UPDATE COST_DTL SET MARKA=$marka, TEKNIK_DETAY=$td, SERIAL=$seri where ID= ?";
$prep = ibase_prepare ( $dbh,...

I have a MySql database including tables, views and integers. My tables are MyIsam,

I want to switch to InnoDB. Is it enough just to change the storage engine type from My Isam to InnoDB in...

Lets say i have 3 tables : clients, invoices, payments.

And i would like to create a table with a query like following :

client name / transaction type / date / amount

bob --> sales invoice...

How may i manage to write http://www.site.com/about-us.php as http://www.site.com/en/about-us.html by using .htaccess rewrite utility?

This query works within php. But also this form is inside thew paranthesis. It shouldn't be considered separately?

no answer yet????

I try to create view by "Dreamcoder for mysql"

Here is my code :



select c.*, iha.* from clients as c
left join ( select id,client_id, sum(grand_sum*exch_rate*(100-disc_prcnt)/100) as sumfa...

Hi

I have the following sql statement



So, I would like mysql to check each row as summing and if the crn field is "EURO" then the respective field value for line_net should be multiplied by...

in fact this $node->cl_name comes from $node=mysql_fetch_object($sql)

does it make any difference?

none of them worked!

Here is my script for input matching


if( eregi($sSearch, $node->cl_name) )

But it is starting from the left to make the matching. I want it to make the matching for any string included in ...

Hi all,

I just set up wamp server and now i got following error message :


Notice: Undefined index: kod in C:\neyserv\wamp\www\accounting\js\fatura.php on line 5

And here is line 5 in...

I have two autocomplete enabled inputs

this one is inside the original code of the page and works perfectly

<input type="text" id="mstr_adi" name="mstr_adi" style="width: 147px;"...

For ajax autocomplete I am using a script from
http://momche.net/publish/article.php?page=acdropdown#examples

It is very simple and practical but i have a problem. When I use it in a form, after...

Here is my url :


http://localhost/accounting/products.php?sortby=($row->fgiris+$row->sfeksik)&nr=3

and i want to catch value of sortby to insert into the db by


$sortby = $_GET["sortby"];

I want the application to remember my choice because i am using pagination as showing table rows.

Any way i am using database to store user choices and it is very easy as well as reliable

I want to create sortable <table> utilizing cookies. Sorting is made by clicking respective table header.


<tr>
<th><a href="?sortby=musteri">FIRMA</a></th>
<th><a...

thanks for the feedback.
Actually i can write myself some snippets to manage getting what i want but i thought that there may have been some code pieces already written for this purpose to avoid...

I want to print content of a a given table to the page inside a <table> like phpmyadmin's browse command. Do you know any ready script to do it?

$sql=mysql_query("select count(musteri) as musc, distinct(musteri) as mus from aritma_talep_takip ORDER BY musteri");



This query doesnt work....

any idea?

For autocomplete, I am using scripts from :

http://momche.net/publish/article.php?page=acdropdown

To create the arrays, i have the following code block :



<?php
$fields = array();

You are completely right. I just studied the link which you provided. But there is a point which a didnt understand sufficiently.

There we have a function invokeScript(divid)
I am not pretty...

Thanks for the answer, it seems some complicated. Is it possible to provide an example with php output?

With ajax response, i print a block including some other ajax functions.

But if i click the button which fires that function printed on the screen by ajax response, the function doesnt work.
...