if its id is in table2, and if it isn't, display it...but this seems
excessive.
I went through all of the functions to use in a WHERE clause in my MySQL
book...am I missing something?
Thanks,
--
Katie Evans-Young
Web Developer
Evans-Young Designs
E-mail: [EMAIL PROTECTED]
---
Outgoing mail
NIPP, SCOTT V (SBCSI) wrote:
I am trying to populate an array from a MySQL database. I think I
have the code correct to populate the array, but I need to somehow
sort the array eliminating duplicate values. I think I can loop
through the array doing a comparison and building a new
Irin said:
$sql = mysql_query(SELECT * FROM class where timetable_day='Monday');
$row = mysql_fetch_array($sql);
$result = $db-query($sql);
$numofrows = mysql_num_rows($sql);
From the PHP manual:
array mysql_fetch_array ( resource result [, int result_type])
You can't send the function
Irin said:
$sql = mysql_query(SELECT * FROM class where timetable_day='Monday');
Oops, I see that he DID do a mysql_query and save the result resource in
$sql. Sorry, guys! I haven't had my coffee yet this morning!
Katie Dewees
Web Developer
E-mail: [EMAIL PROTECTED]
--
PHP Database Mailing