creek16

Hi guys, I am creating a module that will get the value from mysql db and increment it. But my problem is it is mixed with a character. To give you an overview here's the format from the column vendor_code. "V001". So as you can see there a "V" on the data. How will I get the value and increment it? any idea. maybe some concatenation will do. thanks in advance.

Hi there! I'm using a query which will find a specific item in the DB. how do I assign it to a variable? This is my query: $qacatc = mysql_query("SELECT category_code FROM tblAssetType WHERE type_description ='$at' "); Now the result is only one specific string. How will assign the result to a variable? something like this: $result = $qacatc; //This line does not work. Just to clarify what I want. Is there other way than using this: while($row = mysql_fetch_array($qacatc)) { $result = $row['category_code']; } Thanks in advance!

Hello Guys. I'm getting confuse with <select> This is my first select <select name"selclassname"> <option ><center>- - - Class - - -</center></option> <?php $classresult = mysql_query("Select * from tblclasstype ORDER BY class_description"); while($classrow = mysql_fetch_array($classresult)) { echo "<option>" .$classrow['class_description']. "</option>"; } ?> </select> Now how do I get the value of the selected index which I will use in the next <select> for the query. My second <select> <select name"seltypename"> <option ><center>- - - Type - - -</center></option> <?php $typeresult = mysql_query("Select * from tblassettype WHERE asset_class = $SelectedIndexFrom1stSelect ORDER BY type_description"); while($typerow = mysql_fetch_array($typeresult)) { echo "<option>" .$typerow['type_description']. "</option>"; } ?> </select> Note that this is in the same page which no submit button will be executed. Thanks in advance.

Hi PHP newbie here. I'm Having problem with my simple Log-in Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\forum\checklogin.php on line 15 This is my code: <?php $con = mysql_connect("localhost", "Root", ""); if(!$con) { die("Failed to connect" . mysql_error()); mysql_close($con); } mysql_select_db("forum", $con); $un = $_POST['un']; $pw = $_POST['pw']; $result = mysql_query("Select * FROM tblAccount WHERE username='$un' AND password='$pw'"); while($row = mysql_fetch_array($result)) { echo $row['FirstName'] . " " . $row['LastName']; echo "<br />"; } /* if (mysql_num_rows("$result") > 0) { header('location:main.php'); } else { header('location:login.php?error=1'); } */ ?>