Normally I don't come on to a forum and ask questions before actually posting a few general topics, but promise I will maake a start on that after I post this...
I have the SQL statement, Everything is fine up till the point where i do the fetch_array.
I have run the SQL statement on the DB using my DB manager and it pulls out the values for the to fields.
$result is equally to a Resource ID, but the line $row = mysql_fetch_array($result) is not returning a value when I try and echo and of the results of ROW.
Could it be my DB Table structure? I have one table with the following fields
ID (INT AUTO...), UID (VARCHAR 10), Client(VARCHAR 255), Password(VARCHAR 8), HomePage (VARCHAR 255), Email (VARCHAR 255) Do I need to change the field data types.. After looking around at other scripts I seem to have everything in tact so Im a little bit lost..
Could there be somthing in my PHP or MYSQL config files that is causing it to be a pain..
Any pointers in the right direction would be great...
PHP Code:
$sql = "SELECT Client, HomePage FROM details WHERE uid='$u' AND password=PASSWORD('$p')";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
Dev Articles Community Forums Sponsor:
September 16th, 2004, 08:32 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
