benji_182
-
Posts
4 -
Joined
-
Last visited
Never
benji_182's Achievements
Newbie (1/5)
0
Reputation
-
Hmmm, personally I'd try it like this. <?php include("cxn.php"); $query = "SELECT manufacturer FROM list ORDER BY manufacturer ASC"; $result = mysqli_query($cxn,$query) or die(mysqli_error()); ?> <select name="manufacturer" id="manufacturer"> <option value="" selected="selected">Select a Manufacturer..</option>"; <?php while ($row = mysqli_fetch_row($result)) { echo "<option value=\"{$row["fieldname1"]}\">{$row["fieldname2"]}</option>"; } ?> </select> Hope this helps.
-
Hi, I'm currently working on an Intranet system and need to create some sort of rota/schedule program. Preferably based in php/mysql. Are there any systems currently available that'd do this for me or would it be best to code from scratch? All it basically needs to be is a list of all the days in a month with a slot for someone to put their name so it needs to be easy to update. Any ideas guys? benji
-
YOU......ARE MY Best friend ever!
-
Whilst I'm reasonably good at PHP I get stumped from time to time on the correct syntax when dealing with HTML and PHP. I'm working on this bit of code to create a basic content management system and fallen at one of the first hurdles. When trying to echo out the information from the DB into a loop I can't quite get the syntax right. Tried numerous methods but won't seem to work. Your help would be most appreciated! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <? include ("conninfo.php"); $query="SELECT * FROM cpaa"; $result=mysql_query($query)or die("Query Broken"); ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <h1>Edit Standards</h1> <form action="confirmedit.php" name="edit"> <input type="<? while($r=mysql_fetch_array($result)) { echo "<input type="text" name="test1" value="/$r["cpasubname"]/"/>"; } ?> </form> </body> </html> Sorry for such a basic problem. benji