Jump to content

man12_patil3

Members
  • Posts

    27
  • Joined

  • Last visited

    Never

Posts posted by man12_patil3

  1. $showCountSql = "select cad_count from counteraccountdtl WHERE cad_userid =".$_SESSION['UID']." LIMIT 1";

    $showCountresult = mysql_query($showCountSql);

    $showCountrow = mysql_fetch_array($showCountresult);

    $newCount = $showCountrow[cad_count];

     

     

    if(is_int($newCount))

    echo "Value  is Integer";

    else

    echo "Value not Integer";

     

     

    i m fetching value by Mysql "cad_count integer(5)" and  feild then i cheak this value is interger  or not it show the "Value not Integer". What is wrong in it ???

     

     

     

  2. I have table with 3 Columns id(Primary), name, percent  , i want to know the missing id from Column id and repeated percent with No. of count .

     

    For e.g. id(primary)    =  1,  4,  5,  7,  8, 12, 13, 14, 15, 16  (missing id is 2,3,6,9,10,11)

                      Percent      = 88, 75, 88, 65, 55, 88, 88, 64, 65, 70 (repeated percent is 88(4), 65(2) )

     

    i want to Sql Query for above output.

  3. hi all,

     

      My prob. is that i am feacthing record from DB by while loop (Mysql fetch Arry) and print it row by row.

     

      id    Begnning Stage          Ending Stage                    Active

     

      1      Begnner   Intermidiate       "No"

      2    Intermidiate    Uppper intermidiate      "Yes"

      3      Begnner   Intermidiate       "Yes"

      .     . .         .

      .     . .         .

      .     . .         .

      .     . .         .

      n     . .         .

     

    as above mention i want to  Active is "NO" IF first Records Ending stage is same as next record "Begnning Stage".

  4. Pooja u need to submit array for selected cities which user select and store it in Db after that in next page fetch it and explode the array u will get the value of selected city..

  5. :shrug:

     

     

    CREATE TRIGGER ins_trig AFTER INSERT ON test

    FOR EACH ROW

    BEGIN

    INSERT INTO test2 (id,  Name,  address,  ph ) (SELECT * FROM `test` ORDER BY id desc LIMIT 0 , 1);

    END;

     

    this is my query  when i try it show the following error-

    "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "

    on MySQL client version: 5.0.45

     

     

    Plz help me

     

    Thx in Advance.....

     

     

  6. hi all

    i know php but i want to learn joomla. i read Documentation of joomla and installed sussesfully but i have use more afford but i can't change the home page of sample template. can u guide me the easy and simple temp to edit and understand joomla ??

     

    can to send me joomla related link which will be beneficial for me to learn joomla?

     

    thanks

  7. hi all

    i know php but i want to learn joomla. i read Documentation of joomla and installed sussesfully but i have use more afford but i can't change the home page of sample template. can u guide me the easy and simple temp to edit and understand joomla ??

     

    can to send me joomla related link which will be beneficial for me to learn joomla?

     

    Thx

  8. php is new lang. for me. i have 2000 record which is dispaly on web page(10 record each page) by pagination. but problem is that i get 200 links of pages on webpage which take large space. I want to display it in a grop of 10-10 pages. where is the code for it.

     

    can anybudy help me ??

     

     

    Thx 

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.