Code: Select all
<form method="post" action="<?php echo $_SERVERї'PHP_SELF']; ?>">
<input type="text" name="projectid">
</form>
<br>
<?php
if (!empty($_POSTї'projectid']) ) {
$projectid = $_POSTї'projectid'];
$storenumber = "SELECT storenumber FROM $projectid WHERE storenumber > 0";
$user = 'blahuser';
$pass = 'blahpass';
$db = 'projectsdb';
$link = mysql_connect('localhost', $user, $pass) or die('<p>Could not connect to MySQL server.</p>');
mysql_select_db($db) or die('<p>Could not select '.$db.' database');
}
?>
Store#:<?php echo $storenumber; ?>Code: Select all
SELECT storenumber FROM $projectid WHERE storenumber > 0Is there something wrong with what I am doing, or is there an easier way or more complex way?
Thank you,
Outlaw