How do you use mysql? Is there a better way?
Posted: Mon Apr 11, 2005 9:35 am
Just thought I would pose the question. I am doing alot of large database updates, inserts, ect... and I am doing alot of my work with while loops and if then statements which works but at this point I believe there must be a better way.
This is what I mean:
Yes I do use OO regularly...
Thanks for your 2 cents...
This is what I mean:
Code: Select all
<?
$tag_data = mysql_query("SELECT * FROM `XXXXX` WHERE `PEOPLE_CODE_ID` = '$idnum'")
or die ("Not Found");
$tag_array = mysql_fetch_array($tag_data, MYSQL_ASSOC);
$power_id = $tag_array['PEOPLE_CODE_ID'];
$lname = $tag_array['LAST_NAME'];
$fname = $tag_array['FIRST_NAME'];
$year = $tag_array['ACADEMIC_YEAR'];
$app_stat = $tag_array['APP_STATUS'];
$email_value = $tag_array['EMAIL_ADDRESS'];
print "<b>$power_id</b> <br>\n";
print "$lname, $fname -- $year <br>\n";
print "$app_stat";
$sent_data = mysql_query("SELECT * FROM `XXXXX` WHERE `PEOPLE_CODE_ID` = '$idnum'")
or die("didnt find");
$sent_array = mysql_fetch_array($sent_data, MYSQL_ASSOC);
$contact_date = $sent_array['contact_date'];
$email = $sent_array['email'];
$snail_mail = $sent_array['snail_mail'];
$application = $sent_array['application'];
$openhouse = $sent_array['openhouse'];
$sports = $sent_array['sports'];
$equestrian = $sent_array['equestrian'];
$schol_fa = $sent_array['schol_fa'];
$aa = $sent_array['aa'];
$general = $sent_array['general'];
$choir = $sent_array['choir'];
$pipe_band = $sent_array['pipe_band'];
$personal_contact = $sent_array['personal_contact'];
$comment = $sent_array['comment'];
$has_visited = $sent_array['has_visited'];
$follow_up = $sent_array['follow_up'];
$intent_index = $sent_array['intent'];
if ($intent_index == '1'){
$intent = "Definitely";
}
if ($intent_index == '2'){
$intent = "Maybe";
}
if ($intent_index == '3'){
$intent = "Not";
}
if ($intent_index == '0'){
$intent = "Not Defined";
}
if ($contact_date == '') {
print "<br><br><b>Not yet called.</b>";
}
if ($contact_date != ''){
//display logic
?>Thanks for your 2 cents...