₦airaland Forum

the code that sends back output to the webbrowser is incomplete and has a lot of errors in it just for example what I showed you to change. Can you post everything in the .php file that is called to show the output?

I can see unclosed while loops what not.

<? //body listings start here ?>

<h2><?= $area_name?></h2><br>

<?

change above to

<? //body listings start here ?> 

        <h2><? echo $area_name;?></h2><br>

<?

one of the best ways to debug mysql is to have mysql installed on your development system. then query up your host and see whats going on. going through php is some what blind. you can download it fom http://dev.mysql.com/downloads/mysql/

it is a DOS interface you can enter into your mysql database using mysql commands and see exactly what the data looks like. It will not take you more than 15 minutes to get started using this tutorial http://dev.mysql.com/doc/refman/5.1/en/tutorial.html


Let me know if you need more help.

word on the street this site is up for N25billion.

btw can you post the error output?

Just a glance at your code does not show mysql_free_result() and mysql_close() in your code. These are very important to close connections to the database. Some webhosting services allow limited number of users per site and if you don't release your connection this sort of thing is bound to happen.


Good programming practice clean your stack before leaving.

consider a network filter.

use a web developer tool like Visual Web Developer. It will show you all the errors.

you need to verify with your host if they have php enabled on the server usually php is a common thing.

do you own the hosting server?

it is in the directory you installed php. just click start->search (on XP) and search for php.ini on your local drive.

Ok step by step.

1. Declare variables as follows:
a. $to which is the email address to send to
b. $subject which is the subject of the email
c. $message which is the message body
d. $sender which is the sender of the email in the format of From:xx@xx.Bleep

2. call mail with the variables as parameter which is
mail($to, $subject, $message, $sender)

thats all the smtp server will send the mail. Just try it. Practice make you know things in programming not theory.

<?php
$to = 'example@host.com; //change this to valid email address
$subject = 'subject'; //the subject goes here
$message = 'message'; //this is the message body
$sender = 'From:webmaster@example.com'; //this is the senders address
if (!mail($to, $subject, $message,$sender))
{
echo 'error in sending mail';
}
?>

Change to a valid email address, subject, message etc as indicated in the comments. Remember all are string.

PHP 4 and above.

what kind of script?

sherrif222:
Plase i need help how to get a database management system for a hospital, i need it urgently am very new to acess .

This is just like asking a doctor I need help on how to perform surgery I am new to blades and knifes I need to do it urgently.

Who have you employed here to sit down and wait for your post and give you immediate response? if it is that urgent.

01 CIVICE Radio Code: 53243 - use 1-5 radio presets to enter / if error message appear & locks up radio, then you need to disconnect neg- battery terminal for 2 minutes

With the words VB and SQL I know you will be dealing a lot with database. From my experience you need to know database strcutures and databases in particular for example MS-SQL, mySQL, MS Access I think these are the common database in use including oracle but a bit expensive.

Learning database is all about how to connect your program to the database and structuring the database for example what type of value your database hold. For example if you have a database that stores Name, Address, Age, Telephone Number then the structure of your database would likely be String, String, Integer, string for each field respectively. For the most part if your database is well structured you dont have to worry about it most of the functionalities are handled automatically for example by the SQLSERVER. The next thing is SQL statements be good at SQL statments.

Here is the difficult part linking your program with the database for example populating forms. I did a work on large amount of data and it got very tricky. Things I had to implement were good memory management, less use of resources (for example hard-disk, processor) You would not want to write a program that for every data it needs it has to query the database this will consume your cpu speed and slow down the system. So you have to be able to read into memory and call from memory. This read into and call from memory can be done using List Data Structures or arrays but in large databases you would definitely need List.

In conclusion you need to know Collection in VB, Resource Management in Computer. VB is a managed language meaning you dont have much control over your hardware in most cases this is done automatically for you which is some what a plus. For linking your program to database master Microsoft ADO (ActiveX Object).

http://en.wikipedia.org/wiki/Computer_programming


http://en.wikipedia.org/wiki/Software_development

hope it helps.

I'd advice you to go with How To Progam by Deitel it will guide you through up to algorithm and data structure. In school they wont start you off with algorithms and data structure. First it will be hello world then UML or pseudocode then control structures, variables and it keeps building up. If you start with a higher level course you will just confuse yourself and not get the right picture. Deitel books are available in almost all high level programming language. So it is for you to pick the right language you need and everything is in there, for example if you think VB.net is what you need then go for it once you are through with the book you will be a real guru in Visual Basic and generic programming.

Back to your first question you can get it at any bookshop selling advanced books available in the major cities average N3K - N5k I dont know of now or amazon.com if you want the original copy in color format.