using variables in another page

Posted on 16th Feb 2014 07:03 pm by admin

I have a test database set up on localhost. I have a form that I can type a name into, hit the button and it puts the name into the database and into a list on my page. it works fine. Now, I wanted to make a drop down list with all the names so that you could select one to remove that name from the database. So I did this

Code: [Select]<form>
<select>
<option><?php echo $name ?></option>
</select>
</form>

What that did was list the very last name in the list. What I thought it would do was list all the names based on the loop that I have set up to read all the names from the database. which is this

Code: [Select]$mysql = new mysqli('localhost', 'myusername', 'mypass', 'mydatabase') or die('not working');

$result = $mysql->query("SELECT * FROM myTable") or die($mysql->error);

if($result)
{
while($row = $result->fetch_object())
{
$name = $row->names;
echo $name . "<br />";
}
}

Now the while loop is in a file I called results and it is included in the index page with an include. I thought this would give me access to the $name variable and allow me to use it the same way it's being used in the loop. of course I was wrong, so how do I use it the same way?

Your Answer:

Login to answer

Other forums

Syntax Help
Code:


im having trouble with that code snipped
Parse error: syntax error, unexpec

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

ereg_replace issue
hi there people

i have this code happening with regards to my wamp server. is this something

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu

Parse error: parse error in C:wampwwwlogspagesmembers.php on line 16
I dont see the problem with this, I always get Parse error: parse error in C:wampwwwlogspagesme

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/