Posts by |-|x

line 10 is not quite right.

strFrom &= theTable

you would need to access the row and field inside the table object.
(sorry about this example, but can't recall exact vb syntax off hand, in c# it would be something like this...)

strFrom &= theTable.rows[0].cells[0]

This should grab the first value of the first row returned in the table, you can of course reference any valid row/column index.

Note: you would need to loop through the table rows to obtain all results if more than one is returned/required.

alternative method:
If you structure your initial query so that it will only return a single result item you could use strFrom &= theQuery.ExecuteScalar without the need for an adaptor or table object. But this will work with a query that returns only a signle record with a single field

seems to me that you should check your php.ini to ensure it includes the line extension=php_mysql.dll uncommented, this is what tells php to load the mysql extension.
(if it is not there, you should be able to simply add it)

try maybe sorting on ID and date both descending

SELECT * FROM $logbook WHERE Date<='$Date' AND ID!='$ID' ORDER BY Date DESC, ID DESC LIMIT 1

you could also add an extra clause to exclude the previously selected ID AND ID!='$Next["ID"]'

(of course you need to grab the value from the MySQL result properly, but you get the idea)

else {echo '<p> "The following book was submitted: "' . $title . '</p>';

Although I am not sure this is the cause of your error, you don't actually need the double quotes inside this string unless you want them to display.

echo '<p>The following book was submitted: ' . $title . '</p>';

edit
just noticed this.

public function getdisplayTitle('title') {

you have a string constant in your function definition where you should have a variable.

public function getdisplayTitle($title) {

you may also want to change the order of checking and getting the value of your POST variable here...

$displayTitle = $_POST['title'];
if(isset($_POST['title'])) {

Thines01: that still won't increment when the initial condition is false as it will not enter the loop.

shean1488: actually you can do exactly as you wished, simply add count++ to your condition statement...

while(count++ > 0 && some expression && another expression)

this will increment count each time the condition is evaluated and (so long as count is not negative) will always evaluate to true and thus not affect the outcome of the condition statement.

I would also add that if it is an old TV show, it may have been released into the public domain and/or the original copyright holders no longer claim rights to the property. In such a case it would not be illegal for you to download and watch the show from any source.

This is common enough but will depend on the owning company, as some are happy to release their stuff for public consumption when they no longer feel it is potentially profitable, others seem to hang onto it forever in order to maybe sell the rights to produce sequels/remakes/spinoffs etc.

 var days(7);
 days(0) = "Sunday";
 ...
 function SetDay (day) {
   document.GetElementById("Daybox").value = "You Selected " + days(day) + " for your delivery";
 }

I think the rest is the same.

It is possible that the page variable hAns is losing its value on postBack. You could try storing this in a Session or Viewstate variable instead.

However, as the other guys have suggested, you should place a breakpoint on the line of code for the comparison and check what value each has at that time. Making the assumption that a variable/object has a value because you have set a value at some previous time is not necessarily valid.

Assuming you are using an SQLDataSource to bind the gridview, you can add a control parameter linked to your dropdown like so

<SelectParameters>
   <asp:ControlParameter Name="TypeFilter" ControlID="DropDownList1" PropertyName="SelectedValue" />
</SelectParameters>

Your select query must then include the parameter in the where clause, something like

WHERE Type = @TypeFilter

You can set the DropDownList to AutoPostBack="true" so that the grid will refresh whenever the selection changes.

That's essentially all you need to do.

2 things I see there...

don't forget to quote your array indexes echo $SuperRecordSet['diagnosisName']; your loop is incrementing to the wrong variable, while ($superNumRows = mysql_fetch_assoc($run_superQuery)) should be using $SuperRecordSet

actually I just noticed, strtotime is not the correct function to format your date string.

Try using date('Y-m-d', $datefrom) instead.

Do you need to send email from localhost?

Possibly for development and testing purposes - it can be useful, but is not your primary concern I think.

If you have installed something like WAMP on your local machine then it will handle the mail() functions. HOWEVER, this still requires the access through the network relay etc. for the mail to actually arrive at the other end.

check out PHP's SMTP configuration and check your server settings. These can be set (as your error message suggests) either hard coded in the PHP.ini file, or on the fly in code by calling ini_set()

Also, check that there is no firewall or anything blocking SMTP on your local machine and/or webserver, and of course that there is an SMTP server available. I am guessing you are in a Windows server environment, so if you are using Exchange you will need to point your PHP config to the exchange server and provide valid credentials for sending mail.

Hope this helps some.
/H

WHERE DATE BETWEEN

Correct me if I'm wrong but isn't DATE a reserved word?

If that's the name of your field in the `medicalrecords` table, you may need to use backticks around it, ie:

WHERE `DATE` BETWEEN

No offense chrislim2888, but you aren't 100% correct.

Below is the header information from a post on a Google group. While the specific details are irrelevant, it clearly shows email address, server name, ip address and a variety of other data that could be used to track a users virtual identity. The amount of information a person could glean from this depends on their intent, interest, and technical skill. Given that Google groups operates based on email, and email always contains IP data in the header, there is not much you can do besides looking into an anonymous server host of some sort.

However, the type of information you are talking about theguitarist, requires virtually no skill and only minimal knowledge to obtain and represents little threat to you. Geo-spacial data for example can be obtained from a number of free services once they know the source IP address.

Received: by 10.43.53.72 with SMTP id vp8mr2814576icb.0.1322663078573;
        Wed, 30 Nov 2011 06:24:38 -0800 (PST)
X-BeenThere: backbox-linux@googlegroups.com
Received: by 10.231.11.72 with SMTP id s8ls4042618ibs.3.gmail; Wed, 30 Nov
 2011 06:24:37 -0800 (PST)
Received: by 10.43.48.202 with SMTP id ux10mr2730390icb.6.1322663077799;
        Wed, 30 Nov 2011 06:24:37 -0800 (PST)
Received: by 10.43.48.202 with SMTP id ux10mr2730388icb.6.1322663077780;
        Wed, 30 Nov 2011 06:24:37 -0800 (PST)
Return-Path: <raffaele.fo...@gmail.com>
Received: from mail-iy0-f172.google.com (mail-iy0-f172.google.com [209.85.210.172])
        by gmr-mx.google.com with ESMTPS id ib2si372785icc.4.2011.11.30.06.24.37
        (version=TLSv1/SSLv3 cipher=OTHER);
        Wed, 30 Nov 2011 06:24:37 -0800 (PST)
Received-SPF: pass (google.com: domain of raffaele.fo...@gmail.com designates 209.85.210.172 as permitted sender) client-ip=209.85.210.172;
Authentication-Results: gmr-mx.google.com; spf=pass …

You are never really anonymous on the web. Hence all the browser proxy servers and vpn services available for people who wish to obfuscate their identity.

All of that information can be obtained from simple analysis of your IP address, which is (as a matter of necessity) passed to the server with every web request. I'd say that person is just messing with you, and it is not really anything to worry about. This type of thing happens all the time, particularly on "hacker" forums and the like.

SELECT count(DISTINCT bodyNo) FROM paintshop WHERE `date`='2011-11-29'

you just need to grab the other values from the POST and include them in your sql query

eg:

//format:  $variable = $_POST['<input textbox id>'];

$pubdate = $_POST['updatepubdate'];
$title = $_POST['updatetitle'];
$publisher = $_POST['updatepublisher'];
//...etc, as many as you need...
 
$sql="UPDATE Books SET PublishDate='$pubdate', Title='$title', Publisher='$publisher' WHERE BookID = ".$bookid;
// check your field names are correct, and don't forget the quotes for string values

If you move your update code php block to the top of the page, right before the SELECT, it will automatically display the updated data when the page loads after the POST.

there are a few ways you could do it. One might be to use the query result, like:

if ($conn->query($sql))
   echo "Update Successful.";
else die("Cannot update");

around the variable in the middle, so that MYSQL will treat it as a string value: "UPDATE Books SET PublishDate='$update' where BookID = '".$bookid."'"; is BookID an integer? if so, you will not need the single quotes around it and your code should look like: "UPDATE Books SET PublishDate='$update' where BookID = ".$bookid;

don't forget you need quotes around your variable in the query, as I said previously

you're setting $query at line 74 but trying to execute $sql on line 78

OK... it looks like you are using MySQLi to handle the connection, should you therefore be using mysqli_query to perform the update operation?

What specific error messages are you getting?

at a quick glance I can advise the following:

You will probably need to surround your SET variables with quotes, ie: "... SET PublishDate='$update' ..." Also, assuming that PublishDate is a datetime field of some sort in your database, you will need to ensure the data being input is in a format that MySQL can convert to a date, such as "yyyy-mm-dd"