How to select all columns except one?
up vote
1
down vote
favorite
How can I select all columns in my database except the one the user is on?
I want to have all data posted in my xml page, but not the line that shows the current users info
<?php
include_once 'test-dbconnect.php';
function parseToXML($htmlStr)
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
$sql = "select * from tbl_users WHERE username != '".$row['username']."'";
$result = mysqli_query($DBcon, $sql) or die("Error in Selecting " . mysqli_error($DBcon));
//create an array
$user_data = array();
while($row =mysqli_fetch_assoc($result))
$user_data = $row;
echo '<marker ';
echo 'name="' . parseToXML($row['username']) . '" ';
echo 'address="' . parseToXML($row['address']) . '" ';
echo 'latitude="' . $row['latitude'] . '" ';
echo 'longitude="' . $row['longitude'] . '" ';
echo '/>';
//close the db connection
mysqli_close($DBcon);
// End XML file
echo '</markers>';
?>
php xml database
edited Nov 11 at 3:11
Cœur
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
add a comment |
up vote
1
down vote
favorite
How can I select all columns in my database except the one the user is on?
I want to have all data posted in my xml page, but not the line that shows the current users info
<?php
include_once 'test-dbconnect.php';
function parseToXML($htmlStr)
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
$sql = "select * from tbl_users WHERE username != '".$row['username']."'";
$result = mysqli_query($DBcon, $sql) or die("Error in Selecting " . mysqli_error($DBcon));
//create an array
$user_data = array();
while($row =mysqli_fetch_assoc($result))
$user_data = $row;
echo '<marker ';
echo 'name="' . parseToXML($row['username']) . '" ';
echo 'address="' . parseToXML($row['address']) . '" ';
echo 'latitude="' . $row['latitude'] . '" ';
echo 'longitude="' . $row['longitude'] . '" ';
echo '/>';
//close the db connection
mysqli_close($DBcon);
// End XML file
echo '</markers>';
?>
php xml database
edited Nov 11 at 3:11
Cœur
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
How can I select all columns in my database except the one the user is on?
I want to have all data posted in my xml page, but not the line that shows the current users info
<?php
include_once 'test-dbconnect.php';
function parseToXML($htmlStr)
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
$sql = "select * from tbl_users WHERE username != '".$row['username']."'";
$result = mysqli_query($DBcon, $sql) or die("Error in Selecting " . mysqli_error($DBcon));
//create an array
$user_data = array();
while($row =mysqli_fetch_assoc($result))
$user_data = $row;
echo '<marker ';
echo 'name="' . parseToXML($row['username']) . '" ';
echo 'address="' . parseToXML($row['address']) . '" ';
echo 'latitude="' . $row['latitude'] . '" ';
echo 'longitude="' . $row['longitude'] . '" ';
echo '/>';
//close the db connection
mysqli_close($DBcon);
// End XML file
echo '</markers>';
?>
php xml database
edited Nov 11 at 3:11
Cœur
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
How can I select all columns in my database except the one the user is on?
I want to have all data posted in my xml page, but not the line that shows the current users info
<?php
include_once 'test-dbconnect.php';
function parseToXML($htmlStr)
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
$sql = "select * from tbl_users WHERE username != '".$row['username']."'";
$result = mysqli_query($DBcon, $sql) or die("Error in Selecting " . mysqli_error($DBcon));
//create an array
$user_data = array();
while($row =mysqli_fetch_assoc($result))
$user_data = $row;
echo '<marker ';
echo 'name="' . parseToXML($row['username']) . '" ';
echo 'address="' . parseToXML($row['address']) . '" ';
echo 'latitude="' . $row['latitude'] . '" ';
echo 'longitude="' . $row['longitude'] . '" ';
echo '/>';
//close the db connection
mysqli_close($DBcon);
// End XML file
echo '</markers>';
?>
php xml database
php xml database
edited Nov 11 at 3:11
Cœur
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
edited Nov 11 at 3:11
Cœur
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
edited Nov 11 at 3:11
Cœur
17.3k9102142
edited Nov 11 at 3:11
Cœur
17.3k9102142
edited Nov 11 at 3:11
Cœur
17.3k9102142
17.3k9102142
asked Mar 2 '17 at 11:34
Marc Cummings
227
asked Mar 2 '17 at 11:34
Marc Cummings
227
asked Mar 2 '17 at 11:34
Marc Cummings
227
227
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10
add a comment |
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f42554360%2fhow-to-select-all-columns-except-one%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f42554360%2fhow-to-select-all-columns-except-one%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Do you want to exclude column or row? You wrote that you want to exclude row but your code shows the opposite.
– ElChupacabra
Mar 2 '17 at 11:37
@ElChupacabra I want to exclude one column, and to be more spefic i want the column with the data about the current user to be excluded what do you mean about my code shiws the oppsite
– Marc Cummings
Mar 2 '17 at 14:10