mysql_fetch_array & email question

Deathcard_Ace

Hi... I'm working on an email program and I'm getting quite confused with this error I keep getting: "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource"... Here is the questionable part of my code:

<?php
$access = mysql_connect(host,root,toor);
$select = mysql_select_db("db",$access);
$query = "INSERT INTO db '$id'";
$result = mysql_query($query,$access);

if ($id >= '4') {
$query2 = "ALTER TABLE db DELETE COLUMN id
&& ADD id SMALLINT NOT NULL AUTO_INCREMENT,
ADD PRIMARY KEY (id)";
$result2 = mysql_query($query2,$access);
} else {
$query3 = "SELECT * FROM db WHERE ($id == MAX('$id')";
$result3 = mysql_query($query3,$access);
while ($r = mysql_fetch_array($result3)) {
extract($r);

I can't seem to figure out what's wrong with that code... Any suggestions? Oh yeah - my e-mail question: for the "to" portion in the mail command if you extract results from an array could I perhaps use $to = "$email"; if I was storing the email address/es in the database?

bastien

$query3 = "SELECT * FROM db order by id desc limit 1";

will get you the last record inserted

yes you can use a variable to inidcate the value for the 'to' field... if the variable is to contain more than one value, do not use array but create a ';' separated list

ie name1 ; name2 ; name3...namen;

Deathcard_Ace

Thank you so much for you help... and sorry for the stupid question ><; I've gotten mysql_fetch_array before - it's just that I went to bed at 5:30 am and had to get up at 8 for work @_@;;; So my brain isn't fully functional.

bastien

I know the feeling

😃

lives4him06

hide your passwords for your mysql database!!!

Deathcard_Ace

Erm... I uh... I did ^{^;;} Why on earth would I use "toor" as a password? That's like a password you'd use on a Linux LiveCD OS... (If you didn't notice, it's "root" backwards...)

lives4him06

gotcha, sorry, i had to watch out, who knows, you could have been some green noob opening up his databases for the world to play with.