I have a table with several columns, including one ID field containing a unique key. What I want to do is select all duplicate records from the table based on one of the columns, say the Item number field. Is there a simple way to do that? I know using unique can give me the non-dupe records...
Can someone show me a simple way to calculate dates? What I'm trying to do is get a future or past date based on today's date. Example, if I want to know what the date is 3 weeks from now.
thanks!
PETERV
Syracuse, NY &
Boston, MA
tweenerz,
If you check the webpage now http://www.vanderhaden.net/add_user2.php It looks like some kind of column spanning problem. Any ideas how to fix it? I want it to be on one line beneath the login button.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<!--...
I have a web page (see code below) where I want to display the date & time below the submit button, after skipping one blank line. No matter what I've tried, the date & time keep coming out in the lower right next to the submit button. (You can view the page at...
jaxtell & vacunita, thank you both for these examples. I'm using jaxtell's answer in my page, but I've removed the newline inside the quotes, as it is not needed when using the <br>. You both have been very helpful, I apreciate you both.
Peter V.
PETERV
Syracuse, NY &
Boston, MA
Also, try using a heading that describes the problem. Please Help doesn't tell anyone anything, and will most often be ignored.
PETERV
Syracuse, NY &
Boston, MA
In the query below, I'm selecting all records in a table, in the future, I may be only selecting a few record from th table.
Is there a way to get the count of records returned by the query, so that I can base what I do next on that count?
Thanks!
$query ="select * from usersTable";
$result =...
Thanks for the info guys, it'll come in handy. Can either of you give me an example of how I could output this with line breaks to a web page using HTML?
PETERV
Syracuse, NY &
Boston, MA
After doing a little searching on the net, it looks like I'm doing this entirely wrong. Can anyone point me in the right direction? Basically what I'm looking for is how to format the error message from a MySQL query into a multi-line format for display in a web page.
Thanks....
PETERV...
I'm new to PHP, and I'm having problems with getting error messages to display on multiple lines. My syntax must be wrong, but I haven't been able to figure out the problem.
I've tried:
$query ="INSERT INTO usersTable
VALUES ('0','karen','$encrypted_password')";
$result =...
What I want to do is have one image for the background. The way it is now, the top left 75% of the page is one copy of the image, and of course the rest of the page consists of 3 "segments" of the same image. All I want is one image for the entire background. Any way to do it?
PETERV...
Mikey,
Below I've listed my html & css code. Will your code:
img.resize { width: 150; height: auto;}
work with my stuff? I'm wondering, because I'm specifying the background image in my css, not in the html. As such, I'm a little confused as to how I would incorporate your code. If you...
Mikey,
I'm new to this stuff, but what you added looks just like what I need. If I'm using this for my page's background image, how would I code the html for this?
PETERV
Syracuse, NY &
Boston, MA
Is there a way to use CSS to create a "footer" for a web page? I want to print the output from the bold red lines below at the bottom of my web page.
The other problem involves the page's background image. Is there a way to make the background image expand & contract depending on how the user...
I want to run the sql command DESC from within a php script. I'm new to this, and am not sure that this is possible. My attempt below runs with no errors, but gives no output. Can someone help me out with this? Any help is gratefully appreciated!
PV
<?php
// Thursday, August 14, 2008...
Vragabond,
I just found the include_once file, and that indeed is pointing to the wrong code. I commented that out, and it works correctly now. I'm very new to this, so please correct me if I'm mistaken, but I would only need to have the include_once statement in this script if I need to...
Forgot to mention:
According to the book, I should actually be getting this output:
Result set has 9 rows. Number of rows: 9.
PETERV
Syracuse, NY &
Boston, MA
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.