NYCPHP Meetup

[gadhra]

Josh,

Can you write your query like this:
mysql_query("select * from order")  or die ("query failed: <br>error_no: 
".mysql_errno()."<br>error: 
".mysql_error()."<br>query:$sql<BR><hr>$error_msg");

and tell us what happens?

Hans Zaunere zaunere-at-yahoo.com |NY PHP| wrote:

>--- "Joshua S. Freeman" <jfreeman at amnh.org> wrote:
>  
>
>>I've made a conceptual breakthrough (duh!) with regards to this project I'm
>>working on to really get to a meaningful skill level with MySQL/PHP
>>development.  But.. for some reason, I'm really stuck on this one point:
>>
>>I have a database called 'wasps'.  The database has 19 tables so far most
>>of
>>which are 'lookup' tables (is that the right term?)...
>>
>>The main table in the database is called 'specimens'.  Each 'specimen' has
>>a
>>taxonomy (order, family, genus, subgenus, species, subspecies).
>>
>>For each part of the taxonomy I have a separate table.
>>
>>Ideally, when someone loads the survey form to begin building a new record
>>in the 'specimens' table, I want to query those taxonomy tables (order,
>>family, genus, etc...) so that I can build
>><select><option></option></select> menus based on the rows inside each
>>taxonomic table...
>>
>>I want to do this using 'foreach'...
>>
>>I've tried a few different things but I can't get it to work:
>>
>>mysql_connect($host, $user, $password)
>>    or die("Could not connect to database");
>>mysql_select_db($database)
>>    or die ("Could not select $database database");
>>
>>print "The current database is $database";
>>
>>$query= mysql_query("select * FROM order");
>>    
>>
>
>I think you want to return to $result here, since it's used below.
>  
>
>>$result = $query;
>>        print ("<select name=\\"order\\">");
>>        foreach ($result as $key=>$val)
>>    
>>
>
>$result is not an array - it's a resource handle pointing to a chunk of
>memory that contains MySQL's data.  You'd probably want something like:
>
>for( $rows = array(),$i = 0,$rowcnt = mysql_num_rows($result); $i < $rowcnt;
>++$i ) {
>   $rows[] = mysql_fetch_assoc($result);
>}
>
>
>foreach( $rows as $rownum => $row ) {
>   foreach( $row as $colname => $colvalue ) {
>      echo "<br><br>$rownum => $colname => $colvalue";
>   }
>}
>
>
>.. for example.
>
>
>H
>
>
>  
>
>>        print "<option value=\\"1\\>$val</option>";
>>        print ("</select>");
>>        }
>>
>>?>
>>
>>but this does not work.. i know I'm close.. and I just spent 2 hours at
>>barnes & nobles at a table in the cafe with a bunch of PHP books (couldn't
>>find that WROX book someone suggested earlier)  trying to make this work on
>>just the order table because that table only has one record in it...  but I
>>could not make it work.. if I can figure out how to make this, I'll be able
>>to make considerable progress on this thing..
>>
>>Someone please help me over this hump!
>>
>>Thanks!
>>
>>J.
>>
>>
>>
>>
>>
>>
>>    
>>
>
>
>
>--- Unsubscribe at http://nyphp.org/list/ ---
>
>
>
>
>
>  
>

-- 
+gadhra+(/s)
*********************
XXXXXXXXXXXXXXXXX
And seize the metropolis;
It's you it's built on