Podrias ayudame en to ya que he paado un dia intentando varia cosas que he vito en la net y no conigo que funcione. Este eria el codigo php
<?php
mysql_connect("localhost", "user", "user") or die(mysql_error());
$_SESSION['dbase'] = "fac.clientes";
mysql_select_db($_SESSION['dbase']);
session_start();
if (!isset($_SESSION['page']) || !isset($_GET['page'])) {
$_SESSION['page'] = 1;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form action="?page=2" method="post">
<tr>
<td colspan="2"><div align="center"><strong><font size="+2" face="Verdana, Arial, Helvetica, sans-serif">Seleciona cliente</font></strong></div></td>
</tr>
<tr>
<td>Clientes: </td>
<td><select name="clientes">
<?php
$query = mysql_query( "SELECT nombre FROM fac.clientes" );
while($show = mysql_fetch_array($query))
{
echo '<option value="'.$show['nombre'].'">'.$show['nombre'].'</option>';
}
?>
</select></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="cliente" value=" -Submit- "></td>
</tr>
</form>
</table>
<?php
} else {
if (!isset($_SESSION['page']) && $_SESSION['page'] != 1) {
die('An Error has occured');
} else {
$_SESSION['page'] = 2;
$clientes=$_GET['cliente'];
//mysql_select_db($_SESSION['dbase']);
$que = mysql_query("SELECT * FROM `fac.clientes`");
echo $cliente;
}}
//'<option value="'.$show['nombre'].'"='.$clientes.'</option>';
//$row = mysql_fetch_array( $_SESSION['row'] );
//echo '<option value="'.$row.'">'.$row.'</option>';
//echo " Age: ".$row['age'];
?>
y eta la bbdd
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
--
-- Servidor: localhost
-- Tiempo de generación: 16-09-2009 a las 08:31:53
-- Versión del servidor: 5.1.36
-- Versión de PHP: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `fac`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `clientes`
--
CREATE TABLE IF NOT EXISTS `clientes` (
`nombre` varchar(50) COLLATE latin1_spanish_ci NOT NULL,
`CIF` text COLLATE latin1_spanish_ci NOT NULL,
`direccion` text COLLATE latin1_spanish_ci NOT NULL,
`direccion 2` text COLLATE latin1_spanish_ci NOT NULL,
`cp` int(5) NOT NULL,
`provincia` text COLLATE latin1_spanish_ci NOT NULL,
`telefono1` int(9) NOT NULL,
`telefono2` int(9) NOT NULL,
`movil` int(9) NOT NULL,
`web` text COLLATE latin1_spanish_ci NOT NULL,
`persona contacto 1` text COLLATE latin1_spanish_ci NOT NULL,
`persona contacto 1 telefono` int(11) NOT NULL,
`persona contacto 1 email` text COLLATE latin1_spanish_ci NOT NULL,
`persona contacto 2` text COLLATE latin1_spanish_ci NOT NULL,
`persona contacto 2 telefono` int(11) NOT NULL,
`persona contacto 2 email` text COLLATE latin1_spanish_ci NOT NULL,
`comentarios` text COLLATE latin1_spanish_ci NOT NULL,
`registro` text COLLATE latin1_spanish_ci NOT NULL
) ENGINE=CSV DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `clientes`
--
Mucha gracias