A simple mysql has me stumped

minuteman

I have a mysql query that works fine except for one item. It returns empty, giving only a null value when there is in fact data in the db. Here is the query
$sql1 = "SELECT * FROM mdl_university order by '$srtdata'";
$result1 = @($sql1, $conn) or die("Couldn't execute 'Continue addition' query1 ".$sql1);
while ($row = mysql_fetch_array($result1))
{

$university_num =$row['university_num'];
$course_webaddress = $row['course_webaddress'];
echo 'line 46 course_webaddress =', $course_webaddress ;

The last echo comes up empty even though all the other vars in the query work fine.

On the mysql side, if I do the query from mysql admin I get the expected results.(the course_webaddress column will output its contents from a query)

So what can be keeping "$course_webaddress = $row['course_webaddress'];" from working properly?

TheDefender

What happens if you just echo the variable without the rest of the line?

echo $course_webaddress;

Also, concatenate it with the period and not the comma...

echo 'line 46 course_webaddress ='.$course_webaddress;

Mordecai

Originally posted by TheDefender
Also, concatenate it with the period and not the comma...

He wasn't concatenating, though. It's just a separate argument to echo.

TheDefender

Sorry, yeah... I stand calibrated Mordecai 😉

minuteman

Hi defender,

The extra text in the echo statement is just my de-bugging crumbtrail. It makes a post so I know it was saved, it shows me where it is in relation to a loop, it has the var name so I can identify it, and it has the line number so I can find it again to remove it :p It's a nice little debugging trick I use alot. Most of the time when I'm done I'll simply just comment it out in case I need it again.

Anyway, I did remove the extra text and still no value in $course_webaddress

I even renamed the var in the db and in the code thinking it might be something with that. I think I'll try deleting the whole column in the mysql table and re-create it fresh.

TheDefender

Yeah, when Mordecai spanked me, I realized what you were doing... Do the cases match in your call to the field, and the field name itself?

$row['course_webaddress'] vs. Course_Webaddress (or something like that)

minuteman

Your guiding me right, defender. When you can't find the error just go back over it step by step. I had checked that to, typos, but checked it again and the spelling is ok. I even copied ithe name from the table column heading and pasted into the code.

I'm starting to suspect a corrupted file in mysql on the server. I had gotten some auto increment errors in this table about the same time as this started.

If you think of anything else let me know, but that code should work. I'll contact support in the mean time.

Check out my site at www.missionarynet.org if you get the chance.

be blessed.

TheDefender

Yeah, I usually find myself going back to basics when I know my code is right... Have you tried a repair on the table yet? (Obviously you'd want to copy the table first before hand, just in case something goes wrong with the repair, so you don't lose data)

I checked out the site you posted, and all I see is "Hello", so Hello to you too 😉

minuteman

Sorry to be so long in getting back to you. Well, the "hello" tells me at least some of the domain name is resolving. I started to move the website yesterday to a new server but it was still showing normal from my computer. That's why I mentioned it. In fact, my cumputer shows the full website still. And the funny part is that I used Frontpage to build that site and it won't let me upload to the new one without a domain name. Until the name resolves foe me I can't reload the site.

Anyway, while I was trying to put that fire out I didn't get to the table. Thanks for the reminder about backing up. This is a construction project so the data is test data, but it would still take some serious time to reinstall.