HI, The script i use at the moment give me a result from the db from different tables, What i would like to do is to insert the data exacly as is into a single db table, Instead of printing it to the screen
Here is my current code
<?php
include("includes/db.php");
if ($csh_cust_id); {
$result = mysql_query("SELECT * FROM csh_equipment WHERE csh_cust_id=$csh_cust_id",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf(" %s;%s;%s;%s;%s;%s;%s\n", $myrow["csh_equip_code"], $myrow["csh_equip_type"], $myrow["csh_equip_class"], $myrow["csh_equip_desc"], $myrow["csh_equip_rent"], $myrow["csh_equip_date"], $myrow["csh_equip_br"]);
} while ($myrow = mysql_fetch_array($result));
} else {
echo "No data were found!";
}
}
?>
The Current Result looks like this
csh1023;Full Tower;System 4;pentiuim4 512 Mb Ram 40gig HDD CDRW;400;0000-00-00; csh026;Printer;Laser;HP Laser Printer;120;0000-00-00; csh976;Monitor;17 Inch CRT;Samsung 17 inch;70;0000-00-00;
NB : I want to use the result for a EXPLODE command in another script
Thanx in Advance
