Women in Technology

Hear us Roar



Article:
  MySQL Crash Course, Part 2
Subject:   Imbedding mysql source in objects
Date:   2004-01-23 07:32:58
From:   sunwalker
I need help. I'm into a problem where I need to execute some mysql code (PHP) in a delayed fashion. Basically it's a drop down menu, that needs to run when it's echoed to the browser, but not when it is first accessed. The reasoning is to have the mysql do it's thing from within a pre-made template, but not until then. Anyway, I'm preloading all the HTML and (hopefully) the PHP containing the mysql into strings and then echoing them from a function that spews out the code and executing the mysql code. Is this the correct way to do things? And if so how can I imbed the mysql code into my string? If not is there a better approach? I really don't have any experience with objects, so that may be a big part of my problem.


This is my code for the menu:


<?php
echo "<select name='MyCounty' size='1'>";
$query = "Select * from Counties ORDER BY County asc";
$result = mysql_query($query);
$RowNum = mysql_numrows($result);
$i = 0;
WHILE ($i < $RowNum) {
$row=mysql_fetch_array($result); $MCounty=$row["County"]; echo "<option value='$MCounty'>$MCounty</option>"; $i++;
}
echo "</select>";
?>

Full Threads Newest First

Showing messages 1 through 1 of 1.

  • Imbedding mysql source in objects
    2004-04-16 13:13:49  willis1480 [View]

    I am no expert, but the php and mysql code will be parsed before it is sent to the client. You can generate whatever html content you like into hidden div boxes. Then use a javascript that when loads will have a delayed execution. Im not sure I understand your question.
    goodluck