Insert to database

[wendystewart80]

Hi there,
I am trying to insert data in to a mysql database.
This error message comes up relating to $org and every other field:
Notice: Undefined variable: org in c:\inetpub\wwwroot\Wendy\Add.php on line 51his is the

Here is my php:
<?php
mysql_connect ("localhost", "root", "purple1");

mysql_select_db ('youth_services');

$query="INSERT INTO details (org, address1, address2, address3, city, pcode, la, tel,
fax, email, web, name, surname, cat1, cat2, cat3, cat4, cat5, cat6, cat7, cat8, cat9, cat10, cat11, gptext, image, date)
VALUES ('$org', '$address1', '$address2', '$address3', '$city', '$pcode', '$la', '$tel',
'$fax', '$email', '$web', '$name', '$surname', '$cat1', '$cat2', '$cat3', '$cat4', '$cat5', '$cat6', '$cat7', '$cat8', '$cat9', '$cat10', '$cat11', '$gptext'. '$image', '$date')
";
print("<p>");
print('$org ');
print("successfully entered in to database");
print("</p>");
?>

Any ideas how to define the variables?
Thanks

[thorpe]

where are all these variables comming from? can we see where you assign values to them?

[wendystewart80]

The varibles are the fields in my database and the fields in my html form for entry to the database
HTML Form:
<form method="get" action="Add.php">
Organisation: <td> <input type=text name=org size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Address:<td><input type=text name=address1 size=20 maxlength=30>
<tr><td width="25">
<td width="150"> <td><input type=text name=address2 size=20 maxlength=30>
<tr><td width="25">
<td width="150"> <td><input type=text name=address3 size=20 maxlength=30>
<tr><td width="25">
<td width="150"> City: <td><input type=text name=city size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Postcode: <td><input type=text name=pcode size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Local Authority: <td><select name="la">
<option value="1">National</option>
<option value="2">Outwith Scotland</option>
<option value="3">Aberdeen City</option>
<option value="4">Aberdeenshire</option>
<option value="5">Angus</option>
<option value="6">Argyll & Bute</option>
<option value="7">Clackmannanshire</option>
<option value="8">Dumfries & Galloway</option>
<option value="9">Dundee City</option>
<option value="10">East Ayrshire</option>
<option value="11">East Dunbartonshire</option>
<option value="12">East Lothian</option>
<option value="14">East Renfrewshire</option>
<option value="14">Edinburgh City</option>
<option value="15">Eilean Siar</option>
<option value="16">Falkirk</option>
<option value="17">Fife</option>
<option value="18">Glasgow City</option>
<option value="19">Highland</option>
<option value="20">Inverclyde</option>
<option value="21">Midlothian</option>
<option value="22">Moray</option>
<option value="23">North Ayrshire</option>
<option value="24">North Lanarkshire</option>
<option value="25">Orkney Islands</option>
<option value="26">Perth & Kinross</option>
<option value="27">Renfrewshire</option>
<option value="28">Scottish Borders</option>
<option value="29">Shetland Islands</option>
<option value="30">South Ayrshire</option>
<option value="31">South Lanarkshire</option>
<option value="32">Stirling</option>
<option value="33">West Dunbartonshire</option>
<option value="34">West Lothian</option>
</select>
<tr><td width="25">
<td width="150"> Tel: <td><input type=text name=tel size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Fax: <td><input type=text name=fax size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Email: <td><input type=text name=email size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Web: <td><input type=text name=web size=20 maxlength=30>
<tr><td width="25">
<td width="150"> First Name:<td><input type=text name=name size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Surname:<td><input type=text name=surname size=20 maxlength=30>
<tr><td width="25">
<td width="150"><b> Type of service:</b><tr><td width="25">
<td width="150">
Training, Education and Employment <td><select name="cat1">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Education, Advice and Information <td><select name="cat2">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Emergency Accommodation <td><select name="cat3">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Supported Accommodation <td><select name="cat4">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150">Housing Support <td><select name="cat5">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Long Term Housing and Accommodation <td><select name="cat6">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Counselling <td><select name="cat7">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Capacity Building <td><select name="cat8">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Mental Health <td><select name="cat9">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Drug/Alcohol Support <td><select name="cat10">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Other<td><select name="cat11">
<option value="1">Not relevant</option>
<option value="2">Relevant to some extent</option>
<option value="3">Very relevant</option>
</select>
<tr><td width="25">
<td width="150"> Describe other: <td><input type=text name=other size=20 maxlength=30>
<tr><td width="25">
<td width="150">Good Practice Example Text: <td><textarea name=gptext"
rows="6" cols="30" wrap>
</textarea>
<tr><td width="25">
<td width="150"> Image: <td><input type=text name=image size=20 maxlength=30>
<tr><td width="25">
<td width="150"> Date: <td><input type=text name=date size=20 maxlength=30>
<tr><td width="25">
<td width="150"><td>
<input type="Submit" name="Submit" value="Submit"><input type="reset" name="Clear" value="Clear">
</form>

[thorpe]

well it sounds like register_globals is turned off (which it should be), so these variables need to be referenced using the $POST[] or $GET[] arrays.

i see your sending the form via the get method, so all those variables need to be referenced like;

$_GET['org'];

[wendystewart80]

Thanks Thorpe.
Problem solved!