[PHP] Driving me nuts, need one second of your time

[cosmin laslau]

?
$query = SELECT * from mytable;
$result = mysql_db_query(db, $query);

while ($myarray = mysql_fetch_array($result))
{
$title = $myarray[title];
echo $titlebr;
}
?

Can someone PLEASE tell me why the coding above gives the following error:


Warning: Supplied argument is not a valid MySQL result resource in 
/var/web/somesite.com/html/index.php on line 5


It's absurd. It's driving me nuts. I'm about to introduce my computer to the 
pavement 40 feet below.

Thanks in advance for whoever sees what I am sure is a glaring and obvious 
flaw in the coding. I've been looking at it for an hours and just can't get 
anything from where I'm standing, maybe a different perpective will help.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Image width??

[cosmin laslau]

Hi,

Is there any function or command in PHP that will return the width an image 
(GIF)?

Thanks.

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Updating Timestamps

[cosmin laslau]

I'm using timestamps (God bless the little things) to keep track of database 
updates, so to give users the latest updates by the second. Kinda neat. But 
anyway, the timestamps are in one table, and when something is that table is 
changed, it automatically updates.

However, I have another table which I want to affect the timestamps. Is 
there a command for 'manually' updating a timestamp rather than by SQL's own 
logic?

Thanks in advance.

Cosmin Laslau

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Deleting from MySQL with more than one 'where' variable?

[cosmin laslau]

Ok, there's a table with 4 fields, I want to delete from it when two of the 
variables passed (through the function below) match up with the table's 
contents. However, I have only been able to get it to work with one 'where' 
clause, not two.

Here's my code for one:

function delete_one_sub($sel, $field, $update)
{
$query = delete from usr_stats where sel='$sel';
$result = mysql_db_query(f6, $query);
}

This was code for two variables:


function delete_one_sub($sel, $field, $update)
{
$query = delete from usr_stats where sel='$sel' and spec='$field';
$result = mysql_db_query(f6, $query);
}

However, that doesn't work. Help?

Thanks.

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] PHP Backing up a Database?

[cosmin laslau]

Hi,

Say I'm not really confident in the prowess of my server, and I want to 
download my database onto my computer. Can that be done? What can I look 
(FTP access) in the directory structure. I guess, where is it usually 
located?

Thanks.

Cosmin Laslau

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]