Welcome! Log In Create A New Profile

Advanced

i need help with php and sql

Posted by kebbyaliu 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
i need help with php and sql
February 08, 2013 05:23PM
i am trying to retrieve a data according to the register form,in my second form i can find my drop down list working but when i select one of it is not displaying the information in the table that was registered from my first page.
this is my code.

mysql_select_db($database_universal, $universal);
//to select the invoice number from first page//

$query_ProForma = "SELECT inv_no,product_name FROM ho_add_stock_proforma";
$ProForma = mysql_query($query_ProForma, $universal) or die(mysql_error());
$row_ProForma = mysql_fetch_assoc($ProForma);
$totalRows_ProForma = mysql_num_rows($ProForma);
$insertID = mysql_insert_id();



//to display the drop down list which is doing and working//

<p>Pro Forma Invoice Number<br />
<label for="pro_inv_no"></label>
<select name="pro_inv_no" autofocus="autofocus" class="dropdown_long" id="pro_inv_no">
<option value="Selected">Select Invoice Number</option>
<?php
do {
?>
<option selected="selected" value="<?php echo $row_ProForma['inv_no']?>"><?php echo $row_ProForma['inv_no']?></option>
<?php
} while ($row_ProForma = mysql_fetch_assoc($ProForma));
$rows = mysql_num_rows($ProForma);
$id =" pro_forma_inv_no";
$selected="selected";
if($id==$selected){
for ($j = 0 ; $j < $rows ; ++$j){

mysql_data_seek($ProForma,$rows[0]);
$row_ProForma = mysql_fetch_array($ProForma);

} }
?>
</select>
</p>
//to display the data to the field after selecting on the option which is not doing//


<td scope="col" > PRODUCT NAME<input name="pro_product_name" type="text" class="table_fields" id="product_name"
size="10" value="
<?php
echo $row_ProForma['product_name']; ?>" />
</td>
Re: i need help with php and sql
February 08, 2013 07:50PM
Are you sure you doing ICT2613?

There are no invoices, products or drop down lists.
Re: i need help with php and sql
February 09, 2013 10:31AM
not yet registered for ict2613,
pls this a project of my own.that i need help on
avatar
Mac
Re: i need help with php and sql
February 10, 2013 04:49PM
Yip, I need help with bond repayments smiling smiley Not knocking you, but please understand that as much as we would like to help you, there simply is no time on our side sad smiley.This is a course-specific forum, so rather try one of many other PHP forums on the 'net. Sorry mate.
Re: i need help with php and sql
February 11, 2013 08:02PM
Hahaha, Just got trolled, You sir deserve my like (If only there was a thumbs up spinning smiley sticking its tongue out)
avatar Re: i need help with php and sql
February 11, 2013 10:19PM
hahaha! thumbs up smiley

----------------------------------------------------------------------------------------

int get_random_number() {
return 4;
}
Re: i need help with php and sql
February 22, 2013 09:05PM
Sorry, only registered users may post in this forum.

Click here to login