php links from list menu dont work

[korbenmxli]

hi every one

i want to make a list from my database and if user click on one item it open a link... its a list of models of products so if click in one link me to the page of its full description, my database has the fields: "modelo" (model), and "paginal" the link page i make this code.. works fine cause display all the catalog but when i click in an item dont do nothing... hes the code.. what im missing??

tnx in advance

 

 

    <?PHP

// Connect to MySQL Server

@mysql_connect('localhost','user','password') or DIE("Couldn't Connect to MySQL Database");

 

// Select Database

@mysql_select_db('zerocctv_almacen') or DIE("Couldn't Select Database");

$sql = "SELECT modelo, paginal,precio,foto FROM modelos";

$result=mysql_query($sql);

$row_array=mysql_fetch_row($result);

$string='<select name=selection><option value=>modelo</option>';

 

for ($i=0;$i < mysql_num_rows($result);$i++)

{

if ($row_array[0]=="")

{

$row_array=mysql_fetch_row($result);

}

else

{

$string .='<option value="'.$row_array[1].'">'.$row_array[0]."</option>";

$row_array=mysql_fetch_row($result);

}

}

$string .='</SELECT>';

//echo "</label>";

echo $string;

?>

[requinix]

Simply clicking an item won't do anything unless you have some JavaScript code to make that happen.

If that's what you're talking about then that's what your problem is.

 

Otherwise

1. What does "dont do nothing" mean?

2. What does it do?

3. What is it supposed to do?

[korbenmxli]

it display all records in the database but dont link to the page associated to the record, example

record 1 in the database is

modelo                    paginal

SF-6032                6032.html

SF-6032IR              sfri.html

....

...

 

[requinix]

Well yeah it doesn't create a link. It creates a .

If you want a link use an .

[spiderwell]

if you wanted to use the select. you would need an onclick/change(i'm not sure which) event to post the form, then the receiving page could take the selected option value to generate a redirect to that page.

[korbenmxli]

use an <a>. ?? where i must use that option... sorry im kinda ne to php

[spiderwell]

he was refering to a link, you write a link in html:

<a href="page.php">page</a>

. you can then use php to echo out that

if you can't get the concepts of links and the difference with a select you might struggle

[socratesone]

You have some options here.

 

1) Keep everything you have, but wrap it in a form and create a button, like this:

 

?>

<form action="" method="post">

<?php echo $string; ?>

<input type="submit" value="go" />

</form>

 

...and at the top of the page, add some logic to check the value, and, if present, forward off to the page

<?php

if(isset($_POST['selection']) && and !empty($_POST['selection'])}{
  
  header("Location: http://www.example.com/" . $_POST['selection']);

}

?>

 

....or....

 

2) You can create links instead of a select box

 

// get rid of this
// $string='<select name=selection><option value=>modelo</option>';

// change this:
// $string .='<option value="'.$row_array[1].'">'.$row_array[0]."</option>";

// to this:
$string .= '<a href="'.$row_array[1].'">'.$row_array[0]."</a><br />";
// (you can also change this to any kind of format or wrapper for the <a> tag, such as wrapping them in <li> elements

// get rid of this
$string .='</SELECT>';

 

Hope that helps.

[korbenmxli]

hey!! tnx..  the suggest from socrates was the solution... i cant believe i was not think in something so simple... tnx 4 everything guys