[Resolved] My next question (PHP)

flishess · Dec 3, 2007

My next question (PHP)

I am trying to get the "platforms" listed in my database to show up where "$platform" is at in the drop down box.

Code:

<?
include("config.php");
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="[COLOR=Red]$platform[/COLOR]">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

can anyone help out?

Peter · Dec 3, 2007

$platform is not within php tags. It should be:-

PHP:

<?PHP echo $platform ?>

Daniel · Dec 3, 2007

Is it even set to a variable yet, from the code it doesn't look like it is, unless you set it in config.php.

I'll be on in a few hours if you need help :tu:

flishess · Dec 3, 2007

here is what I have now, I tried it with GET and POST - neither of the two work.

Code:

<?
include("config.php");
$platform = mysql_real_escape_string($_GET['platname']);
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="<?PHP echo $platform ?>">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

I think it needs to say something about selecting the row that the table is, or something like that instead of GET or POST.

I also tried this, and it does not work either:

Code:

<?
include("config.php");
$platform = $row['platname'];
while($row = mysql_fetch_array( $result )) {
$result = mysql_query("SELECT * FROM platform") 
or die(mysql_error());
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="<?PHP echo $row['platname']; ?>">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

edit · Dec 3, 2007

Code:

$result = mysql_query("SELECT * FROM platform");

while ($row = mysql_fetch_assoc($result)) {

$platform = '<option value="' . $row['platname']. '">';

}
?>

<select name="platform">
<?php echo $platform; ?>
</select>

Not sure if that will work in this situation, as its just off the top of my head but test it out and let me know.

flishess · Dec 3, 2007

edit, I don't get any errors with your version, but It doesn't show up either with the platforms.

edit · Dec 4, 2007

I actually forgot a pretty important part of that code

Code:

$platform = '<option value="' . $row['platname']. '">';

Should be

Code:

$platform = '<option value="' . $row['platname']. '">' . $row['platname'] . '</option>';

flishess · Dec 4, 2007

Edit, that worked, however there are more than one Platforms listed in the database and it only shows the last one.

edit · Dec 4, 2007

try adding

Code:

$platform = '';

prior to the while statement. I ran a quick test on this on my home server and all came out ok. If this doesn't work, let me know and I'll continue to troubleshoot.

flishess · Dec 4, 2007

Like, this: it didn't work...

Code:

$result = mysql_query("SELECT * FROM platform");
[COLOR=Red]$platform = '';[/COLOR]
while ($row = mysql_fetch_assoc($result)) {

$platform = '<option value="' . $row['platname']. '">';

}
?>

<select name="platform">
<?php echo $platform; ?>
</select>

Barrucadu · Dec 4, 2007

Try this:

PHP:

$result = mysql_query("SELECT * FROM platform");
$platform = '';
while ($row = mysql_fetch_assoc($result)) {

$platform .= '<option value="' . $row['platname']. '">' . $row['platname']. '</option>';

}
?>

<select name="platform">
<?php echo $platform; ?>
</select>

flishess · Dec 4, 2007

mikor: Thanks that fixed it! Thanks to all those that helped!

edit · Dec 5, 2007

There we go, Thanks Mikor I knew I was missing a character somewhere

[Resolved] My next question (PHP)

Established Member

VIP Member

Danltn.comVIP Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Labossa.com

EarnSwap.com

iuov.com

PandoraNFT.com

pawblito.com

OHWallet.com

OhTodo.com

Wholeing.com

EnchantedLandscaping.com

VaporMod.com

Similar threads

We're social

Labossa.com

EarnSwap.com

iuov.com

PandoraNFT.com

pawblito.com

OHWallet.com

OhTodo.com

Wholeing.com

EnchantedLandscaping.com

VaporMod.com

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling