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: <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: $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

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Function to extract email attachments using PHP IMAP
function extract_attachments($connection, $message_number) {

$attachments = array();

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

MII Trends - add data onto chart object
Hello,

Can anyone please provide some thoughts on my current requirement:
its pretty

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page