Jump to content

assassin87

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About assassin87

  • Rank
    Newbie
  1. assassin87

    Sum Same Values

    Hi everyone, i want to ask a question. I have some company name and totalroom in my procedure. But when i execute my procedure they are coming twice or more. İ want to sum companies at once. İ took a photo if you check that u will understand what i mean. http://imageshack.us/content_round.php?page=done&l=img546/5725/adszobb.jpg&via=mupload&newlp=1 here is my sql SELECT S.agency, SUM(S.totalroom) ODA, SUM(S.totalpax) KISI, (S.totalrevenue) GELIRFROM SP_FORECAST_OCC_LINE_DAY('01.01.2011','31.12.2011') Swhere S.resmarket='IC PAZAR' AND S.transdate BETWEEN '01.12.2011' and '31.12.2011
  2. Yeah i know union but i want bring datas quicker than union
  3. Hi everyone i want to ask something. Now i have six queries from same stored procdure but i want combine that queries just one query. Here my queries GELİRSELECT SUM(REVENUE) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) DÜZELTMESELECT SUM(REVENUE) FROM SP_FOLTRANS_STATS_DAY (:B1,:D1) WHERE PAYTYPE='DUZELTME' KREDİSELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE PAYTYPE='KREDI' NAKİTSELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE CASHTYPE = 'NAKIT' KREDİ KARTISELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE CASHTYPE = 'MASTER' OR CASHTYPE = 'VISA' İNDİRİMSELECT SU
  4. Hi everyone, can anyone help me what is Select 1 query ?
  5. assassin87

    Php Search

    Hi everyone, i have created a project in php, its a phonebook. for example i have two name as alex, when i search it brings me just one alex. How can i bring that second alex. Can you check my codes pls. <?php error_reporting("0"); require_once('Connections/baglanti.php'); ?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""){ if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ?
  6. Can i take your e-mail ? i wanna show you something about my program. i will send you my phonebook folder. And i have one more question but i cant explain here i have to show you on my program.
  7. Thank you very much but i found different solution.
  8. Yeah i konow, i have learned PHP and SQL from W3 now i have to study JS and AJAX. I wanna ask one more question too. Now i have thoose codes. <?php // Get the search variable from URL $var = @$_GET['q'] ; $trimmed = trim($var); //trim whitespace from the stored variable // rows to return$limit=10; // check for an empty string and display a message.if ($trimmed == "") { echo "<p>Kelime Giriniz...</p>"; exit; } // check for a search parameterif (!isset($var)) { echo "<p>Aranacak birsey yok!</p>"; exit; } //connect to your database ** EDIT REQUIRED HERE *
  9. Thank you very much its really very complex and i know nothing about javascript or ajax. Thanks for your help again.
  10. yeah absolutely. For example when i click a name in the table then i want update or delete it. But in my table its not possible. So is it possible with Javascript or AJAX ?
  11. Thank you very much, i will try it But is it possible that can users change anything in my page ? I think its not. There is no need to add update or delete button, am i right ?
  12. assassin87

    Datagrid In Php

    Hi Everyone, İ wanna ask you something. Now i have to create simple phonebook in PHP. I connected PHP and MySQL. I can insert data from PHP to SQL and i created a table. But i have to create a table like datagrid in C#. Because when I click to data i should delete or update data. And İ will put a search button because i must search peaople in my phonebook. Can anyone help me please ? http://tinypic.com/view.php?pic=9zn5ee&s=7 here is my sql table.
×
×
  • Create New...