Re: [PHP-DB] grabbing data and auto email set users

2006-04-09 Thread Chris
JeRRy wrote: Hi, Okay I must be missing something here. I changed it to "mysql_query" and no errors produce however no emails are sent either. After cross-checking back and fourth with my db the entries are correct. A connection is made and establlished. maybe I need to place some eror

Re: [PHP-DB] grabbing data and auto email set users

2006-04-09 Thread JeRRy
Hi, Okay I must be missing something here. I changed it to "mysql_query" and no errors produce however no emails are sent either. After cross-checking back and fourth with my db the entries are correct. A connection is made and establlished. maybe I need to place some eror rec

Re: [PHP-DB] grabbing data and auto email set users

2006-04-09 Thread Chris
JeRRy wrote: Hi, I used the following but got this error: *Fatal error*: Call to undefined function: db_fetch() in */home/tassie/public_html/tipping/admin/check.php* on line *7* As I said: db_query will depend on your database (ie mysql_query or pg_query or other

Re: [PHP-DB] grabbing data and auto email set users

2006-04-09 Thread JeRRy
Hi, I used the following but got this error: Fatal error: Call to undefined function: db_fetch() in /home/tassie/public_html/tipping/admin/check.php on line 7 Any help please? J $query = "select * from users"; $result = mysql_query($query); while($row = db_fetch($result

Re: [PHP-DB] grabbing data and auto email set users

2006-04-09 Thread Chris
JeRRy wrote: Hi, No code here unless required. I run this tipping site. All user details are in a table called tipping which stores their id, username, password, email address, score and others. Than I have tables round 1 through to round 22. (all seperate tables) This i

[PHP-DB] grabbing data and auto email set users

2006-04-09 Thread JeRRy
Hi, No code here unless required. I run this tipping site. All user details are in a table called tipping which stores their id, username, password, email address, score and others. Than I have tables round 1 through to round 22. (all seperate tables) This is where users

[PHP-DB] Re: Help: Two dimensional array from table

2006-04-09 Thread El Bekko
Mark Fellowes wrote: I created an array to pull data out of one column in database. //Code for registered $usrregid = array(); do { $usrregid[] = $row_rs_usr_usr["usr_id"]; } while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr)); //end of registered ?> However I now need a second colu

[PHP-DB] looking for some help displaying reports with php

2006-04-09 Thread Aaron Bliss
Hi everyone; first, let me say that I'm really not a programmer (although I'm pretty good with scripting and so forth) so please pardon the newbie questions; I have a problem that I'm sure you will be able to help with a solution straight away; I'm running aide in our environment, and am just c