need help with php :(

This is reguarding a weather script

so i got this basic sql script

CREATE TABLE `cities` (
`id` int(11) NOT NULL auto_increment,
`city_name` varchar(100) NOT NULL default '',
`city_code` varchar( NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=240 ;
-- 
-- Dumping data for table `countries`
-- 
INSERT INTO `cities` VALUES (1, 'Vancouver', 'BC-50');

now that's all done i need to connect to the database, via php so

<?php

    // Connect to database server

    $hd = mysql_connect("localhost", "username", "password")

          or die ("Unable to connect");



    // Select database

    mysql_select_db ("weather", $hd)

          or die ("Unable to select database");
          
              
    // Select info              
    $res = mysql_query("SELECT * FROM cities", $hd)

          or die ("Unable to run query");

<NEED HELP HERE>

?>

Now under the NEED HELP HERE i need the script to run a form of cities that's auto populated by the sql DB above, and when that is selected, i need it to POST the city code BC-50, and that is the directed to another script with is already setup, can someone help me please

In the future, please place

tags around your code.

To loop through the results, use mysql_fetch_array.

In pseudo your code will look like:

echo "";
while(...)
{
   echo "{$row['city']}";
}
echo "";

I'm good at php, i've just hit a brain fart at the moment , i've been at this for 4 day's.

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<select>";
while($row = mysql_fetch_array($res))
{
   echo "<option value='{$row['code']}'>{$row['city']}</option>";
}
echo "</select>";

I'm good at php, i've just hit a brain fart at the moment , i've been at this for 4 day's.

Ok, well did that help you?  Did you try it?

get me an "internal server error".

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<select>";
while($row = mysql_fetch_array($res))
{
   echo "<option value='{$row['code']}'>{$row['city']}</option>";
}
echo "</select>";

Internal server error

$res = mysql_query("SELECT * FROM cities", $hd)
echo "";
while($row = mysql_fetch_array($res))
{
   echo "{$row['city']}";
}
echo "";

 

 

Internal server error

I don't think that has to do with the code.  Usually you get that error when you have a malformed .htaccess, missing php.ini or something like

that.

Check your error logs, specifically apache.

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<select>";
while($row = mysql_fetch_array($res))
{
   echo "<option value='{$row['code']}'>{$row['city']}</option>";
}
echo "</select>";

 

 

Internal server error

OPPS double

while($row = mysql_fetch_array($res))

it work, but not populating

... i mean double

$res = mysql_query("SELECT * FROM cities", $hd)

Change this line to:

echo "{$row['city_name']}";

echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";}echo "</select>

so this work to auto populate the form, but how do i POST the city_code.

thanks again, sorry i'm being a total noob right now 

echo "{$row['city_name']}";}echo "

 

so this work to auto populate the form, but how do i POST the city_code.

 

thanks again, sorry i'm being a total noob right now 

You need a form with an action.  Google and try it then come back for specific help.

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action ='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
  echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";}echo "</select>
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";

</form>

unfortunantly this doesn't work.

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action ='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
  echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";}echo "</select>
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";

</form>

There is an obvious error in the for loop.

Place these 2 lines directly following your opening <?php tags:

ini_set ("display_errors", "1");
error_reporting(E_ALL);

Define 'didnt work'. Just given an ambiguous answer like this is not helping anyone, I am trying to help you here, but you need to help yourself aswell. How did you reach the conclusion that it didn't post?

getting internal server error

Paste the code You've got so far

<?php

    // Connect to database server

    $hd = mysql_connect("localhost", "root", "1064111")

          or die ("Unable to connect");



    // Select database

    mysql_select_db ("weather", $hd)

          or die ("Unable to select database");
          
              
    // Select info              
    $res = mysql_query("SELECT * FROM cities", $hd)

          or die ("Unable to run query");


$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";
echo "</form>echo "</form>";echo "</form>";
<?php

    // Connect to database server

    $hd = mysql_connect("localhost", "root", "1064111")

          or die ("Unable to connect");



    // Select database

    mysql_select_db ("weather", $hd)

          or die ("Unable to select database");
          
              
    // Select info              
    $res = mysql_query("SELECT * FROM cities", $hd)

          or die ("Unable to run query");


$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";
echo "</form>"; 

i knoe there's something wrong, but flustered right now  :'(

<?php

// Connect to database server

$hd = mysql_connect("localhost", "root", "1064111")

or die ("Unable to connect");



// Select database

mysql_select_db ("weather", $hd)

or die ("Unable to select database");


// Select info 
$res = mysql_query("SELECT * FROM cities", $hd)

or die ("Unable to run query");


$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";
echo "</form>echo "</form>";
echo "</form>";

the other code above, had doubles.