|
|
Posted by Martin Jay on 04/24/06 19:59
In message <ABM8kTGoDNTEFwCI@spam-free.org.uk>, Martin Jay
<martin@spam-free.org.uk> writes
>In message <3avk42ha27snejlt1f7q5uvvc35vni2glq@4ax.com>, cover
><coverlandNOSPAM914@yahoo.com> writes
>>On Sat, 22 Apr 2006 10:59:05 -0700, cover wrote:
>>
>>So I guess in short, what I'm looking for is a single field text
>>search to populate table 3 where the successful query result of this
>>form:
>
>$find=$_POST['equipno'];
>$table = /* name of your MySQL table */
>
>/* Connect and select your database as in input file */
>
>$item = mysql_query("SELECT * FROM $table WHERE equipno = '$find'");
>
>Then:
>$item['id'] is your id;
>$item['date1'] is your first date;
>$item['date2'] is your second date;
>
>etc.
Ooops, I forgot about mysql_fetch_array, it should be something like:
$item = mysql_query("SELECT * FROM $table WHERE equipno = '$find'");
$row = mysql_fetch_array($list);
Then:
$row['id'] is your id;
$row['date1'] is your first date;
$row['date2'] is your second date;
--
Martin Jay
Navigation:
[Reply to this message]
|