Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><em><strong>ANSWER:</em></strong></p> <p>your code:</p> <pre><code> while($result = mysql_fetch_array($query)) { echo '&lt;div class="form"&gt;'.$result['employeeName'].'&lt;/div&gt;'; } </code></pre> <p>should be:</p> <pre><code> while($res = mysql_fetch_array($result)) //changed to the name of the variable that stores the query (can't store the array in a variable named after the query so i've changed it to $res...) { echo '&lt;div class="form"&gt;'.$res['employeeName'].'&lt;/div&gt;'; } </code></pre> <p><strong>OLD:</strong> Are you retrieving the result of the query? To return just one result use the mysql_fetch_assoc() function and to return an entire row (or more variables) use mysql_fetch_array().</p> <p>Example: </p> <pre><code> $test = mysql_fetch_assoc($query); $array = mysql_fetch_array($query); </code></pre> <p>Ps. To Select an array use a syntax similar to : </p> <pre><code> "SELECT * FROM table WHERE var = condition" </code></pre> <p>PPs. This was taken from php.net:</p> <pre><code> This extension is deprecated as of PHP 5.5.0, and is not recommended for writing new code as it will be removed in the future. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API. </code></pre> <p><strong>EDIT:</strong></p> <p>Your code: </p> <pre><code> $query = mysql_query("SELECT employeeName FROM employeeForm WHERE companyName='$employeeName'") or die(mysql_error()); </code></pre> <p>You treat the variable as text (variable name not content :) )... use: </p> <pre><code> WHERE '".$employeeName."' </code></pre> <p>to parse variables into query... (observe the double quotes)</p> <p><strong>Also</strong>... to access the results of the query use something like:</p> <pre><code> $array['COLUMN NAME']; </code></pre> <p>..assuming you use : $array = mysql_fetch_array($query); </p>
    singulars
    1. This table or related slice is empty.
    1. POUsing select for GET variables
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSpiderLinked
    1. USSpiderLinked
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes, I'm using something like: while($array = mysql_fetch_array($query)) Looping the row content. But I can't get this to work.
      singulars
      1. PO
      1. USAnna
    2. COdo you get any errors or the problem is that the content isn't written on the page?
      singulars
      1. PO
      1. USSpiderLinked
    3. COCan you please post the part of your code concerning the whole cycle please?
      singulars
      1. PO
      1. USbriosheje
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload