need help with php :(

[shawn10642]

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

[Maq]

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 "";

 

[shawn10642]

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

[gristoi]

$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>";

[Maq]

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?

[shawn10642]

get me an "internal server error".

[shawn10642]

$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

[Maq]

$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.

 

[shawn10642]

$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

[shawn10642]

... i mean double

 

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

 

 

[Maq]

Change this line to:

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

[shawn10642]

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 

[Maq]

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.

[gristoi]

$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>

[shawn10642]

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>

[Maq]

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);

[gristoi]

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?

[shawn10642]

getting internal server error

[gristoi]

Paste the code You've got so far

[shawn10642]

<?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  :'(

[shawn10642]

<?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.