aneeka

Good day! Anyone knows how to select latest record of an item..here's the scenario. I have records with the same data except for the date. Example: product_code productname item_code date PR-123 abc TY-01 2011-10-11 PR-123 abc TY-02 2011-10-11 PR-123 abc TY-01 2011-10-13 PR-123 abc TY-02 2011-10-13 PR-123 abc TY-01 2011-10-16 …

help me please, i need to save the values of everything in the table but the value that can be save is the value of the last record only. i have this code below. [CODE] $answer = mysql_query("SELECT * FROM tbl_empinfo where empdept = '$userdept'") or die(mysql_error()); echo "<table border …

hey guys, i have this code in php i don't know if this works but there is no error at all. i am trying to get the value from a database and assign it as the value of the combo box. [CODE]echo "<td align=left><font size = '2'><select name='status' id='status' selecteditem='$status'><option>Active</option><option>Resigned</option></select>"; …

How can I join MySQL tables from different databases when the only similar field is the primary key of the first table in Php?

Anyone, please help me here. I created a view in mysql but when I use it in my code in php, an error appears that the view doesn't exist. What can I do? Here is my code. [CODE] $count = mysql_query("SELECT COUNT(*) FROM ViewName where ftTimeIn != '' AND ftTimeOut …

good day mates! is there any alternative for this code? i need to get the user input so i can count the number of records to a condition. [CODE]$result = mysql_query("SELECT * FROM exam order by rand()") or die(mysql_error()); echo "<center><font size=2 face=Arial><b>Awareness and Reminders</b></font></center><br/>"; echo "<font size=1 face=Arial><b>Type in …

good day! Please help me here, I need to count the record according to my condition but with my code it only counts the last record in the table in MySql. Here is my code.. Thanks! [CODE]<?php //establishing connection mysql_connect("localhost", "abc", "bbb") or die(mysql_error()); $submit = $_POST['submit']; $cancel = $_POST['cancel']; …

Good day! How can i display the data from Mysql with the least value of primary key and when a user clicks the next button the next to the least data will appear and then the next and so on? Please help me here, thanks!

Good day people! May i know how to assign value to a textarea the data from a database. I tried the following codes but they didn't work. [CODE] <?php echo "<textarea name='aaa' rows='4' cols='70' value='$abc'></textarea>" ?>[/CODE] [CODE]<textarea name="question" rows="4" cols="70" value="<?php echo $question2; ?>"></textarea>[/CODE] please help me!

Anyone, help me here. Is my code possible? I need to assign the total number of records from the database query to the graph of javascript. [CODE]]<?php mysql_connect("localhost", "aaaa", "aaa") or die(mysql_error()); mysql_select_db("aaa") or die(mysql_error()); $result = mysql_query("SELECT * FROM table WHERE field ='1'") or die(mysql_error()); while($row = mysql_fetch_array($result)) { …

please help me visualize an online examination, i dont know where to start...:icon_sad:

Help!! I need to generate a bar graph out of the data from the MySql database, could anyone help me here? Thanks!

Anyone, please help me here.:( How can I draw a line graph using PHP with data from MySql database? Do you have sample code for this? Thank you!

Is there anyone knows how to display a blob datatype from MySql database to the RptImage in Visual Basic 6.0 Data Report? Help me, please!!:-/