drop down box

Anon

hi, this is driving me insamne so im hopeing someone can help.

ok heres the situation

i have a mysql database and am trying to use php to get information from the "news" table in the database and shove it in a drop down box ive had loads of attempts but nothing comes even close to working....

now in the db there is sevrral bits of information but the 1 that i want to use in the drop down box is the "title" of the news and theni want to create a link to it, ive created a small retreval system with just links and a query to show the news but i cant get it to go in a drop down box can anyone help 🙂

i know this isnt close but im trying to get something to work so i can expand on it but nothing seems to work

FORM>
<SELECT NAME="news">

<?php
//include("newsconf.php");
//include('time.php');

$news_query = mysql_query("select * from $news_table where record_number=\"$title\"")
or die("Query broke! $news_query");

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

while ($news_query = mysql_fetch_row($result)) {

echo "<OPTION VALUE=\"$row["title"]\">$row["source"]</OPTION>\n" ;

}
?>

</SELECT>
<INPUT TYPE="submit" >
</FORM>

trooper

Rob,

here an example piece of code for you

$news_query = mysql_query("select * from $news_table where record_number=\"$title\"")
or die("Query broke! $news_query");

$num_results = mysql_num_rows($news_query);

print "<select name=\"news\">\n";
for($i=0;$i<$num_results+1;$i++)
{
$row = msql_fetch_array($news_query);

print "<option value=\"$row["title"]\">$row["source"]</option>\n";

}

print "</select>\n";

Thing you needed to do was work out how many options there will be.

let me know if this helps

Gary Mailer

Anon

k thanks will tell ya in 15mins 🙂

Anon

http://www.tekforums.com/php/news/testdropdown.htm thats where im testing it still having lots of problems, im still learning php though, i do undertsnad all the logic as i program in c++ but its when its todo with mysql :?

trooper

Rob

send me the code you've written along with the fields in the database you are trying to pull from

Gary

Anon

It may have something to do with this
section:

$result = mysql_query("SELECT * FROM information");
while ($news_query = mysql_fetch_row($result)) {

Are you trying to compare two full rows of data? Possibly you need to extract the record_number from the news table
and compare just that in your while loop.

Hope that helps.
PS. If you post the structure of the
mysql tables we could get a clearer idea.

all the best.
Peter.

Anon

sorry about the vaugeness, ive been messing with php all day. heres whats in the db ;

Field Type Attributes Null Default Extra Action

record_number int(10) UNSIGNED No auto_increment Change Drop Primary

Index Unique

title varchar(255) Yes NULL Change Drop Primary Index Unique

entry text Yes NULL Change Drop Primary Index Unique

time timestamp(14) Yes NULL Change Drop Primary Index Unique

source varchar(100) Yes NULL Change Drop Primary Index Unique

if this seems abit dodgy its becuase ive pasted it straight out of phpmyadmin 2.2.0

thanks....

peter_geo

Hi Rob,

This should work for you.
I made the table a little easier to work with
but the code should remain the same.
Hope that helps.

All the best,
Peter.

Here is the table structure i used:

DROP TABLE IF EXISTS information;
CREATE TABLE information(
record_number int(10) NOT NULL,
title varchar(255),
entry text NULL,
source varchar(100),
PRIMARY KEY (record_number)
);

Dumping data for table 'salary'

INSERT INTO information (record_number, title, entry, source)
VALUES ( '0000000001', 'Title 1', 'text field 1', 'source 1');
INSERT INTO information (record_number, title, entry, source)
VALUES ( '0000000002', 'Title 2', 'text field 2', 'source 2');
INSERT INTO information (record_number, title, entry, source)
VALUES ( '0000000003', 'Title 3', 'text field 3', 'source 3');

Here is the PHP code:

<?php

include("goconfig.php");
//holds the variables for hostname, username, password used in mysql_connect below

echo "<body>";

$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");

$news_query = mysql_query ("SELECT * FROM gores.information") or die ("Invalid query");
// I use the format database_name.table_name, in this case my database is called
// gores

echo "<FORM action=\"whatever_happens_next.php\" method=\"POST\">";
echo "News Title: ";
echo "<select name=\"title\">";

while (list($record_number, $title) = mysql_fetch_row($news_query))
//extract what I need using list
{
echo "<option value=$record_number>$title</option>";
}
echo "</select>";
echo "<INPUT TYPE=SUBMIT NAME=Submit VALUE=\"submit\">";
echo "</FORM></body>";
?>